#relationaldatabases — Public Fediverse posts

Aesthetically-minded alternative to Airtable? Not that anyone has to switch in the near future, but I’m looking to.

#data #relationalDatabases #relationalDb

Aesthetically-minded alternative to Airtable? Not that anyone has to switch in the near future, but I’m looking to.

#data #relationalDatabases #relationalDb

#MySQL 9.7.0 is now generally available!

This version consolidates recent work across the 9.x cycle, including improvements in replication observability, telemetry & query optimization.

Several capabilities previously available only in the Enterprise Edition are now available in the Community Edition.

Learn more: https://bit.ly/49JJbD4

#InfoQ #Oracle #opensource #RelationalDatabases

#MySQL 9.7.0 is now generally available!

This version consolidates recent work across the 9.x cycle, including improvements in replication observability, telemetry & query optimization.

Several capabilities previously available only in the Enterprise Edition are now available in the Community Edition.

Learn more: https://bit.ly/49JJbD4

#InfoQ #Oracle #opensource #RelationalDatabases

Behold! A revolutionary revelation: columnar storage isn’t an alien conspiracy but merely a close cousin to relational databases! 🤯 Because, who knew that rearranging data could still count as normalizing? Next week: 🥁 water is wet!
https://buttondown.com/jaffray/archive/columnar-storage-is-normalization/ #columnarstorage #relationaldatabases #datarearrangement #normalization #technews #HackerNews #ngated

Behold! A revolutionary revelation: columnar storage isn’t an alien conspiracy but merely a close cousin to relational databases! 🤯 Because, who knew that rearranging data could still count as normalizing? Next week: 🥁 water is wet!
https://buttondown.com/jaffray/archive/columnar-storage-is-normalization/ #columnarstorage #relationaldatabases #datarearrangement #normalization #technews #HackerNews #ngated

Lakehouse architectures allow multiple engines to run on shared data through open table formats like #ApacheIceberg.

But #SQL identifier resolution and catalog naming rules differ across engines - creating hidden interoperability failures.

In this #InfoQ article, Maninder Parmar explains why enforcing consistent naming conventions and cross-engine validation is critical.

📰 Read now: https://bit.ly/4902zeH

#RelationalDatabases #DataLake

Lakehouse architectures allow multiple engines to run on shared data through open table formats like #ApacheIceberg.

But #SQL identifier resolution and catalog naming rules differ across engines - creating hidden interoperability failures.

In this #InfoQ article, Maninder Parmar explains why enforcing consistent naming conventions and cross-engine validation is critical.

📰 Read now: https://bit.ly/4902zeH

#RelationalDatabases #DataLake

Software developer and book author Alexey Makhotkin reviews fifth normal form (5NF) and offers valuable links to (some free) further information on relational database design and normalization.

"5NF and Database Design"

https://kb.databasedesignbook.com/posts/5nf/

#programming #databases #relationaldatabases #sql #databasenormalization #normalforms

Software developer and book author Alexey Makhotkin reviews fifth normal form (5NF) and offers valuable links to (some free) further information on relational database design and normalization.

"5NF and Database Design"

https://kb.databasedesignbook.com/posts/5nf/

#programming #databases #relationaldatabases #sql #databasenormalization #normalforms

#Uber redesigned its #MySQL fleet using a consensus-driven architecture based on MySQL Group Replication:
✅ Cluster failover dropped from minutes → seconds
✅ Leader election & failure detection now inside the database layer
✅ Improved availability, simpler orchestration, stronger consistency across thousands of production clusters

Learn more: https://bit.ly/4b8RWYL

#SoftwareArchitecture #DistributedSystems #Clusters #FaultTolerance #RelationalDatabases

#Uber redesigned its #MySQL fleet using a consensus-driven architecture based on MySQL Group Replication:
✅ Cluster failover dropped from minutes → seconds
✅ Leader election & failure detection now inside the database layer
✅ Improved availability, simpler orchestration, stronger consistency across thousands of production clusters

Learn more: https://bit.ly/4b8RWYL

