Reputation
3,526
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 26
Impact
~350k people reached

May
24
comment Tool to generate large datasets of test data
This might be a 'shopping list' question, but leaving it open is a useful resource, as these sorts of questions come up quite often. (just happened on StackOverflow-- stackoverflow.com/q/30427116/143791 )
May
15
comment change column type from string to numeric
If it's the format, see stackoverflow.com/q/8933782/143791 .
Jan
13
awarded  Notable Question
Jan
3
awarded  Yearling
Nov
4
comment Is there a good way to run a trigger for each record in a postgres table?
I really should've followed up years ago. It took me qute a while before I managed to get everything working in my system ... and this method works, but the performance was god awful. (it went from 30 min to over a day to complete).
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).