#databases — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #databases, aggregated by home.social.
-
Point-In-Time Restore (PITR) in minutes regardless of database size using the magic of snapshot backups
#Database #Databases #backups #AzureDatabase #AzureSQL #Hyperscale
https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-automated-backups-overview?view=azuresql#backup-and-restore-performance -
Another fucking year.
Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)
Thank you.
#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev
-
Another fucking year.
Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)
Thank you.
#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev
-
Another fucking year.
Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)
Thank you.
#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev
-
Another fucking year.
Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)
Thank you.
#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev
-
Another fucking year.
Another #PostgreSQL version without MIN/MAX aggregators for fucking UUID v7 (or an exclusive, UUID-v7-type-column)
Thank you.
#Programming #Coding #Code #PgSQL #Postgre #SQL #Database #Databases #RDBM #RDBMS #DB #UUID #UUIDv7 #SoftwareDevelopment #WebDevelopment #WebDev #AppDevelopment #AppDev
-
Be like SQL: Sit still, and learn.
Medium writer Fayner Brack offers great career advice regarding SQL as a foundation that has held together disparate relational database systems for more than thirty years. I agree with her assesment that developers need to master SQL queries before moving on to using ORM tools, and other layers of abstraction.
"Learn SQL Once, Use It for 30 Years"
https://fagnerbrack.com/learn-sql-once-use-it-for-30-years-9aceb0bdee03
#databases #sql #programming #compatibility #relationalalgebra #mathematics
-
Be like SQL: Sit still, and learn.
Medium writer Fayner Brack offers great career advice regarding SQL as a foundation that has held together disparate relational database systems for more than thirty years. I agree with her assesment that developers need to master SQL queries before moving on to using ORM tools, and other layers of abstraction.
"Learn SQL Once, Use It for 30 Years"
https://fagnerbrack.com/learn-sql-once-use-it-for-30-years-9aceb0bdee03
#databases #sql #programming #compatibility #relationalalgebra #mathematics
-
Thousands of Vibe-Coded Apps Expose Corporate and Personal Data on the Open Web
-
Thousands of Vibe-Coded Apps Expose Corporate and Personal Data on the Open Web
-
Beyond Context Graphs : Agentic Memory , Causual Graphs , Promise Graphs and decision traces by Volodymyr Pavlyshyn is the featured bundle of ebooks 📚 on Leanpub!
How to make agents adopted to enterprice grade tasks
Link: https://leanpub.com/b/beyondcontextgraphs-agenticai
#ai #deep_learning #data_science #software_architecture #databases #data_structures #software_engineering
-
Beyond Context Graphs : Agentic Memory , Causual Graphs , Promise Graphs and decision traces by Volodymyr Pavlyshyn is the featured bundle of ebooks 📚 on Leanpub!
How to make agents adopted to enterprice grade tasks
Link: https://leanpub.com/b/beyondcontextgraphs-agenticai
#ai #deep_learning #data_science #software_architecture #databases #data_structures #software_engineering
-
VM size: Performance best practices for SQL Server on Azure VMs
#databases #cloud #Azure #VirtualMachine #VM #SQLServer
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-vm-size?view=azuresql -
Zero-Copy Pages in Rust: Or How I Learned to Stop Worrying and Love Lifetimes
https://redixhumayun.github.io/databases/2026/04/14/zero-copy-pages-in-rust.html
#HackerNews #ZeroCopy #Rust #Lifetimes #Programming #HackerNews #Databases
-
Zero-Copy Pages in Rust: Or How I Learned to Stop Worrying and Love Lifetimes
https://redixhumayun.github.io/databases/2026/04/14/zero-copy-pages-in-rust.html
#HackerNews #ZeroCopy #Rust #Lifetimes #Programming #HackerNews #Databases
-
🤓 Wow, who would've thought that running a reading group at #Microsoft revolves around #databases and meetings about databases? It's like a support group for people who dream in #SQL and can't escape acronyms like #SIGMOD. 📚 Apparently, databases are the universe and this group is the Big Bang, spreading enlightenment one LSM tree at a time. 🌳
https://armaansood.com/posts/systems-reading-group/ #readinggroup #LSMtree #HackerNews #ngated -
🤓 Wow, who would've thought that running a reading group at #Microsoft revolves around #databases and meetings about databases? It's like a support group for people who dream in #SQL and can't escape acronyms like #SIGMOD. 📚 Apparently, databases are the universe and this group is the Big Bang, spreading enlightenment one LSM tree at a time. 🌳
https://armaansood.com/posts/systems-reading-group/ #readinggroup #LSMtree #HackerNews #ngated -
🤓 Wow, who would've thought that running a reading group at #Microsoft revolves around #databases and meetings about databases? It's like a support group for people who dream in #SQL and can't escape acronyms like #SIGMOD. 📚 Apparently, databases are the universe and this group is the Big Bang, spreading enlightenment one LSM tree at a time. 🌳
https://armaansood.com/posts/systems-reading-group/ #readinggroup #LSMtree #HackerNews #ngated -
🤓 Wow, who would've thought that running a reading group at #Microsoft revolves around #databases and meetings about databases? It's like a support group for people who dream in #SQL and can't escape acronyms like #SIGMOD. 📚 Apparently, databases are the universe and this group is the Big Bang, spreading enlightenment one LSM tree at a time. 🌳
https://armaansood.com/posts/systems-reading-group/ #readinggroup #LSMtree #HackerNews #ngated -
🤓 Wow, who would've thought that running a reading group at #Microsoft revolves around #databases and meetings about databases? It's like a support group for people who dream in #SQL and can't escape acronyms like #SIGMOD. 📚 Apparently, databases are the universe and this group is the Big Bang, spreading enlightenment one LSM tree at a time. 🌳
https://armaansood.com/posts/systems-reading-group/ #readinggroup #LSMtree #HackerNews #ngated -
New blog post is up! How I added search functionality to Rack Root, a FastAPI app.
I cover just about all the Python code I wish I had examples for when I was figuring this out. I go over the database class design, indexes/vectors a little bit, and the API design I ended up implementing.
#blogging #writing #development #search #rackroot #python #backend #fastapi #homelab #learning #databases #sqlalchemy
-
New blog post is up! How I added search functionality to Rack Root, a FastAPI app.
I cover just about all the Python code I wish I had examples for when I was figuring this out. I go over the database class design, indexes/vectors a little bit, and the API design I ended up implementing.
#blogging #writing #development #search #rackroot #python #backend #fastapi #homelab #learning #databases #sqlalchemy
-
I'm excited to present with Barry Stahl today. @Bsstahl #Aspire Accelerator: fast track to #CloudNative #Development, a #NoSlides just #code demo of Aspire. We'll talk about what makes Aspire amazing for #dotNET developers, how to get started, how to use #Databases, and how to include #AI models. Join us in-person in #Phoenix or #online: https://www.meetup.com/sevdnug/events/312712768/, and grab the code demos at https://github.com/robrich/aspire-accelerator
-
I'm excited to present with Barry Stahl today. @Bsstahl #Aspire Accelerator: fast track to #CloudNative #Development, a #NoSlides just #code demo of Aspire. We'll talk about what makes Aspire amazing for #dotNET developers, how to get started, how to use #Databases, and how to include #AI models. Join us in-person in #Phoenix or #online: https://www.meetup.com/sevdnug/events/312712768/, and grab the code demos at https://github.com/robrich/aspire-accelerator
-
Deepintodev.com reviews how modern database storage engines store, retrieve, and update database table rows on memory and disk. This serves as a foundation to understanding how indexes and clustered indexes work, the concerned data structures, and their use cases; these are reviewed as well.
"How Databases Store Your Tables on Disk"
https://www.deepintodev.com/blog/how-databases-store-your-tables-on-disk
-
Deepintodev.com reviews how modern database storage engines store, retrieve, and update database table rows on memory and disk. This serves as a foundation to understanding how indexes and clustered indexes work, the concerned data structures, and their use cases; these are reviewed as well.
"How Databases Store Your Tables on Disk"
https://www.deepintodev.com/blog/how-databases-store-your-tables-on-disk
-
I think I finally have my SQLModel to SQLAlchemy refactor completed for Rack Root. As of now, I at least have all of my tests passing and typos worked out. I know I need to add some more join statements, but I'll do those as I come across them.
I still have a little bit of cleanup to do in removing commented code, fixing comments, organizing imports, and syncing this back to the main branch, but the hard part is done.
Then I can finally get back to the front end work. I've been on the backend side of things for what feels like months.
#sqlalchemy #fastapi #webdev #backend #databases #opensource #rackroot
-
I think I finally have my SQLModel to SQLAlchemy refactor completed for Rack Root. As of now, I at least have all of my tests passing and typos worked out. I know I need to add some more join statements, but I'll do those as I come across them.
I still have a little bit of cleanup to do in removing commented code, fixing comments, organizing imports, and syncing this back to the main branch, but the hard part is done.
Then I can finally get back to the front end work. I've been on the backend side of things for what feels like months.
#sqlalchemy #fastapi #webdev #backend #databases #opensource #rackroot
-
I'm back in the code for Rack Root tonight and realized why I have some of the database relationships I was thinking of getting rid of yesterday. I need ways to track allocations of IP addresses in DHCP ranges and the way I have it setup, there's a nullable foreign key from an IP record over to a DHCP range.
The code for allocating/deallocating an IP in there is easy - if there's a FK set, then you can't set another one.
This is also where I really wish there were better examples of ForeignKey and ForeignKeyConstraints in SQLModel. So far, my searching hasn't turned anything up which might be an opportunity for a blog post and/or pull request.
-
I'm back in the code for Rack Root tonight and realized why I have some of the database relationships I was thinking of getting rid of yesterday. I need ways to track allocations of IP addresses in DHCP ranges and the way I have it setup, there's a nullable foreign key from an IP record over to a DHCP range.
The code for allocating/deallocating an IP in there is easy - if there's a FK set, then you can't set another one.
This is also where I really wish there were better examples of ForeignKey and ForeignKeyConstraints in SQLModel. So far, my searching hasn't turned anything up which might be an opportunity for a blog post and/or pull request.
-
I need to learn more about how databases work and the best way to setup relationships in SQLModel. I was working on Rack Root tonight and am still running into an issue with some circular dependencies I'm having between various tables. I need these relationships to enhance the data/utility of the app, but might need to rethink how I'm actually putting them together.
The other fun part of this is that I'm learning that the way I test the app and the way I run the app isn't always the same. The tests will run fine the first time against my test Postgres container, but subsequent runs don't work because of how I tell the test DB to drop all data before running the tests. It's complaining about the relationships, but really I think I need to tell it to either cascade delete or just ignore something.
#homelab #rackroot #programming #webdev #fastapi #sqlmodel #databases #alwayslearning
-
I need to learn more about how databases work and the best way to setup relationships in SQLModel. I was working on Rack Root tonight and am still running into an issue with some circular dependencies I'm having between various tables. I need these relationships to enhance the data/utility of the app, but might need to rethink how I'm actually putting them together.
The other fun part of this is that I'm learning that the way I test the app and the way I run the app isn't always the same. The tests will run fine the first time against my test Postgres container, but subsequent runs don't work because of how I tell the test DB to drop all data before running the tests. It's complaining about the relationships, but really I think I need to tell it to either cascade delete or just ignore something.
#homelab #rackroot #programming #webdev #fastapi #sqlmodel #databases #alwayslearning
-
The Slides from my talk at the Incontro DevOps 2025 in Bologna are now available!
Check out the JSONB capabilities in PostgreSQL 17 here!#PostgreSQL #JSONB #DevOps #IncontroDevOps #Bologna #Databases
-
The Slides from my talk at the Incontro DevOps 2025 in Bologna are now available!
Check out the JSONB capabilities in PostgreSQL 17 here!#PostgreSQL #JSONB #DevOps #IncontroDevOps #Bologna #Databases
-
The Slides from my talk at the Incontro DevOps 2025 in Bologna are now available!
Check out the JSONB capabilities in PostgreSQL 17 here!#PostgreSQL #JSONB #DevOps #IncontroDevOps #Bologna #Databases
-
The Slides from my talk at the Incontro DevOps 2025 in Bologna are now available!
Check out the JSONB capabilities in PostgreSQL 17 here!#PostgreSQL #JSONB #DevOps #IncontroDevOps #Bologna #Databases
-
The Slides from my talk at the Incontro DevOps 2025 in Bologna are now available!
Check out the JSONB capabilities in PostgreSQL 17 here!#PostgreSQL #JSONB #DevOps #IncontroDevOps #Bologna #Databases
-
New blog post is up!
How I handled tracking DHCP ranges in Rack Root, some things I ran into along the way, and how I improved my pytest output.
https://medium.com/@a.j.longchamps/rack-root-devlog-tracking-dhcp-ranges-c8272001fe3a
#pytest #homelab #rackroot #devlog #blogging #fastapi #backend #databases #sqlmodel #programming #blogging
-
New blog post is up!
How I handled tracking DHCP ranges in Rack Root, some things I ran into along the way, and how I improved my pytest output.
https://medium.com/@a.j.longchamps/rack-root-devlog-tracking-dhcp-ranges-c8272001fe3a
#pytest #homelab #rackroot #devlog #blogging #fastapi #backend #databases #sqlmodel #programming #blogging
-
I think I'm starting to outgrow the sqlite database I've been using. I've been able to get along with some of the foreign key stuff I want to do, but now I'm running into challenges with it accepting DateTime objects. I might need something a tad more powerful.
I'm already halfway through a SQLAlchemy -> SQLModel refactor, I guess what's one more branch on the code?! After all, that's what git is for.
I could probably get away with refactoring the other two classes, but I want all of my testing to be passing before I keep going.
#programming #rackroot #backend #databases #design #fullstackdevelopment #fastapi #sqlite #sqlmodel #pytest
-
I think I'm starting to outgrow the sqlite database I've been using. I've been able to get along with some of the foreign key stuff I want to do, but now I'm running into challenges with it accepting DateTime objects. I might need something a tad more powerful.
I'm already halfway through a SQLAlchemy -> SQLModel refactor, I guess what's one more branch on the code?! After all, that's what git is for.
I could probably get away with refactoring the other two classes, but I want all of my testing to be passing before I keep going.
#programming #rackroot #backend #databases #design #fullstackdevelopment #fastapi #sqlite #sqlmodel #pytest
-
Botanical names and the practices that pre-serve the legacies of empire
"Plant naming is a fractious area of botany, partly because most plants are named after white, western men. Acknowledgement of female and Indigenous plant collectors is often absent from plant names and also from the botanical database records."
"While in Australia, English botanist Joseph Banks (1743-1820) collected 1,400 plants over his seven-week trip. No Aboriginal plant names were recorded. Plants were then returned to Britain and Europe to meet the growing hunger for rare natural collections. These collections became the major European museums and herbaria we know today, such as Kew Gardens in London."
"Subramaniam’s book views colonialism as a genocide, an ecocide and an epistemicide where Indigenous knowledges were mostly lost but also partly appropriated."
>>
https://theconversation.com/sex-plants-and-colonisation-reclaiming-botany-from-the-tendrils-of-empire-234679Botanists vote to remove racist reference from plants’ scientific names
https://www.theguardian.com/science/article/2024/jul/20/botanists-remove-racist-references-plants-scientific-namesRestoring Indigenous names in taxonomy
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC7584613/Botany of Empire, Plant Worlds and the Scientific Legacies of Colonialism, Banu Subramaniam, 2024
https://uwapress.uw.edu/book/9780295752457/botany-of-empire/
#botany #biology #nomenclature #taxonomy #ScientificNames #epistemicide #DB #databases #PlantSciences #Plants #terminology #ecology #conservation #restoration #colonialism #empire #IndigenousPeoples #women #Book #PlantHumanities -
Botanical names and the practices that pre-serve the legacies of empire
"Plant naming is a fractious area of botany, partly because most plants are named after white, western men. Acknowledgement of female and Indigenous plant collectors is often absent from plant names and also from the botanical database records."
"While in Australia, English botanist Joseph Banks (1743-1820) collected 1,400 plants over his seven-week trip. No Aboriginal plant names were recorded. Plants were then returned to Britain and Europe to meet the growing hunger for rare natural collections. These collections became the major European museums and herbaria we know today, such as Kew Gardens in London."
"Subramaniam’s book views colonialism as a genocide, an ecocide and an epistemicide where Indigenous knowledges were mostly lost but also partly appropriated."
>>
https://theconversation.com/sex-plants-and-colonisation-reclaiming-botany-from-the-tendrils-of-empire-234679Botanists vote to remove racist reference from plants’ scientific names
https://www.theguardian.com/science/article/2024/jul/20/botanists-remove-racist-references-plants-scientific-namesRestoring Indigenous names in taxonomy
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC7584613/Botany of Empire, Plant Worlds and the Scientific Legacies of Colonialism, Banu Subramaniam, 2024
https://uwapress.uw.edu/book/9780295752457/botany-of-empire/
#botany #biology #nomenclature #taxonomy #ScientificNames #epistemicide #DB #databases #PlantSciences #Plants #terminology #ecology #conservation #restoration #colonialism #empire #IndigenousPeoples #women #Book #PlantHumanities -
Botanical names and the practices that pre-serve the legacies of empire
"Plant naming is a fractious area of botany, partly because most plants are named after white, western men. Acknowledgement of female and Indigenous plant collectors is often absent from plant names and also from the botanical database records."
"While in Australia, English botanist Joseph Banks (1743-1820) collected 1,400 plants over his seven-week trip. No Aboriginal plant names were recorded. Plants were then returned to Britain and Europe to meet the growing hunger for rare natural collections. These collections became the major European museums and herbaria we know today, such as Kew Gardens in London."
"Subramaniam’s book views colonialism as a genocide, an ecocide and an epistemicide where Indigenous knowledges were mostly lost but also partly appropriated."
>>
https://theconversation.com/sex-plants-and-colonisation-reclaiming-botany-from-the-tendrils-of-empire-234679Botanists vote to remove racist reference from plants’ scientific names
https://www.theguardian.com/science/article/2024/jul/20/botanists-remove-racist-references-plants-scientific-namesRestoring Indigenous names in taxonomy
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC7584613/Botany of Empire, Plant Worlds and the Scientific Legacies of Colonialism, Banu Subramaniam, 2024
https://uwapress.uw.edu/book/9780295752457/botany-of-empire/
#botany #biology #nomenclature #taxonomy #ScientificNames #epistemicide #DB #databases #PlantSciences #Plants #terminology #ecology #conservation #restoration #colonialism #empire #IndigenousPeoples #women #Book #PlantHumanities -
Botanical names and the practices that pre-serve the legacies of empire
"Plant naming is a fractious area of botany, partly because most plants are named after white, western men. Acknowledgement of female and Indigenous plant collectors is often absent from plant names and also from the botanical database records."
"While in Australia, English botanist Joseph Banks (1743-1820) collected 1,400 plants over his seven-week trip. No Aboriginal plant names were recorded. Plants were then returned to Britain and Europe to meet the growing hunger for rare natural collections. These collections became the major European museums and herbaria we know today, such as Kew Gardens in London."
"Subramaniam’s book views colonialism as a genocide, an ecocide and an epistemicide where Indigenous knowledges were mostly lost but also partly appropriated."
>>
https://theconversation.com/sex-plants-and-colonisation-reclaiming-botany-from-the-tendrils-of-empire-234679Botanists vote to remove racist reference from plants’ scientific names
https://www.theguardian.com/science/article/2024/jul/20/botanists-remove-racist-references-plants-scientific-namesRestoring Indigenous names in taxonomy
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC7584613/Botany of Empire, Plant Worlds and the Scientific Legacies of Colonialism, Banu Subramaniam, 2024
https://uwapress.uw.edu/book/9780295752457/botany-of-empire/
#botany #biology #nomenclature #taxonomy #ScientificNames #epistemicide #DB #databases #PlantSciences #Plants #terminology #ecology #conservation #restoration #colonialism #empire #IndigenousPeoples #women #Book #PlantHumanities -
The #StackOverflow Developer Survey 2024 is out! #PostgreSQL :postgresql: is the most popular #database (49%), and also "most desired" (47.1%) and "most admired" (74.5%) for the second year in a row! 😍
-
The #StackOverflow Developer Survey 2024 is out! #PostgreSQL :postgresql: is the most popular #database (49%), and also "most desired" (47.1%) and "most admired" (74.5%) for the second year in a row! 😍
-
Quick rundown of the MultiXact: a #PostgreSQL locking implementation detail that you can absolutely ignore… until suddenly you can't anymore 🔒💀
https://blog.danslimmon.com/2023/12/11/concurrent-locks-and-multixacts-in-postgres/
-
Quick rundown of the MultiXact: a #PostgreSQL locking implementation detail that you can absolutely ignore… until suddenly you can't anymore 🔒💀
https://blog.danslimmon.com/2023/12/11/concurrent-locks-and-multixacts-in-postgres/
-
Quick rundown of the MultiXact: a #PostgreSQL locking implementation detail that you can absolutely ignore… until suddenly you can't anymore 🔒💀
https://blog.danslimmon.com/2023/12/11/concurrent-locks-and-multixacts-in-postgres/