#relationaldatabases — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #relationaldatabases, aggregated by home.social.
-
#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
-
#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
-
#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
-
#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
-
#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
-
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 -
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 -
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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 clustersLearn 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 consistencyThis shift makes MySQL more reliable for CDC pipelines, mixed-database environments, and analytics workloads.
Learn more: https://bit.ly/4rRJqDq
-
Diving deeper into relational architecture today.
Inner joins, schema design, mind‑mapping concepts… everything clicks when you visualize how data truly connects.Loving this workflow:
📚 Source →
💬 Chat explanation →
🧠 Mind map →
💻 SQL practiceA powerful reminder that mastering SQL isn’t just about queries — it’s about understanding the logic behind the relationships.
#SQL #DataEngineering #DataAnalytics #LearningSQL #RelationalDatabases #TechLearning #MindMapping #DataModeling
-
https://www.europesays.com/uk/710312/ Prisma 7: Rust-Free Architecture and Performance Gains #Arts #ArtsAndDesign #CockroachDB #Design #Development #Entertainment #MONGODB #MySQL #ORM #performance #Postgres #Prisma7Performance #RelationalDatabases #Rust #SQL #TypeScript #UK #UnitedKingdom #WebDevelopment
-
https://www.europesays.com/ie/295228/ Prisma 7: Rust-Free Architecture and Performance Gains #Arts #ArtsAndDesign #ArtsAndDesign #ArtsDesign #CockroachDB #Design #Development #Éire #Entertainment #IE #Ireland #mongoDB #MySQL #ORM #performance #Postgres #Prisma7Performance #RelationalDatabases #Rust #SQL #TypeScript #WebDevelopment
-
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
-
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
-
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/146A 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
-
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
-
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
-
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
-
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
-
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
-
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
-
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 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
-
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
-
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