database-design Archives

Programming, sql

IT Nursery

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 ...

June 4, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

June 3, 2022
0 Comments

Database, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

Database, Programming

IT Nursery

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. ...

June 3, 2022
0 Comments

database-design, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

June 2, 2022
0 Comments

Database, Programming

IT Nursery

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 ...

May 31, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

May 30, 2022
0 Comments

Database, Programming

IT Nursery

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, ...

May 29, 2022
0 Comments

http, Programming

IT Nursery

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 ...

May 29, 2022
0 Comments