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 or FLOAT? 6 Answers 6
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 problem by editing this post. Closed 1 year ago. Improve this question I’m using a decimal column to store money values on a database, and today I was wondering what precision and … 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 answered with facts and citations by editing this post. Closed 7 years ago. Improve this question Here we go again, the old argument still arises… Would we better have a business key … 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. I’m developing a web application where, when people register, I create (actually) a database (no, it’s not a social network: everyone must have access to his own data and never see the … 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 problem by editing this post. Closed 1 year ago. Improve this question Let’s say that I have a record in the database and that both admin and normal users can do updates. … 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 a debate about the design, specifically the database. We have a model called Message that needs to be persisted. It’s a very, very small model with only three db columns other than … 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 there any good reason that a length of 255 is chosen so often, other than being a nice round number? Is it a holdout from some time in the past when there … 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 problem by editing this post. Closed 1 year ago. Improve this question I am not very familiar with databases and the theories behind how they work. Is it any slower from a … 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, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … 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 which recommends keeping UA under 200. It doesn’t look like this is defined in the HTTP specification at least not that I found. My UA is already 149 characters, and it seems … Read more
