Honestly, there was a time where MariaDB was relevant, and that was when PostgreSQL was weird, MS SQL was costly, and MySQL was on the verge of being proprietary.
Today, MS SQL has low entrance barriers, MySQL still works, and PostgreSQL is versatile and rock solid.
👋 Valued contacts in IT and specifically in the #PostgreSQL / #Database community: I'd love it if you could reach out to me with insights or stories to tell regarding 🧠 mental health in the #IT#workplace. Many thanks in advance 🙏
It may be 10 years old, and it threw a lot of warnings at me when I asked MELPA to install it, but the edbi package for #emacs does just what I want. Let me poke around in a #database before I have to write queries for it.
This page is a hidden gem, it's in German but you will get around. It's a #camera#museum that categorised all its #cameras in a searchable #database.
It's absolutely brilliant (tough obviously not compete) if you are looking for a specific #analog camera, a certain #film format or #objective. Also great for finding an alternative👌
Cantus: A Database for Latin Ecclesiastical Chant - Inventories of Chant Sources | Cantus Manuscript Database https://cantus.uwaterloo.ca/
"Cantus is a database of the Latin chants found in manuscripts and early printed books, primarily from medieval Europe. This searchable digital archive holds inventories of antiphoners and breviaries -- the main sources for the music sung in the Latin liturgical Office -- as well as graduals and other sources for music of the Mass."
Slightly different database question today:
I am interested in online, remote database for my Android Apps
Is there anywhere (cheap/free) that I can use, or do I have to set up my own (I have a domain/website)
I know about Firebase, but that is NoSQL/document-database.
#SQL Server #Management Studio (SSMS) is one of the most proven #database administration and management tools. Whether you use SQL Server Management Studio for Database Administrators or just for database #development, it's a proven tool. We want to increase our capabilities, adapting this tool to our specific needs. For this, we use a range of SSMS add-ins and extensions.
We'll discuss two productivity-focused add-ins that #help us achieve more in less time. https://pike.link/DJcdG...
SQL, or Structured Query Language, serves as the backbone for managing data in databases across various systems like MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and more. In this tutorial, we'll delve into the fundamental aspects of SQL, exploring its syntax, key commands, and the role it plays in...
In order to sort items in a table you use a "sort key", but then when you want to delete one of the items in the table you then have to provide the primary key and the sort key.
I get why; it's partitioning based on keys, and the sort key is part of the compound key, so it needs it to fully address the row you're deleting.
SQL Tutorials : Basics to Advanced Concepts 2024 (sqlpey.com)
SQL, or Structured Query Language, serves as the backbone for managing data in databases across various systems like MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and more. In this tutorial, we'll delve into the fundamental aspects of SQL, exploring its syntax, key commands, and the role it plays in...