#SoftwareArchitecture #DistributedSystems #Clusters #FaultTolerance #RelationalDatabases

Starting with #MySQL 9.6, foreign key validation & cascade actions will be managed by the SQL layer instead of the InnoDB storage engine.

Why this matters ❓
✅ Better change tracking
✅ More accurate replication
✅ Stronger data consistency

This shift makes MySQL more reliable for CDC pipelines, mixed-database environments, and analytics workloads.

Learn more: https://bit.ly/4rRJqDq

#InfoQ #opensource #RelationalDatabases

Starting with #MySQL 9.6, foreign key validation & cascade actions will be managed by the SQL layer instead of the InnoDB storage engine.

Why this matters ❓
✅ Better change tracking
✅ More accurate replication
✅ Stronger data consistency

This shift makes MySQL more reliable for CDC pipelines, mixed-database environments, and analytics workloads.

Learn more: https://bit.ly/4rRJqDq

#InfoQ #opensource #RelationalDatabases

Using the expand and contract pattern for schema changes

https://www.prisma.io/dataguide/types/relational/expand-and-contract-pattern

#HackerNews #expandAndContract #schemaChanges #dataPatterns #databaseManagement #relationalDatabases #prisma

Using the expand and contract pattern for schema changes

https://www.prisma.io/dataguide/types/relational/expand-and-contract-pattern

#HackerNews #expandAndContract #schemaChanges #dataPatterns #databaseManagement #relationalDatabases #prisma

Better late than never, pt. 2: We have published the (very long) blog post summarising our research seminar in Oslo last April.
👉 Read it on our blog!
https://dsenetwork.hypotheses.org/146

A group of textual scholars & software engineers discussed challenges of #DigitalScholarlyEditions regarding #Sustainability, mainly from a Norwegian perspective.

Headlined by @helling_patrick, we looked at #Coptic #Manuscripts, #Runes in #RelationalDatabases & #XML, #Mycenean #Inscriptions & #Norwegian #ArchivalEditions

Better late than never, pt. 2: We have published the (very long) blog post summarising our research seminar in Oslo last April.
👉 Read it on our blog!
https://dsenetwork.hypotheses.org/146

A group of textual scholars & software engineers discussed challenges of #DigitalScholarlyEditions regarding #Sustainability, mainly from a Norwegian perspective.

Headlined by @helling_patrick, we looked at #Coptic #Manuscripts, #Runes in #RelationalDatabases & #XML, #Mycenean #Inscriptions & #Norwegian #ArchivalEditions

MariaDB plc: Shareholders speak, but execs are quiet - There appears to be many questions and few answers about MariaDB plc’s long-term strat... - https://www.infoworld.com/article/3715311/mariadb-plc-shareholders-speak-but-execs-are-quiet.html#tk.rss_all #relationaldatabases #opensource #database

MariaDB plc: Shareholders speak, but execs are quiet - There appears to be many questions and few answers about MariaDB plc’s long-term strat... - https://www.infoworld.com/article/3715311/mariadb-plc-shareholders-speak-but-execs-are-quiet.html#tk.rss_all #relationaldatabases #opensource #database

Congrats to @codydunne & Wolfgang Gatterbauer for their #SIGMOD 2024 best paper honorable mention (one of 3 for the conference)!

Check out "On the reasonable effectiveness of Relational Diagrams: explaining relational query patterns and the pattern expressiveness of relational languages" here:

https://vis.khoury.northeastern.edu/pubs/Gatterbauer2024ReasonableEffectiveness/

#SQL #RDBMS #RelationalDatabases #RelationalAlgebra #RelationalCalculus #Logic #Visualization #HCI

Congrats to @codydunne & Wolfgang Gatterbauer for their #SIGMOD 2024 best paper honorable mention (one of 3 for the conference)!

Check out "On the reasonable effectiveness of Relational Diagrams: explaining relational query patterns and the pattern expressiveness of relational languages" here:

https://vis.khoury.northeastern.edu/pubs/Gatterbauer2024ReasonableEffectiveness/

