meta user
network profile
| bio | website | xenoterracide.com |
|---|---|---|
| location | Austin, TX | |
| age | 28 | |
| visits | member for | 2 years, 4 months |
| seen | May 10 at 23:26 | |
| stats | profile views | 63 |
Desktop
- Gentoo Linux 2003 - 2009
- First experience with Linux 4Q 2003
- Long term functioning, dual boot, Linux install 4Q 2004
- Stopped using Windows on a regular basis, approximately 2006
- Arch Linux 2009 - present
Server ( well professionally, as I constantly run servers daemons on my desktop )
- CentOS 2006 - 2007, 2010 - Present
- BusinessGrade - Systems Administration Intern
- Liquid Web - Linux System Administrator
Student, Web Developer, Systems Administrator See more on my blog.
Extended Contact info: xenoterracide@gmail.com: email, msn, gtalk; xenterracide: yahoo,aim,freenode;---
|
May 2 |
accepted | update column based on the sort order of another query |
|
Apr 4 |
revised |
update column based on the sort order of another query edited tags |
|
Apr 4 |
asked | update column based on the sort order of another query |
|
Apr 4 |
comment |
Arbitrarily ordering records in a table how do you calculate the number in between? |
|
Mar 28 |
awarded | Notable Question |
|
Mar 6 |
comment |
Materialized View PostgreSQL of course when the beta's start hitting... or you could just build from source... |
|
Jan 11 |
comment |
PostgreSQL: how can queries possibly be “immutable” / functional? the inclusion of a functional feature does not mean that the language is purely functional, nore does the primary paradigm being something else preclude a functional feature. |
|
Jan 4 |
awarded | Yearling |
|
Nov 2 |
comment |
What AWS instance to choose for write-heavy PostgreSQL database server keep in mind that Virtual machines in general aren't designed for IO. If you're having problems it might be time to leave the cloud and get a hardware cluster. |
|
Oct 9 |
awarded | Enlightened |
|
Oct 9 |
awarded | Nice Answer |
|
Jul 17 |
awarded | Popular Question |
|
Jun 11 |
accepted | is id and phone number enough to uniquely identify a row in phone numbers |
|
Jun 11 |
comment |
is id and phone number enough to uniquely identify a row in phone numbers problem with storing them as anything but 5555551234 ... is are you sure international numbers consist of only 10 digits formatted that way? personal opinion, it's better to strip all formatting out of the database storage, saves space and is consistant to deal with. |
|
Jun 10 |
comment |
is id and phone number enough to uniquely identify a row in phone numbers yeah I get it, I'm just kind of adding discussion to make people think about the problem that phone numbers can really make. |
|
Jun 10 |
comment |
is id and phone number enough to uniquely identify a row in phone numbers to some degree, but if you're an international company I never wanted to deal with that complexity, 5 digit country code + 15 digit? phone number (I'd have to look) + 11 digit extension was enough not to worry about how the locals my store the local part. |
|
Jun 10 |
comment |
is id and phone number enough to uniquely identify a row in phone numbers note varchar 4 may be insufficient for extensions, because some ridiculous softwares allow extensions up to 11 digits long, just saying. |
|
Jun 10 |
comment |
is id and phone number enough to uniquely identify a row in phone numbers people consider storing them as some sort of INT? phone numbers are not numbers, but what I call "numeric codes" which means strings that consists of only digits, in which no math really makes sense. |
|
Jun 10 |
comment |
is id and phone number enough to uniquely identify a row in phone numbers but what if 0 is the valid extension... nothing prevents one from using 0 as extension (AFAIK though convention is an operator) |
|
Jun 10 |
asked | is id and phone number enough to uniquely identify a row in phone numbers |
