#relationaldatabase — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #relationaldatabase, aggregated by home.social.
-
Interesting article about the various MVCC implementations that exist in various relational databases.
-
Interesting article about the various MVCC implementations that exist in various relational databases.
-
#AWS updated Amazon #AuroraServerless with a new platform version that improves scaling behavior & runtime efficiency.
➡️ up to 45% faster scale-up during demand spikes
➡️ up to 30% performance improvement via improved resource scheduling + workload-aware scalingLearn more: https://bit.ly/3PFT9P7
-
#AWS updated Amazon #AuroraServerless with a new platform version that improves scaling behavior & runtime efficiency.
➡️ up to 45% faster scale-up during demand spikes
➡️ up to 30% performance improvement via improved resource scheduling + workload-aware scalingLearn more: https://bit.ly/3PFT9P7
-
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
-
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/
-
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/
-
If there's some way to manually edit the starting values for the auto-incrementing IDs that would be cool too.
-
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.
-
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.
-
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
#sustainablefinancehttps://www.openriskmanagement.com/what-inka-quipus-teach-us-about-data-management/
-
...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 🇮🇳!
-
CockroachDB, the database that just won’t die - There is an art to engineering, and sometimes engineering can transform art. For S... - http://feedproxy.google.com/~r/Techcrunch/~3/7jwREsw-jM4/ #eccloudandenterpriseinfrastructure #ecenterpriseapplications #relationaldatabase #cockroachdbec-1 #datamanagement #cockroachlabs #dataanalysis #cockroachdb #newyorkcity #enterprise #databases #larrypage #startups #snapchat #amazon #mysql #ec-1 #saas
-
How engineers fought the CAP theorem in the global war on latency - CockroachDB was intended to be a global database from the beginning. The founders ... - http://feedproxy.google.com/~r/Techcrunch/~3/gK-h_KYisso/ #eccloudandenterpriseinfrastructure #ecenterpriseapplications #relationaldatabase #cockroachdbec-1 #datamanagement #cockroachlabs #cockroachdb #enterprise #databases #startups #database #ec-1 #saas
-
“Developers, as you know, do not like to pay for things” - In the previous part of this EC-1, we looked at the technical details of Cockroach... - http://feedproxy.google.com/~r/Techcrunch/~3/pecDJB46Ydw/ #eccloudandenterpriseinfrastructure #ecenterpriseapplications #distributedcomputing #cloudinfrastructure #databasemanagement #relationaldatabase #cockroachdbec-1 #cloudcomputing #cockroachlabs #cockroachdb #enterprise #databases #startups #oracle #cloud #mysql #ec-1 #saas #tc
-
How Expensify hacked its way to a robust, scalable tech stack - Take a close look at any ambitious startup and you’ll find pugnacity nestled in it... - http://feedproxy.google.com/~r/Techcrunch/~3/A2mIILPsoF8/ #corporateexpensemanagement #artificialintelligence #relationaldatabase #expensemanagement #expensereporting #expensereports #expensifyec-1 #davidbarrett #reactnative #enterprise #expensify #finance #bedrock #cloud #ec-1 #saas
-
China’s e-commerce giant JD.com starts paying some staff in digital yuan - China’s plan to introduce its digital currency is getting a lot of help from its t... - http://feedproxy.google.com/~r/Techcrunch/~3/PorzRz4lZZE/ #relationaldatabase #digitalcurrency #centralbank #digitalyuan #antgroup #bilibili #finance #alibaba #huawei #jd.com #china #asia #bank #yuan #tc
-
Apollo raises $22M for its GraphQL platform - Apollo, a San Francisco-based startup that provides a number of developer and operator tools and ser... more: http://feedproxy.google.com/~r/Techcrunch/~3/MLDNZuuXTiM/ #andreessenhorowitz #relationaldatabase #trinityventures #datamanagement #graphdatabases #matrixpartners #graphdatabase #sanfrancisco #enterprise #javascript #developer #computing #database #facebook #android #apollo #meteor #player #api #ceo #cto #sql #tc