#SQL #RDBMS #RelationalDatabases #RelationalAlgebra #RelationalCalculus #Logic #Visualization #HCI

SQL at 50: What’s next for the structured query language? - In May 1974, Donald Chamberlin and Raymond Boyce published a paper on SEQUEL, a struct... - https://www.infoworld.com/article/3715453/sql-at-50-whats-next-for-the-structured-query-language.html#tk.rss_all #programminglanguages #relationaldatabases #softwaredevelopment #analytics #database #sql

SQL at 50: What’s next for the structured query language? - In May 1974, Donald Chamberlin and Raymond Boyce published a paper on SEQUEL, a struct... - https://www.infoworld.com/article/3715453/sql-at-50-whats-next-for-the-structured-query-language.html#tk.rss_all #programminglanguages #relationaldatabases #softwaredevelopment #analytics #database #sql

Trying to come up with the fundamental principles of the #RelationalDatabases and #SQL way of thinking:

- Common Language
SQL as the "lingua franca" of data. This was revolutionary 50 years ago when data had a "tower of babel" situation.

- Single source of truth
To avoid ambiguities and to conserve (expensive lol) storage space.

- Garbage in = Garbage out
Use strong typing at input-time to ensure data quality at output-time.

What else might also be such a high-level guiding principle?

Trying to come up with the fundamental principles of the #RelationalDatabases and #SQL way of thinking:

- Common Language
SQL as the "lingua franca" of data. This was revolutionary 50 years ago when data had a "tower of babel" situation.

- Single source of truth
To avoid ambiguities and to conserve (expensive lol) storage space.

- Garbage in = Garbage out
Use strong typing at input-time to ensure data quality at output-time.

What else might also be such a high-level guiding principle?

Evaluating databases for sensor data - The world has become “sensor-fied.”Sensors on everything, including cars, factory mach... - https://www.infoworld.com/article/3714600/evaluating-databases-for-sensor-data.html#tk.rss_all #relationaldatabases #softwaredevelopment #internetofthings #cloudcomputing #edgecomputing #analytics #database

Evaluating databases for sensor data - The world has become “sensor-fied.”Sensors on everything, including cars, factory mach... - https://www.infoworld.com/article/3714600/evaluating-databases-for-sensor-data.html#tk.rss_all #relationaldatabases #softwaredevelopment #internetofthings #cloudcomputing #edgecomputing #analytics #database

Managed #RelationalDatabases offer convenience, but are you aware of the hidden costs?

Gain valuable insights into monitoring service expenses, revising default settings, and understanding operational constraints.

#InfoQ article by Vignesh Ravichandran: https://bit.ly/3VewIBa

#CloudComputing

Managed #RelationalDatabases offer convenience, but are you aware of the hidden costs?

Gain valuable insights into monitoring service expenses, revising default settings, and understanding operational constraints.

#InfoQ article by Vignesh Ravichandran: https://bit.ly/3VewIBa

#CloudComputing

How a new database architecture supports scale and reliability in TiDB - In the good old days, databases had a relatively simple job: help with the monthly bil... - https://www.infoworld.com/article/3713284/how-a-new-database-architecture-supports-scale-and-reliability-in-tidb.html#tk.rss_all #relationaldatabases #softwaredevelopment #analytics #database #sql

How a new database architecture supports scale and reliability in TiDB - In the good old days, databases had a relatively simple job: help with the monthly bil... - https://www.infoworld.com/article/3713284/how-a-new-database-architecture-supports-scale-and-reliability-in-tidb.html#tk.rss_all #relationaldatabases #softwaredevelopment #analytics #database #sql

Why SQL still rules - SQL, the Structured Query Language, remains one of the most widely used programming la... - https://www.infoworld.com/article/3713204/why-sql-still-rules.html#tk.rss_all #relationaldatabases #softwaredevelopment #analytics #database #sql

Why SQL still rules - SQL, the Structured Query Language, remains one of the most widely used programming la... - https://www.infoworld.com/article/3713204/why-sql-still-rules.html#tk.rss_all #relationaldatabases #softwaredevelopment #analytics #database #sql

