Loading…
Where the data lives. Split between relational systems, which enforce a schema and answer with SQL, and NoSQL and vector stores, which trade that structure for flexibility or for similarity search. The SQL topic under Languages & Frameworks covers the query language itself; this area covers the engines that run it.
Relational databases I have worked with for more than 20 years, and the document and vector stores I have added for cloud applications and AI workflows.
From the blog
Articles from JWS News and DEV that relate to databases.
It has been a little while since I last played around with a NoSQL database on the blog. Back in 2014, I wrote a few posts about CouchDB and over the years, I have done a bit with Firebase. Today’s topic is going to be MongoDB.
Lately, I have been working with a lot of legacy SQL and this has caused me to think about what makes SQL (and database designs) good and bad. There is a concept called ACID, defined within ISO/IEC 10026-1:1992. ACID is an acronym, that stands for Atomicity, Consistency, Isolati…
I was playing around with consumption of a CouchDB JSON feed when I received the familiar “Cross-Origin Request Blocked” error. The question is, “How do you enable CORS in CouchDB?” If you open the ‘Configuration’ tool, you will find ‘enable_c…
So, you just created a CouchDB database, added a user to it, and want access to be limited to that user? There is a simple way of doing this. Let’s use a previous example, for this demo. As you can see below, by default, you do not need to be authenticated, in order to interact…
If you are like me, you probably have not had much of a reason to use NoSQL but you have been interested in it. I recently decided to check out CouchDB. CouchDB is an Apache project that was created in 2005 by Damien Katz. CouchDB is interesting in that it stores your data with…
Database normalization is a process meant to reduce or eliminate data redundancy. Typically, a normalized database exists in first normal form (1NF), second normal form (2NF), or third normal form (3NF). First Normal Form In order for a database to be in first normal form, your…
From GoToSocial
Short posts about databases, matched by topic hashtags.
