Simpler than SQLite

Do you know any SQLite-like database that stores its data in easily readable plain text format (like multi-line json or yaml)? I'd like to store some data along with my project in version control...

What database backends are readily available for Ruby on Rails?

In the introductory tutorials, it talks about MySQL, Postgre and Sqlite3. Is anything else supported out-of-the-box? Are there any plugins to support other databases? I'm mainly interested in...

What type of NoSQL database is best suited to store hierarchical data?

What type of NoSQL database is best suited to store hierarchical data? Say for example I want to store posts of a forum with a tree structure: original post + re: original post + re: original...

How to JSON serialize sets?

I have a Python set that contains objects with __hash__ and __eq__ methods in order to make certain no duplicates are included in the collection. I need to json encode this result set, but passing...

MongoDB dot (.) in key name

It seems mongo does not allow insertion of keys with a dot (.) or dollar sign ($) however when I imported a JSON file that contained a dot in it using the mongoimport tool it worked fine. The...

NoSQL Database for ECommerce

I will be constructing an ecommerce site, and would like to use a no-sql database, which will fit well with the plans for the app. But when it comes to which database would fit the job, im not...

Read Data from HBase

I'm new to HBase, what's the best way to retrieve results from a table, row by row? I would like to read the entire data in the table. My table has two column families say col1 and col2.

Stored procedure in Neo4j

I wanted to know if there is any Neo4j equivalent of a stored procedure? When I researched this, I came across events, but I found them more like triggers and not stored procedures.

Creating multiple GSIs by updateTable - DynamoDB

I'm uisng updateTable of DynmaoDB and based on the documentation, if we want to create multiple Global Secondary Indexes (GSIs) we need to have multiple objects in "GlobalSecondaryIndexUpdates"...

How can i change the name of databases in redis?

How can i change the name of databases in redis? Example: Db01 key01 key02 Db02 key01 key02 Db03 key01 key02 i want to change db01 name or db02, db03 to other names

Count documents by ignoring duplicates in array

Each appointment has some services. I want to find total count of appointments for each service. My document looks like this: [{ "appointmentTag":"xyz", "services" : [ { "name" :...

NodeJS, Redis and MySQL

Please has anyone ever used NodeJS + Redis + MySQL The goal is to have NodeJS fetch data from Redis and only reach MySQL if data not found, also update MySQL back with the data. Then how can i run...

AutoIncrement _id in pouchdb

I have implemented a queue in pouchDB, where each record is stored as a separate document. Each record resembles a post request, so that when the user is offline I can save the requests in the...

Why you should not use nosql for financial transaction

I heard from a speaker at a Hackaton event organized by a bank that you should not use nosql for financial transaction for security reasons. But I have no idea what he's saying. I have been...

Is Apache Ignite suited for NoSQL schema

Is JSON within a JSON supported within Apache Ignite? Example: { "stuff": { "onetype": [ {"id":1,"name":"John Doe"}, {"id":2,"name":"Don Joeh"} ], ...

Query firebase data by timestamp month

So i have my records in firebase cloud firestore like this : [ { "category":"drinks", "expensetype":"card", "id":"5c673c4d-0a7f-9bb4-75e6-e71c47aa8d1d", ...

Fast database solutions for Python Programming

Situation: Need to deal with large amounts of data (~260MB CSV datafile of about 50B of data per line) Problem: If I just read from the file every time I need to deal with it, it will take a long...

Converting a list column to a set column in cassandra/DSE

While iterating on a new feature my team created a list column in our DSE database. We now want it to be a set column. I dropped the column and created it again as a set column and got this...

Connect Cassandra NoSQL DB and get the response as JSON response

One of our project, we have to get the data from Cassandra tables and populate it in JSON format in response. What are the possible ways to do it for the same? Some time, we require to get the...

MongoDB mongoose Deprecation Warning

While querying the documents by using collection.find I started getting following warning in my console DeprecationWarning: collection.find option [fields] is deprecated and will be removed in a...

Any Persistent NoSQL datastore for Flutter?

I'm looking for a Flutter NoSQL persistence DB with basic query system. I found sembast I would like to know alternatives or better solutions

PostgreSQL with Django: should I store static JSON in a separate MongoDB database?

Context I'm making, a Django web application that depends on scrapped API data. The workflow: A) I retrieve data from external API B) Insert structured, processed data that I need in my PostgreSQL...

Error while creating foreign relation in knex - table creation race condition

I'm new to knex and haven't touched RDBMS in years (been in NoSQL land), so bear with me here. I've got two migration files, one for tracks and one for users (tracks are owned by users). Below are...

How do I set up the relationship between tables using firebase?

I want to create a relational table on the google console screen using firebase. How can I make the relationship between the user table and the user's posts table on the google console screen

How to update specific field of hive object in flutter?

I am using hive as my NoSQL local database in my flutter app. Following is my Hive Class: import 'dart:convert'; import 'package:hive/hive.dart'; import...

MongoDb aggregate lookup with large number of documents?

I'm using MongoDB and trying to do aggregation lookup. The number of documents in the collection which is being used in "from" attribute of $lookup is in thousands. Now, this is taking up all the...

Writting down $subtract in No-SQL MongoDB in a sophisticated way

I'm doing MongoDB Academy, and for this question: What is the difference between the number of people born in 1998 and the number of people born after 1998 in the sample_training.trips...

MongoDB Atlas search: sort by "searchScore"

I run the following aggregation pipeline and it works well: [ { $search: { text: { query: text, path: 'name', fuzzy: { maxEdits: 2, ...

Spring MongoDB Some fields are not being saved nor updated at all

I'm trying to save a document in MongoDB collection via MongoRepository.save method. Here's my code. The document class: @Document(collection = "appointments") public class...

Is there a NoSQL alternative to SQLite for flutter?

I am building a standalone(no API calls to MongoDB or Firebase etc.) flutter app for which database management is crucial. Currently, I am storing it as JSON, but it's simply inefficient. I cannot...