PostgreSQL: Which Datatype should be used for Currency?
Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money … Read more
database-design
Storing money in a decimal column – what precision and scale? [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the … Read more
Surrogate vs. natural/business keys [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be … Read more
Is it better to use multiple databases with one schema each, or one database with multiple schemas?
After this comment to one of my questions, I’m thinking if it is better using one database with X schemas or vice versa. … Read more
How to version control a record in a database [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the … Read more
How big is too big for a PostgreSQL table?
I’m working on the design for a RoR project for my company, and our development team has already run into a bit of … Read more
Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?
In multiple courses, books, and jobs, I have seen text fields defined as VARCHAR(255) as kind of the default for “shortish” text. Is … Read more
Strings as Primary Keys in SQL Database [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the … Read more
What should every developer know about databases? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, … Read more
How big can a user agent string get?
If you were going to store a user agent in a database, how large would you accomdate for? I found this technet article … Read more