3,513 reputation
1026
bio website
location
age
visits member for 3 years, 9 months
seen Oct 17 at 18:08

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)

Sep
24
awarded  Autobiographer
Sep
12
accepted Can a PostgreSQL Trigger be used to ignore an insert?
Sep
11
comment Create food database
As a former moderator for cooking.SE, with a degree in library science ... I'd question your category of 'type of food' having values of 'breakfast', 'lunch' and 'dinner'. Those would be meals, but even then, a given dish may served at different meals depending on the culture (eg, pancakes), and there are a ton of foods that on their own isn't necessarily a meal (eg, an apple ... is it an ingredient? a snack? part of a fruit and cheese plate after dinner?)
Sep
11
asked Can a PostgreSQL Trigger be used to ignore an insert?
Aug
7
awarded  Enlightened
Jun
13
awarded  Enlightened
Jun
13
awarded  Nice Answer
Jan
7
comment Inventory Management DB Design
Yes ... it'd then have foreign keys to the tables it's joining. Minimally, it's just foreign keys to the tables it's joining, but it might also have some attributes itself (eg, tracking how many of the item are in a given bin).
Jan
7
comment Inventory Management DB Design
then you might want a join table between the item table and the table to track bins. (and it might make sense to call that one 'locations', or at least not call the bins table 'locations'). Join tables will slow down queries, but you won't be able to track items in more than one bin without it or allow duplicate skus in the items table.
Jan
7
comment Inventory Management DB Design
can bins be moved between shelves? can an item be in more than one bin (eg, if you have too much of something, might it be spread across two bins?)
Jan
3
awarded  Yearling
Oct
28
awarded  Nice Answer
Aug
14
awarded  Nice Answer
Aug
9
awarded  Nice Answer
May
26
comment MySQL CSV LOAD DATA INFILE … doesn't want to load more than 72 lines
Any reason you're doing this in php? If you can, that take that out of the picture and just send the command using the command line mysql client. (otherwise, I'd try a load w/ lines 1 to 72 removed, and see it it still loads ~72 lines (memory issue) or none (a problem w/ the input file).
Feb
2
awarded  Nice Answer
Jan
3
awarded  Yearling
Aug
20
awarded  Popular Question
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus