101010.pl

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" target="_blank">#rackroot</a> <a href="https://infosec.exchange/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a> <a href="https://infosec.exchange/tags/backend" class="mention hashtag" rel="nofollow noopener" target="_blank">#backend</a> <a href="https://infosec.exchange/tags/webdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#webdev</a> <a href="https://infosec.exchange/tags/databasedesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#databasedesign</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" target="_blank">#rackroot</a> <a href="https://infosec.exchange/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a> <a href="https://infosec.exchange/tags/networking" class="mention hashtag" rel="nofollow noopener" target="_blank">#networking</a> <a href="https://infosec.exchange/tags/fastapi" class="mention hashtag" rel="nofollow noopener" target="_blank">#fastapi</a> <a href="https://infosec.exchange/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#python</a> <a href="https://infosec.exchange/tags/webdev" class="mention hashtag" rel="nofollow noopener" target="_blank">#webdev</a> <a href="https://infosec.exchange/tags/fullstackdevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#fullstackdevelopment</a> <a href="https://infosec.exchange/tags/fullstack" class="mention hashtag" rel="nofollow noopener" target="_blank">#fullstack</a> <a href="https://infosec.exchange/tags/vuetify" class="mention hashtag" rel="nofollow noopener" target="_blank">#vuetify</a> <a href="https://infosec.exchange/tags/databasedesign" class="mention hashtag" rel="nofollow noopener" 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" target="_blank">#databasedesign</a> <a href="https://hachyderm.io/tags/DatabaseDevelopers" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseDevelopers</a> <a href="https://hachyderm.io/tags/systemDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#systemDesign</a> <a href="https://hachyderm.io/tags/Accountancy" class="mention hashtag" rel="nofollow noopener" target="_blank">#Accountancy</a> <a href="https://hachyderm.io/tags/Audit" class="mention hashtag" rel="nofollow noopener" 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" target="_blank">#databasedesign</a> <a href="https://hachyderm.io/tags/DatabaseDevelopers" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseDevelopers</a> <a href="https://hachyderm.io/tags/systemDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#systemDesign</a> <a href="https://hachyderm.io/tags/Accountancy" class="mention hashtag" rel="nofollow noopener" target="_blank">#Accountancy</a> <a href="https://hachyderm.io/tags/Audit" class="mention hashtag" rel="nofollow noopener" 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" target="_blank">#databasedesign</a> <a href="https://hachyderm.io/tags/DatabaseDevelopers" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseDevelopers</a> <a href="https://hachyderm.io/tags/systemDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#systemDesign</a> <a href="https://hachyderm.io/tags/Accountancy" class="mention hashtag" rel="nofollow noopener" target="_blank">#Accountancy</a> <a href="https://hachyderm.io/tags/Audit" class="mention hashtag" rel="nofollow noopener" target="_blank">#Audit</a>

Adron 🤘🏻🎵🔥 Dive into the world of music collecting with my post on building a multi-tenant music collectors database! Perfect for devs and music enthusiasts alike. <a href="https://metalhead.club/tags/MusicTech" class="mention hashtag" rel="nofollow noopener" target="_blank">#MusicTech</a> <a href="https://metalhead.club/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseDesign</a> 🚀🎶 Today, I'm specifically working on some <a href="https://metalhead.club/tags/CloudFormation" class="mention hashtag" rel="nofollow noopener" target="_blank">#CloudFormation</a> to turn this database into a reality.Next up with be an API, then interface! 🤘🏻<a href="https://compositecode.blog/2023/10/23/building-a-multi-tenant-music-collectors-database/" rel="nofollow noopener" translate="no" target="_blank">https://compositecode.blog/2023/10/23/building-a-multi-tenant-music-collectors-database/</a>

urig✔️Hi Friends,Looking for a new <a href="https://mastodon.online/tags/freelance" class="mention hashtag" rel="nofollow noopener" target="_blank">#freelance</a> <a href="https://mastodon.online/tags/software" class="mention hashtag" rel="nofollow noopener" target="_blank">#software</a> <a href="https://mastodon.online/tags/development" class="mention hashtag" rel="nofollow noopener" target="_blank">#development</a> <a href="https://mastodon.online/tags/project" class="mention hashtag" rel="nofollow noopener" target="_blank">#project</a>. Would ♥ to <a href="https://mastodon.online/tags/getfedihired" class="mention hashtag" rel="nofollow noopener" target="_blank">#getfedihired</a>. * >20 years coding <a href="https://mastodon.online/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a>, <a href="https://mastodon.online/tags/C" class="mention hashtag" rel="nofollow noopener" target="_blank">#C</a>#, <a href="https://mastodon.online/tags/Java" class="mention hashtag" rel="nofollow noopener" target="_blank">#Java</a>, <a href="https://mastodon.online/tags/JS" class="mention hashtag" rel="nofollow noopener" target="_blank">#JS</a>, & <a href="https://mastodon.online/tags/TS" class="mention hashtag" rel="nofollow noopener" target="_blank">#TS</a>. * Vast exp. building <a href="https://mastodon.online/tags/DistributedSystems" class="mention hashtag" rel="nofollow noopener" target="_blank">#DistributedSystems</a> in the ☁(<a href="https://mastodon.online/tags/AWS" class="mention hashtag" rel="nofollow noopener" target="_blank">#AWS</a>, <a href="https://mastodon.online/tags/Azure" class="mention hashtag" rel="nofollow noopener" target="_blank">#Azure</a>, <a href="https://mastodon.online/tags/GoogleCloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#GoogleCloud</a>) & on-prem. * Authored & teaching academic <a href="https://mastodon.online/tags/course" class="mention hashtag" rel="nofollow noopener" target="_blank">#course</a> on <a href="https://mastodon.online/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseDesign</a> + <a href="https://mastodon.online/tags/workshops" class="mention hashtag" rel="nofollow noopener" target="_blank">#workshops</a> on <a href="https://mastodon.online/tags/TestAutomation" class="mention hashtag" rel="nofollow noopener" target="_blank">#TestAutomation</a>, <a href="https://mastodon.online/tags/k8s" class="mention hashtag" rel="nofollow noopener" target="_blank">#k8s</a>, the <a href="https://mastodon.online/tags/ActorModel" class="mention hashtag" rel="nofollow noopener" target="_blank">#ActorModel</a>, <a href="https://mastodon.online/tags/CleanCode" class="mention hashtag" rel="nofollow noopener" target="_blank">#CleanCode</a>...* <a href="https://mastodon.online/tags/Empathy" class="mention hashtag" rel="nofollow noopener" target="_blank">#Empathy</a> is my super-power, I love to help, teach, build and fix.Please RT - Every BOOST helps 🙏

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

Recent searches

Search options

Administered by:

Server stats:

#databasedesign