#DatabaseDesign

0 posts0 participants0 posts today

zartomComposite Primary Keys: When Simplicity Trumps Complexity in Database Design Optimizing database design: Single vs. composite primary keys. For smaller databases, a single, auto-incrementing primary key often offers superior performance & maintainability. Simplicity trumps complexity! Composite primary keys add complexity to updates & queries. <a href="https://mastodon.social/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDesign</a> <a href="https://mastodon.social/tags/PrimaryKey" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PrimaryKey</a> <a href="https://mastodon.social/tags/CompositeKey" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CompositeKey</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseOptimization</a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Performance</a> <a href="https://tech-champion.com/database/db2luw/composite-primary-keys-when-simplicity-trumps-complexity-in-database-design/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://tech-champion.com/database/db2luw/composite-primary-keys-when-simplicity-trumps-complexity-in-database-design/</a>

Abdullah🧠 SQL Mindmap & Daily Life SQL Commands for Developers 🧠SQL (Structured Query Language) is a powerful tool used by developers to manage and manipulate databases. Whether you're querying data, updating records, or performing complex joins, SQL is essential in daily development tasks. Let’s break it down!<a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/SQLCommands" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLCommands</a> <a href="https://mastodon.social/tags/DatabaseManagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseManagement</a> <a href="https://mastodon.social/tags/DevelopersLife" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevelopersLife</a> <a href="https://mastodon.social/tags/TechSkills" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TechSkills</a> <a href="https://mastodon.social/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDesign</a>

Chris Woody WoodruffNot every query needs a primary key.Keyless Entity Types in EF Core let you query database views, raw SQL results, and reports without requiring a unique identifier. Perfect for read-only scenarios and complex data models.<a href="https://woodruff.dev/keyless-entity-types-in-ef-core-query-data-without-primary-keys/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://woodruff.dev/keyless-entity-types-in-ef-core-query-data-without-primary-keys/</a><a href="https://mastodon.social/tags/EFCore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EFCore</a> <a href="https://mastodon.social/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://mastodon.social/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDesign</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a>

Chris Woody WoodruffMany-to-Many relationships in EF Core is just easier! No more manual join tables—EF Core handles it all!Learn how to set up, query, and navigate many-to-many relationships without causing any trouble.Read more: <a href="https://woodruff.dev/many-to-many-made-easy-mastering-relationships-in-ef-core/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://woodruff.dev/many-to-many-made-easy-mastering-relationships-in-ef-core/</a><a href="https://mastodon.social/tags/EFCore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#EFCore</a> <a href="https://mastodon.social/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://mastodon.social/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDesign</a> <a href="https://mastodon.social/tags/DevTips" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevTips</a>

Aaron LongchampsI've been working on this a bit lately, but getting stuck on the database side of the IPAM relationships. Specifically, how to get a one-to-many relationship working between the network (e.g. 192.168.1.0/24) and the IP entries (192.168.1.[1..254]). Pydantic usually complains about the relationship in some form or other, saying it can't generate the schema.One thing that definitely doesn't help is that I define the return types in one file and the Pydantic models in another, so any change I make in one I have to make in another.For that reason, I might look at replacing how I interface with the database.Thankfully, the testing I have in place will let me change things out easily.<a href="https://infosec.exchange/tags/rackroot" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rackroot</a> <a href="https://infosec.exchange/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://infosec.exchange/tags/backend" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#backend</a> <a href="https://infosec.exchange/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webdev</a> <a href="https://infosec.exchange/tags/databasedesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databasedesign</a>

LavX NewsDemystifying Database Development: Building a KV Store in 3000 Lines of GoEver wondered how complex software like databases works? A new approach simplifies the learning curve by guiding developers through the creation of a minimalist key-value store in just 3000 lines of G...<a href="https://news.lavx.hu/article/demystifying-database-development-building-a-kv-store-in-3000-lines-of-go" rel="nofollow noopener noreferrer" target="_blank">https://news.lavx.hu/article/demystifying-database-development-building-a-kv-store-in-3000-lines-of-go</a><a href="https://mastodon.cloud/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#news</a> <a href="https://mastodon.cloud/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tech</a> <a href="https://mastodon.cloud/tags/GoLang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GoLang</a> <a href="https://mastodon.cloud/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDesign</a> <a href="https://mastodon.cloud/tags/CopyOnWrite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CopyOnWrite</a>