Can MariaDB’s enterprise business be saved? - A non-binding proposal to acquire MariaDB, the provider of the relational database man... - https://www.infoworld.com/article/3713160/can-mariadbs-enterprise-business-be-saved.html#tk.rss_all #relationaldatabases #technologyindustry #cloudcomputing #database

Can MariaDB’s enterprise business be saved? - A non-binding proposal to acquire MariaDB, the provider of the relational database man... - https://www.infoworld.com/article/3713160/can-mariadbs-enterprise-business-be-saved.html#tk.rss_all #relationaldatabases #technologyindustry #cloudcomputing #database

Can MariaDB’s enterprise business be saved? - A non-binding proposal to acquire MariaDB, the provider of the relational database man... - https://www.infoworld.com/article/3713083/can-mariadbs-enterprise-business-be-saved.html#tk.rss_all #relationaldatabases #technologyindustry #database #mysql

Can MariaDB’s enterprise business be saved? - A non-binding proposal to acquire MariaDB, the provider of the relational database man... - https://www.infoworld.com/article/3713083/can-mariadbs-enterprise-business-be-saved.html#tk.rss_all #relationaldatabases #technologyindustry #database #mysql

Can MariaDB’s commercial business be saved? - A non-binding proposal to acquire MariaDB, the provider of the relational database man... - https://www.infoworld.com/article/3713083/can-mariadbs-commercial-business-be-saved.html#tk.rss_all #relationaldatabases #technologyindustry #database #mysql

Can MariaDB’s commercial business be saved? - A non-binding proposal to acquire MariaDB, the provider of the relational database man... - https://www.infoworld.com/article/3713083/can-mariadbs-commercial-business-be-saved.html#tk.rss_all #relationaldatabases #technologyindustry #database #mysql

Oracle Autonomous Database adds AI conversation support - Oracle has updated its Autonomous Database offering in an effort to maintain its lead ... - https://www.infoworld.com/article/3712924/oracle-autonomous-database-adds-ai-conversation-support.html#tk.rss_all #relationaldatabases #oracledatabase #cloudcomputing #database #oracle

Oracle Autonomous Database adds AI conversation support - Oracle has updated its Autonomous Database offering in an effort to maintain its lead ... - https://www.infoworld.com/article/3712924/oracle-autonomous-database-adds-ai-conversation-support.html#tk.rss_all #relationaldatabases #oracledatabase #cloudcomputing #database #oracle

Why developers should put the database first - Developers of a certain age are used to beginning their application development journe... - https://www.infoworld.com/article/3712840/why-developers-should-put-the-database-first.html#tk.rss_all #relationaldatabases #softwaredevelopment #developmenttools #nosqldatabases #database #bigdata #apis #sql

Why developers should put the database first - Developers of a certain age are used to beginning their application development journe... - https://www.infoworld.com/article/3712840/why-developers-should-put-the-database-first.html#tk.rss_all #relationaldatabases #softwaredevelopment #developmenttools #nosqldatabases #database #bigdata #apis #sql

New AI features for developers in SingleStoreDB - Generative AI has had an immediate and enormous impact on software development. Softwa... - https://www.infoworld.com/article/3712502/new-ai-features-for-developers-in-singlestoredb.html#tk.rss_all #artificialintelligence #relationaldatabases #softwaredevelopment #generativeai #database #sql

New AI features for developers in SingleStoreDB - Generative AI has had an immediate and enormous impact on software development. Softwa... - https://www.infoworld.com/article/3712502/new-ai-features-for-developers-in-singlestoredb.html#tk.rss_all #artificialintelligence #relationaldatabases #softwaredevelopment #generativeai #database #sql

4 new AI features for developers in SingleStoreDB - Generative AI has had an immediate and enormous impact on software development. Softwa... - https://www.infoworld.com/article/3712502/4-new-ai-features-for-developers-in-singlestoredb.html#tk.rss_all #artificialintelligence #relationaldatabases #softwaredevelopment #generativeai #database #sql

