meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 3 months |
| seen | 2 days ago | |
| stats | profile views | 96 |
|
May 13 |
awarded | Caucus |
|
May 13 |
comment |
Most efficient and practical way to store time values (HH:MM) in Oracle that makes it easily searchable I've never used this, but maybe it will help? docs.oracle.com/cd/B19306_01/server.102/b14225/… |
|
May 13 |
comment |
Multi-variance products @haki: Yes, that's a fair point. I suppose views could be created to filter on specific product_option_type_ids, but that wouldn't resolve any possible performance problems, it would just make queries a little more readable. |
|
May 13 |
answered | Multi-variance products |
|
May 10 |
revised |
MySQL DB Design edited tags |
|
May 10 |
revised |
Table design when one data is dependant of another and the second one has repeated values formatting |
|
May 10 |
suggested | suggested edit on Table design when one data is dependant of another and the second one has repeated values |
|
May 10 |
answered | notes / description string in another table in a relational database |
|
May 7 |
comment |
Group Database Entries by time difference You can probably use windowing functions to find out where the group boundaries are (sqlfiddle.com/#!12/015e6/13/0). I know you can create group IDs in Oracle with grouping functions, but I don't think Postgres has grouping functions yet... |
|
May 7 |
comment |
What is the meaning of this anomaly warning message? I often see this sort of thing with tables that have fields such for address lines: addressLine1, addressLine2, addressLine3. |
|
May 6 |
comment |
pros/cons of different ways to store whether a record is one of two options? @user1308743: The problem with Option 2 is that you have the potential for a record to have both set to true or both set to false. I don't think you'd ever do that on purpose, but hey - bugs happen! And when they do, it could be hell to figure out which should be true and which should be false. |
|
May 2 |
awarded | database-design |
|
May 1 |
revised |
Database Design Confusion added 516 characters in body |
|
May 1 |
answered | Database Design Confusion |
|
Apr 24 |
revised |
Storing data as rows as opposed to columns formatting |
|
Apr 24 |
suggested | suggested edit on Storing data as rows as opposed to columns |
|
Apr 19 |
suggested | suggested edit on How to join value of two tables |
|
Apr 19 |
comment |
Tool to export data with all relational data? ...Also make sure you have a way to reconcile the migrated data to ensure that everything migrated correctly. |
|
Apr 19 |
revised |
Unsure how to implement certain constraints and relations in this relational database schema corrected spelling, grammar |
|
Apr 19 |
suggested | suggested edit on Unsure how to implement certain constraints and relations in this relational database schema |
