SQLite VS Apache Cassandra

SQLite Reviews

Apache Cassandra Reviews

SQLite mentions (18)

• Can I have my Lightroom catalogue pointing at two sources...?

  Yes. A Lightroom catalog file is, after all, just a SQLite database. (Srsly, make a copy of your catalog file, rename it whatever.sqlite and use your favorite SQLite GUI to rip it open and look at the tables and fields). It's just storing the pathame to the RAW file for that file's record in the database. Source: 11 months ago

• Building a database to search Excel files

  I use visidata with a playback script I recorded to open the sheet to a specific Excel tab, add a column, save the sheet as a csv file. Then I have a sqlite script that takes the csv file and puts it in a database, partitioned by monthYear. Source: about 1 year ago

• Saw this on my friends Snapchat story, this hurts my heart

  Use the most-used database in the world: https://sqlite.org/index.html. Source: about 1 year ago

• "Managing" a SQLite Database with J (Part 2)

  With this in mind, I wrote a few versions of this post, but I hated them all. Then I realized that jodliterate PDF documents mostly do what I want. So, instead of rewriting MirrorXref.pdf, I will make a few comments about jodliterate group documents in general. If you're interested in using SQLite with J, download the self-contained GitHub files MirrorXref.ijs and MirrorXref.pdf and have a look. - Source: dev.to / over 1 year ago

• "Managing" a SQLite Database with J (Part 1)

  SQLite, by many estimates, is the most widely deployed SQL database system on Earth. It's everywhere. It's in your phone, your laptop, your cameras, your car, your cloud, and your breakfast cereal. SQLite's global triumph is a gratifying testament to the virtues of technical excellence and the philosophy of "less is more.". - Source: dev.to / over 1 year ago

Apache Cassandra mentions (40)

• Understanding SQL vs. NoSQL Databases: A Beginner's Guide

  On the other hand, NoSQL databases are non-relational databases. They store data in flexible, JSON-like documents, key-value pairs, or wide-column stores. Examples include MongoDB, Couchbase, and Cassandra. - Source: dev.to / 19 days ago

• How to choose the right type of database

  HBase and Cassandra: Both cater to non-structured Big Data. Cassandra is geared towards scenarios requiring high availability with eventual consistency, while HBase offers strong consistency and is better suited for read-heavy applications where data consistency is paramount. - Source: dev.to / about 2 months ago

• Asynchronous driver written in Rust for ScyllaDB, Cassandra and AWS Keyspaces.

  Dear r/python, we are happy to present you with our first open-source project. We have managed to implement a new driver for Python that works with Apache Cassandra, ScyllaDB and AWS Keyspaces. Source: 7 months ago

• How to Choose the Right Document-Oriented NoSQL Database for Your Application

  NoSQL is a term that we have become very familiar with in recent times and it is used to describe a set of databases that don't make use of SQL when writing & composing queries. There are loads of different types of NoSQL databases ranging from key-value databases like the Reddis to document-oriented databases like MongoDB and Firestore to graph databases like Neo4J to multi-paradigm databases like FaunaDB and... - Source: dev.to / 8 months ago

• NoSQL Databases vs Graph Databases: Which one should you use?

  To use NoSQL databases with code, you first need to choose a NoSQL database that suits your requirements. Some popular examples of NoSQL databases are MongoDB, Cassandra, Redis, and DynamoDB. Each of these databases has its own set of APIs and drivers that can be used to interact with them. Here, I'll use MongoDB as an example and explain how to perform CRUD operations using Python and its PyMongo package. - Source: dev.to / about 1 year ago