4 new AI features for developers in SingleStoreDB - Generative AI has had an immediate and enormous impact on software development. Softwa... - https://www.infoworld.com/article/3712502/4-new-ai-features-for-developers-in-singlestoredb.html#tk.rss_all #artificialintelligence #relationaldatabases #softwaredevelopment #generativeai #database #sql

Toad Data Studio manages SQL, NoSQL, and cloud databases - Systems management and security software provider Quest Software is shipping Toad Data... - https://www.infoworld.com/article/3712250/toad-data-studio-manages-sql-nosql-and-cloud-databases.html#tk.rss_all #relationaldatabases #datamanagement #nosqldatabases #database #json #sql

Toad Data Studio manages SQL, NoSQL, and cloud databases - Systems management and security software provider Quest Software is shipping Toad Data... - https://www.infoworld.com/article/3712250/toad-data-studio-manages-sql-nosql-and-cloud-databases.html#tk.rss_all #relationaldatabases #datamanagement #nosqldatabases #database #json #sql

Oracle introduces JavaScript support in MySQL - Oracle has introduced JavaScript support in the MySQL database, allowing developers to... - https://www.infoworld.com/article/3711862/oracle-introduces-javascript-support-in-mysql.html#tk.rss_all #relationaldatabases #softwaredevelopment #javascript #database #mysql

Oracle introduces JavaScript support in MySQL - Oracle has introduced JavaScript support in the MySQL database, allowing developers to... - https://www.infoworld.com/article/3711862/oracle-introduces-javascript-support-in-mysql.html#tk.rss_all #relationaldatabases #softwaredevelopment #javascript #database #mysql

#MySQL 8.2 is now generally available, including support for Read/Write Splitting support!

This long-awaited feature has been introduced in the latest innovation release and helps optimize database performance & scalability.

Details on #InfoQ: https://bit.ly/3svcMOo

#Oracle #SQL #Database #RelationalDatabases

#MySQL 8.2 is now generally available, including support for Read/Write Splitting support!

This long-awaited feature has been introduced in the latest innovation release and helps optimize database performance & scalability.

Details on #InfoQ: https://bit.ly/3svcMOo

#Oracle #SQL #Database #RelationalDatabases

Still time to register for this two-part workshop (beginner and advanced) on Nodegoat to be hosted at UGent on 16/11 (with support from CLARIAH-VL)! 👇 👇

#dhinbelgium #digitalhumanities #relationaldatabases https://glammr.us/@socket0/111126227726679138

What software developers should know about SQL - Since Structured Query Language was invented in the early 1970s, it has been the defau... - https://www.infoworld.com/article/3708291/what-software-developers-should-know-about-sql.html#tk.rss_all #relationaldatabases #softwaredevelopment #database #sql

What software developers should know about SQL - Since Structured Query Language was invented in the early 1970s, it has been the defau... - https://www.infoworld.com/article/3708291/what-software-developers-should-know-about-sql.html#tk.rss_all #relationaldatabases #softwaredevelopment #database #sql

Kinetica offers its own LLM for SQL queries, citing security, privacy concerns - Citing privacy and security concerns over public large language models, Kinetica is ad... - https://www.infoworld.com/article/3706952/kinetica-offers-its-own-llm-for-sql-queries-citing-security-privacy-concerns.html#tk.rss_all #relationaldatabases #generativeai #sql

Kinetica offers its own LLM for SQL queries, citing security, privacy concerns - Citing privacy and security concerns over public large language models, Kinetica is ad... - https://www.infoworld.com/article/3706952/kinetica-offers-its-own-llm-for-sql-queries-citing-security-privacy-concerns.html#tk.rss_all #relationaldatabases #generativeai #sql

4 key new features in PostgreSQL 16 - Today, the PostgreSQL Global Development Group shared the release of PostgreSQL 16. Wi... - https://www.infoworld.com/article/3706515/4-key-new-features-in-postgresql-16.html#tk.rss_all #relationaldatabases #softwaredevelopment #cloudcomputing #postgresql #database