Aaron LongchampsGateway stuff is done for now, so it's time to work on the DHCP range data.A network can have 0..n DHCP ranges and each DHCP range should be editable with the CRUD operations.C - create: add a new DHCP range, make sure it doesn't overlap with another DHCP range already present on this network. All IPs should be in range, too. R - read: render DHCP range information and overall IPAM utilization of the network. A DHCP range covering 200 IPs on a /24 should, for example, show roughly 80% of the IPs are used. Vuetify has UI elements to render stuff like this. U - update: change data about the range such as the start/end addresses, name, or description. D - delete: remove a DHCP range <--> network association and the associated record(s) from the db.Validations: DHCP range doesn't overlap other IPs in use on the network, such as the gateway, static IP assignments on that network (which I haven't even gotten to), or other DHCP ranges.There's going to be a LOT of testing to go into this and I think that's why I like this kind of stuff. It forces me to think of all the use cases, write tests, add code, and balance all of it together.<a href="https://infosec.exchange/tags/rackroot" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rackroot</a> <a href="https://infosec.exchange/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://infosec.exchange/tags/networking" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#networking</a> <a href="https://infosec.exchange/tags/fastapi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#fastapi</a> <a href="https://infosec.exchange/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#python</a> <a href="https://infosec.exchange/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#webdev</a> <a href="https://infosec.exchange/tags/fullstackdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#fullstackdevelopment</a> <a href="https://infosec.exchange/tags/fullstack" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#fullstack</a> <a href="https://infosec.exchange/tags/vuetify" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#vuetify</a> <a href="https://infosec.exchange/tags/databasedesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databasedesign</a>

Ashley Rolfmore (leymoo)Also; if your previous technology choices made this hard... That means a wider discussion to fix it, and don’t let outside people pressure you into compromising on data intregity in systems that need auditing. The bad ones will throw your reputation away anyway if they pressure you to do bad work and it messes up later <a href="https://hachyderm.io/tags/databasedesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databasedesign</a> <a href="https://hachyderm.io/tags/DatabaseDevelopers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDevelopers</a> <a href="https://hachyderm.io/tags/systemDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#systemDesign</a> <a href="https://hachyderm.io/tags/Accountancy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Accountancy</a> <a href="https://hachyderm.io/tags/Audit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Audit</a>

Ashley Rolfmore (leymoo)The nuance that seems to come up is parent records with child records - ie if you remove the association, the associated child audit entries disappear. Its easier to see the issue if you remove this type of record keeping to other situations- ie if a foster parent looks after a child, say the kid breaks a leg playing football while under the care of the carer, then the kid moves on…. You’d want to know that both the kid had the accident with the carer and that the carer looked after a kid that had an accident while with them. Both sets of information either end are needed. The accident shouldn’t disappear from the carer’s record. Yet you hear this from system designers or developers. <a href="https://hachyderm.io/tags/databasedesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databasedesign</a> <a href="https://hachyderm.io/tags/DatabaseDevelopers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDevelopers</a> <a href="https://hachyderm.io/tags/systemDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#systemDesign</a> <a href="https://hachyderm.io/tags/Accountancy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Accountancy</a> <a href="https://hachyderm.io/tags/Audit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Audit</a>

Ashley Rolfmore (leymoo)I’m starting to think that anyone who designs or builds systems that handle data should do a basic bookkeeping course that covers how double entry works. The accountants managed to work out for us since the 13th Century that if you move money from A to B, both A and B need an audit entry describing the movement each way. Write only - nothing is removed. Yet I don’t see an equivalent teaching in the various system design books, despite this concept being fundamental to any system that needs (financial and non-financial) auditing capabilities. <a href="https://hachyderm.io/tags/databasedesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#databasedesign</a> <a href="https://hachyderm.io/tags/DatabaseDevelopers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDevelopers</a> <a href="https://hachyderm.io/tags/systemDesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#systemDesign</a> <a href="https://hachyderm.io/tags/Accountancy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Accountancy</a> <a href="https://hachyderm.io/tags/Audit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Audit</a>

