How difficult can be creating an hypertable in TimescaleDB?
It seems that pretty much of a fucking lot.
#PostgreSQL #TimescaleDB #Hypertable #Hypertables #SQL #RDBMS #RelationalDatabase #Database #Databases #Programming #SoftwareDevelopment #DatabaseDevelopment
Odoo Relational Fields are crucial for robust applications. Discover how many-to-one, one-to-many, and many-to-many relationships function within Odoo's ORM to build superior, well-structured apps. Learn more! #Odoo #OdooORM #RelationalDatabase #OdooDevelopment #Programming
https://teguhteja.id/odoo-orm-relational-fields-unlock-powerful-data-connections/
Celebrating MySQL 9 Essentials by Neil Smyth, now available at https://bit.ly/41Jk3rj.
ebook: https://pragprog.com/titles/d-nsmysql9
details: https://bit.ly/3DtQHW2
If there's some way to manually edit the starting values for the auto-incrementing IDs that would be cool too.
What is the best way to backup/export a Postgres DB with auto-incrementing ids and restore it without causing IDs to overlap when new items are added?
A plain SQL dump is a no-go because the IDs get reset to 1, which causes the above issue.
A SQL dump omitting the IDs and allowing the DB to generate new IDs on insert is also not ideal because it will fuck up the many various relations.
It seems like there are myths around relational databases that contribute to the idea that they are slow. I saw one person just now who thought that a basic transaction reading from a table would lock the entire table and block everything else from accessing the table.
Relational databases are more efficient than that! Transactions can be isolated without blocking.
What Inka Quipus teach us about data management
* Lesson 1: Without #metadata, your records will not make it into history
* Lesson 2: Human readable encoding is advantageous
* Lesson 3: A document store is more flexible than a classic #relationaldatabase
* Lesson 4: There is ancient logic to append-only databases
#datascience
#sustainablefinance
https://www.openriskmanagement.com/what-inka-quipus-teach-us-about-data-management/
The last project has been completed and I've claimed the #RelationalDatabase #certification from #freeCodeCamp.
Link to my certification:
https://freecodecamp.org/certification/Misty-42/relational-database-v8
...spent way too long trying to get a table join to work thinking it was a formatting issue, then remembered that the area had recently been redistricted. Works like a charm, now! 😭 😂
Can I use a #relationaldatabase to store, parse and analyse #semistructured #JSON data?
It turns out #PostgreSQL is pretty good at it with the dedicated #jsonb functions
Check out an example, finding a good restaurant in India!
Can I use a #relationaldatabase to store, parse and analyse #semistructured #JSON data?
It turns out #PostgreSQL is pretty good at it with the dedicated #jsonb functions
Check out an example, finding a good restaurant in 🇮🇳!
