|
Yeah that's not a good idea. Don't do that.
|
# ? Jan 10, 2018 21:07 |
|
|
# ? Jun 8, 2024 08:17 |
|
don't do what and why
|
# ? Jan 10, 2018 21:15 |
|
Bloody posted:c database s: entity designer is reasonably needs suiting except that i have a corner case that is falling apart. in one table i am representing instances of Foos. elsewhere in our system, we take a fixed-size group of Foos (8 Foos) and use them as Bars. Basically, a Bar is a 8-tuple of Foos. Built-in relationships are only of a 1, 0..1, or many cardinality, and coming up with a way to represent my tuple as its own entity type is very cumbersome. in a sql table i would just have 9 columns - 1 identifier for the bar, plus 8 columns for each Foo instance, named appropriately for what each instance means in the tuple. then, elsewhere, i can construct proper relationships between Bars and other stuff. right now, those relationships are all just x-to-many relationships with Foos, but that's not true and hides the real intent bithc what the gently caress
|
# ? Jan 10, 2018 21:16 |
|
Don't build a system that assumes a fixed-size collection of 8 items. Because the size of the collection will change and you'll have to go modify every loving thing to accommodate that. Even if it magically doesn't ever change, the bad habits will stick with you forever.
|
# ? Jan 10, 2018 21:20 |
|
i haven't used any of these things and hand write all my SQL + orm code (except in f# where it works properly)
|
# ? Jan 10, 2018 21:21 |
|
Fiedler posted:Don't build a system that assumes a fixed-size collection of 8 items. Because the size of the collection will change and you'll have to go modify every loving thing to accommodate that. Even if it magically doesn't ever change, the bad habits will stick with you forever. it isn't an assumption, it is a fact. "cars have four wheels" isnt an assumption
|
# ? Jan 10, 2018 21:24 |
|
uh why not just use excel like a normal company?
|
# ? Jan 10, 2018 21:25 |
|
Bloody posted:it isn't an assumption, it is a fact. "cars have four wheels" isnt an assumption Then make them properties of the object rather than a collection.
|
# ? Jan 10, 2018 21:25 |
|
Bloody posted:it isn't an assumption, it is a fact. "cars have four wheels" isnt an assumption ?
|
# ? Jan 10, 2018 21:28 |
|
this is a powered trike
|
# ? Jan 10, 2018 21:28 |
|
|
# ? Jan 11, 2018 10:16 |
|
Bloody posted:this is a powered trike turns out cars.db is actually cars_and_trikes.db
|
# ? Jan 11, 2018 11:22 |
|
Bloody posted:it isn't an assumption, it is a fact. "cars have four wheels" isnt an assumption https://en.wikipedia.org/wiki/Covini_C6W
|
# ? Jan 11, 2018 15:09 |
|
|
# ? Jan 11, 2018 18:46 |
|
this is also a powered trike
|
# ? Jan 11, 2018 23:02 |
|
this is a truck
|
# ? Jan 11, 2018 23:02 |
|
this is a mistake
|
# ? Jan 11, 2018 23:03 |
|
Bloody posted:a mistake DSYP
|
# ? Jan 11, 2018 23:06 |
|
Schadenboner posted:DSYP
|
# ? Jan 11, 2018 23:18 |
|
Shaggar posted:Then make them properties of the object rather than a collection. and that'll translate into a bar table with 8 columns, each of which is a FK into the foo table?
|
# ? Jan 12, 2018 04:11 |
|
design everything in 6NF without NULL and then denormalize as needed for performance
|
# ? Jan 12, 2018 05:27 |
|
aka The CJ Date Method
|
# ? Jan 12, 2018 05:28 |
|
Bloody posted:this is a truck good 2 see ur image-id neural net is working ok
|
# ? Jan 12, 2018 14:57 |
|
Captain Foo posted:good 2 see ur image-id neural net is working ok
|
# ? Jan 12, 2018 15:06 |
|
eschaton posted:design everything in 6NF without NULL and then denormalize as needed for performance ah yes lets do cool data migrations in production cause you realized you dont need a table full of first letters of names or whatever poo poo 6NF is
|
# ? Jan 12, 2018 16:40 |
|
have u tried storing everything as json in blob columns op?? that way your users can program their own collections and aggregations!
|
# ? Jan 12, 2018 18:36 |
|
i have started using a "structured query language" to define my data in a data "base" and it is maybe suiting my needs schemaspy is cool and good at turning my database into pretty pictures
|
# ? Jan 16, 2018 06:22 |
|
Shaggar posted:Create a Visual Studio database project. You can import schema from an existing db or start from scratch. Install SQL Server Data Tools for visual studio if you don't see it in ur template list the only correct answer currently and ever to exist in this thread
|
# ? Jan 16, 2018 06:53 |
|
vs db projects are not really good but they are the least bad option
|
# ? Jan 16, 2018 19:40 |
|
Shaggar posted:vs db projects are not really good but they are the least bad option this it sucks
|
# ? Jan 16, 2018 19:49 |
|
Shaggar posted:vs db projects are not really good but they are the least bad option SSMS was horrifically buggy once upon a time but they fixed a lot of stuff with 2014 iirc and I was definitely less stressed on avg after that version. Still, was a million times better than MySQL and loving workbench lol.
|
# ? Jan 16, 2018 20:48 |
|
are you trying to present this data https://twitter.com/hilare_belloc/status/953351694682869760
|
# ? Jan 17, 2018 09:34 |
|
ok so i got a slow rear end query from joining two tables in a remote query to our microsoft dynamics nav database from our sql server database. can you even toss indexes on nav tables? does it have a concept of primary keys? i think the big problem is the row estimates a waaaay off, can i even do anything about that?
|
# ? Feb 9, 2018 18:10 |
|
bloody isn't being as big of a poo poo as you might think, btw. those three-wheelers were explicitly designed so as to not require a full automobile driver's license
|
# ? Feb 10, 2018 01:44 |
|
this is a four wheeled vehicle the rear wheels are on a short axle, but there are indeed two of them
|
# ? Feb 10, 2018 23:23 |
|
N O R M A L I Z E Y O U R S E L F A N D F A C E T H E Q U E R Y P L A N N E R
|
# ? Feb 11, 2018 00:57 |
|
Deep Dish Fuckfest posted:N O R M A L I Z E Y O U R S E L F A N D F A C E T O Q U E R Y P L A N N E R
|
# ? Feb 11, 2018 02:46 |
|
Deep Dish Fuckfest posted:D E N O R M A L I Z E Y O U R S E L F A N D F A C E T O Q U E R Y P L A N N E R
|
# ? Feb 11, 2018 04:47 |
|
btw my database is live and extremely needs suiting and thus far the schema i designed ahead of time has adequately answered all questions and appropriately handled all desired use cases to date
|
# ? Feb 12, 2018 23:23 |
|
|
# ? Jun 8, 2024 08:17 |
|
did write one ugly query that had four joins in it lol
|
# ? Feb 12, 2018 23:24 |