Rafael Pérez :verify:<a href="https://c.im/tags/Introduction" class="mention hashtag" rel="tag">#Introduction</a> My name is Rafael. I was born in <a href="https://c.im/tags/PuertoRico" class="mention hashtag" rel="tag">#PuertoRico</a> and I've been living in <a href="https://c.im/tags/NYC" class="mention hashtag" rel="tag">#NYC</a> for the past four years (I moved to <a href="https://c.im/tags/Brooklyn" class="mention hashtag" rel="tag">#Brooklyn</a> two years ago.) I'm 47 years old and I like:<a href="https://c.im/tags/Computing" class="mention hashtag" rel="tag">#Computing</a> <a href="https://c.im/tags/ComputerProgramming" class="mention hashtag" rel="tag">#ComputerProgramming</a> <a href="https://c.im/tags/SoftwareDevelopment" class="mention hashtag" rel="tag">#SoftwareDevelopment</a> <a href="https://c.im/tags/AI" class="mention hashtag" rel="tag">#AI</a> <a href="https://c.im/tags/VisualArt" class="mention hashtag" rel="tag">#VisualArt</a> <a href="https://c.im/tags/Design" class="mention hashtag" rel="tag">#Design</a> <a href="https://c.im/tags/Film" class="mention hashtag" rel="tag">#Film</a> <a href="https://c.im/tags/Literature" class="mention hashtag" rel="tag">#Literature</a> <a href="https://c.im/tags/OOD" class="mention hashtag" rel="tag">#OOD</a>, <a href="https://c.im/tags/OOP" class="mention hashtag" rel="tag">#OOP</a> <a href="https://c.im/tags/GeneticAlgorithms" class="mention hashtag" rel="tag">#GeneticAlgorithms</a> <a href="https://c.im/tags/DotNet" class="mention hashtag" rel="tag">#DotNet</a> <a href="https://c.im/tags/ASP" class="mention hashtag" rel="tag">#ASP</a> <a href="https://c.im/tags/CSharp" class="mention hashtag" rel="tag">#CSharp</a> <a href="https://c.im/tags/Java" class="mention hashtag" rel="tag">#Java</a> <a href="https://c.im/tags/HTML" class="mention hashtag" rel="tag">#HTML</a> <a href="https://c.im/tags/JavaScript" class="mention hashtag" rel="tag">#JavaScript</a> <a href="https://c.im/tags/SQL" class="mention hashtag" rel="tag">#SQL</a> <a href="https://c.im/tags/DevOps" class="mention hashtag" rel="tag">#DevOps</a> <a href="https://c.im/tags/DatabaseDesign" class="mention hashtag" rel="tag">#DatabaseDesign</a> <a href="https://c.im/tags/FullStack" class="mention hashtag" rel="tag">#FullStack</a> <a href="https://c.im/tags/BusinessToConsumerApps" class="mention hashtag" rel="tag">#BusinessToConsumerApps</a> <a href="https://c.im/tags/TechnicalWriting" class="mention hashtag" rel="tag">#TechnicalWriting</a> <a href="https://c.im/tags/UbuntuLinux" class="mention hashtag" rel="tag">#UbuntuLinux</a> <a href="https://c.im/tags/Brooklyn" class="mention hashtag" rel="tag">#Brooklyn</a> <a href="https://c.im/tags/Manhattan" class="mention hashtag" rel="tag">#Manhattan</a> <a href="https://c.im/tags/NYC" class="mention hashtag" rel="tag">#NYC</a> <a href="https://c.im/tags/PuertoRico" class="mention hashtag" rel="tag">#PuertoRico</a> <a href="https://c.im/tags/UniversityOfSussex" class="mention hashtag" rel="tag">#UniversityOfSussex</a> <a href="https://c.im/tags/Brighton" class="mention hashtag" rel="tag">#Brighton</a>, <a href="https://c.im/tags/England" class="mention hashtag" rel="tag">#England</a> <a href="https://c.im/tags/VideoGames" class="mention hashtag" rel="tag">#VideoGames</a> <a href="https://c.im/tags/ContentModeration" class="mention hashtag" rel="tag">#ContentModeration</a> <a href="https://c.im/tags/LongWalks" class="mention hashtag" rel="tag">#LongWalks</a> <a href="https://c.im/tags/Music" class="mention hashtag" rel="tag">#Music</a> (Who doesn't?)My personal website is at: <a href="https://human-assisted.blogspot.com/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://human-assisted.blogspot.com/</a><a href="https://c.im/" target="_blank" rel="nofollow noopener noreferrer" translate="no">https://c.im/</a> (I'm mod here.)

Recent searches

Search options

Administered by:

Server stats:

#DatabaseDesign