relational-databases

Rethinking SQL: The Case for a New Era of Relational Query Languages

SQL has long been the dominant language for relational databases, but its limitations are becoming increasingly apparent. As technology evolves, the need for a more expressive, compressible, and porou...

https://news.lavx.hu/article/rethinking-sql-the-case-for-a-new-era-of-relational-query-languages

Revolutionizing Content Management: The CityDesk Approach

In an era dominated by web-based solutions, Fog Creek Software's CityDesk stands out as a testament to the power of desktop applications. By challenging norms and prioritizing user experience, CityDes...

https://news.lavx.hu/article/revolutionizing-content-management-the-citydesk-approach

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

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 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