meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 2 years, 4 months |
| seen | Apr 27 at 13:12 | |
| stats | profile views | 100 |
Currently writing code for apps using & managing Postgres and mySQL databases, and involved in some data modeling efforts in the science informatics community, but in the past:
- PL/SQL programmer & DB admin in Oracle 8/8i/9i days.
- VBA programming in MS Access (sometimes w/ mysql or MSSQL backends)
- LDAP administration (Novell & iPlanet)
- Did some work w/ FileMaker databases (both standalone and dedicated server)
|
Feb 2 |
awarded | Nice Answer |
|
Jan 3 |
awarded | Yearling |
|
Aug 20 |
awarded | Popular Question |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
|
Feb 13 |
awarded | Taxonomist |
|
Jan 3 |
awarded | Yearling |
|
Nov 13 |
awarded | Nice Answer |
|
Nov 5 |
comment |
Small Squares or Blocks after string in table field When you say 'The ASCII equivalent is CHAR(32)' ... are you saying it's a 32 character long string, or that the strange character is ASCII#32 (which, assuming decimal, 32, is a space)? Based on the 'small squares' description, I'd have assumed it's a character that doesn't exist in the font you're using, but space should exist, and I don't think Excel has the equivalent of BBEdit's 'Show Invisibles' feature. |
|
Oct 31 |
comment |
Generate sample data for an Oracle database Why do people think it's different just because the database software changes? dba.stackexchange.com/questions/4814 ; dba.stackexchange.com/questions/449 |
|
Oct 26 |
comment |
What is an effective way of labeling columns in a database? @Jack : I've clarified that it was behaviour in older versions. But it's still a pain in the ass to have to join in 5 lookup tables that all have the columns 'name' and 'abbr', so you have to re-alias them every damned time. And your 'figure of speach' is looked upon rather poorly in this community. As a moderator, you should know that there's even a report of people disproprtionately voting. (or at least there used to be when I had moderator access) |
|
Oct 26 |
revised |
What is an effective way of labeling columns in a database? clarified that it was older Oracle behavior |
|
Oct 21 |
comment |
Website is too slow when number of records increases? Even if not for tuning reasons, you really should be using parameterized queries. If you're looping through thousands of users, as you suggest, you'll likely see some performance improvements, too. You may also want to focus on solving the deadlock issue directly, rather than just speeding up queries. As you specifically mentioned InnoDB, I'd have to ask -- what are your indexes? |
|
Oct 21 |
comment |
Is it possible for me to be notified if an 'after insert or update trigger' stops working? It doesn't need to be a trigger ... you just write a timestamp somewhere, and you look to see if that timestamp is drifting too far from now() ... it could be a stored procedure, or just a simple query against a table: select now()-last_run from tracking_table. (ah ... date arithmetic is so much easier in oracle) |
|
Oct 18 |
answered | Is it possible for me to be notified if an 'after insert or update trigger' stops working? |
|
Oct 13 |
answered | Should you design the database before the application code is written? |
|
Sep 30 |
comment |
What features of Oracle make it an attractive choice for small projects? @Martin : that's not a good sign ... I've been using postgres for one of our projects (as part of a packaged application) for ~2 years, and I still can't get it to perform well (in part because the parts of the application that I'm using relies heavily on count(), which seems to be postgres's achilles heel). I had to ask on stackoverflow how to influence the planner |
|
Sep 30 |
comment |
How to show the column names of a table with a simple sql query? +1 just for mentioning the fact that comments exist ... not enough people use them, and it's so nice to find them when you're taking over a database. |
|
Sep 28 |
comment |
What should I ask at a MySQL DBA interview? @DTest : but you have to be careful about personal questions ... there are lots of classes of questions that you're not allowed to ask, at least not in the US : eeoc.gov/facts/qanda.html |
|
Sep 28 |
answered | What should I ask at a MySQL DBA interview? |
