Questions tagged [sqlite]

The world's most used relational database system. Use this tag if your request is specific to SQLite databases; if it can be just "any" database, use the "database" tag instead.

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

Best Free SQL Program to Upload Excel CSV file

I am looking for a free program that works with Mac and is able to upload an Excel CSV file. The reason for this request is because I have an interview and the company gave me an assignment to write ...
-1
votes
0answers
2 views

Looking for a DB recommendation for heavy-load concurrent SELECT operations (Deployed to Kubernetes)

I'm running a microservice that requires a pretty hefty backing DB for calculation referencing. Essentially, a whole bunch of k8s pods need to go and read from this DB in parallel as they divvy up a ...
1
vote
0answers
23 views

Database with good compression so it results in an extremely small file

I am looking to store data from my program in a database but it's important that the data size is extremely small; I do not care much about read or write speed as long as it's less than 30 seconds and ...
-3
votes
0answers
8 views

How to integrate a psql database in my python module conda distribution? [closed]

I have developed a python package that I would like to distribute through conda. This package makes queries (using psycogp2, a python module) to a local psql database. Now, if I wish to distribute my ...
1
vote
0answers
7 views

Database reccomendation for retrival of data (strings, int and float) with python

I'm looking for recommendation for the following: I currently have approximately 10 Million csv file each with the following identical data structure as file attached: I want to transfer all this ...
0
votes
0answers
4 views

Synch Data to and From Android device using SQLite db to MS-SQL db

I have an android app which makes use of a local sqlite db. We have developed our own code to synch data between the sqlite db and a cloud based sql standard/express db... the only problem is our ...
-2
votes
0answers
5 views

To connect sqlite fil to google spreasheet in real time

i am using sqlite3 for django project.i want to connect my sqlite file to google spreadsheet.so when there in changes in database it will also change my google sheet accordingly. Is it possible?
1
vote
0answers
12 views

Tool to benchmark Sqlite, MongoDB and InfluxDB for embedded systems

So I searched Databases for Embedded systems and ARM processors for data from sensors. I selected 3-4 databases, Sqlite, MongoDB, InfluxDB and maybe Prometheus. I would like to compare them so I would ...
0
votes
0answers
8 views

c++ Shared Memory DB with Synchronization

we are facing a problem where we need advice. Currently, our project uses a SQLite in-memory database, which also works well. Unfortunately, we can not really work with multithreading because the ...
1
vote
1answer
19 views

File based database: Sqlite, MongoDb or else?

I am looking for a file-based database solution, where the original inputs are in csv format. Key info: One complete dataset is a static collection of files. However, I will need to have multiple ...
0
votes
0answers
6 views

Running a database on nanohttpd on android app

I need some recommendations for running a database on a nanohttpd server. I was using sqlite directly on my android app ( it is a restaurant order taking app) but I now I need to run my database on a ...
0
votes
0answers
5 views

SQL Layer for HTML5 Localstorage

looking for recommendations for a JS or Typescript library to use SQL to insert & query data using localstorage as a persistance layer in an HTML5 browser. Thanks!
0
votes
0answers
3 views

Database tools to develop a simple client journal on MacOS

I have a Linux/LibreOffice based Client Journal Application, which I like to migrate to MacOS. The program uses a relational database as back-end and allows the user to keep track of services provided ...
1
vote
1answer
51 views

Choosing the right database management system?

I am writing a Telegram bot script which needs to store inputted user data. I have no real experience using database management systems such as SQLite, MySQl and Postgres. I don't need my application ...
0
votes
0answers
7 views

Is there “everything” like interface async text searching software?

I'm looking for a software or opensource project for creating grafical interface which featured asynchronously searching for sqlite database or CSV formatting file or both. Because I'm leaning ...
0
votes
0answers
7 views

How to display and allow multiple users to query data from sqlite database?

I have a small sqlite database with csv's and Google sheets data joined together. Basically just need a platform that connects to the data with a UI that doesn't require SQL knowledge to query on and ...
0
votes
1answer
29 views

Need a database for a single-user app to sync data across computers without storing on the internet

Need suggestions for a database. I'm tasked to write a C# desktop application for a small business. The business owner does not want his data to be stored on the internet. He has two desktop computers....
1
vote
0answers
30 views

Simple micro framework for CRUD DB editing (PHP preferred)

I'm looking for the a very simple micro framework or similar free tool to make administrating an SQLite DB easier. Something like SQL views, but more powerful. So basically an admin interface. The ...
0
votes
0answers
5 views

Javascript friendly alternative to Sqlite

I have an electronJS application utilizing sqlite. I would like to know if there is an equivalent embedded database written in pure javascript that I can use for ellectronJS.
1
vote
0answers
12 views

Software for visualizing database schema from existing SQLite database

Dear Stackexchange Community, my little problem looks like followed: I have an existing SQLite3 Database with 15 Tables and I am looking for a tool that automatically creates me a Visualisation of ...
1
vote
0answers
17 views

Java library supporting SQLite virtual tables

SQLite has feature named "Virtual Tables", which "allows an application to publish interfaces that are accessible from SQL statements as if they were tables". https://www.sqlite.org/vtab.html For ...
0
votes
0answers
21 views

Reporting/Dashboard with some light data entry capabilities

Coming from a Business Intelligence background, I have seen a ton of reporting tools that are all great but never are able to write back (update/insert) to a database. For a small personal project I ...
3
votes
2answers
51 views

Embedded database to distribute with an open source webapp

I'm looking to build an open source website project that will require a small database backend. I'm leaning towards using SQLite since the website will be simple, low traffic, and the users of the ...
5
votes
3answers
273 views

Software tool to create/modify/view table relationships in SQLite database

I would like to have a software tool to create/modify/view table relationships in a SQLite database in a visual way, something like the picture below. For a MySQL database, I can use the MySQL ...
1
vote
0answers
19 views

Free Database ERD Creator

I am looking for a free option that I can use to design my databases. The following features are a must: Needs to be free or under $100 Able to generate SQL statements to generate the completed ...
0
votes
0answers
32 views

Comparing large datasets (up to 100m)

I am working on a data comparison tool in C#. It takes data from two systems, stores them in a local cache (with a unique primary key, some XML and a record number) and run some checks afterwards. ...
0
votes
0answers
29 views

need sqlite data content compare

I need a free sqlite tool for comparing two sqlite database table values. I've used SQLiteSync, but it's not good at it. any more better graphical tool?
1
vote
0answers
208 views

What is the best ORM for android? [closed]

Can you advise me a good modern ORM for SQLite on android? Of course, the more lightweighted and fast it is, the better. It would be great, if it is JPA-styled. Thank you!
0
votes
0answers
169 views

Alternative for HBase to store and query small files

I'm using Hadoop on my system to store my files (each file is very large: ~4GB). I also have small sqlite3 db files (~50MB) and I would like to store them (somewhere - I don't have shared storage) and ...
5
votes
2answers
3k views

Curses-based SQLite console browser

There are programs like sqlitebrowser that let you view databases as tables and edit them in a convenient way. But I can't encounter a similar program for linux console. I have a server that I can ...
0
votes
1answer
31 views

Best solution for open and edit .db files? [closed]

I need a simple software for open and edit .db files
1
vote
0answers
273 views

C++ wrapper for sqlite3, alternative to sqlite3pp

Now I use sqlite3pp, but is there a good alternative of it, which can: simply return number of rows in query result by call to one function, At now I must do something like this for simply get rows ...
1
vote
0answers
284 views

Tool that can create c++ structures from the tables of an SQLite database?

Given an SQLite .sql database file. Is there a tool that can automatically create C++ structures from its tables? For example, an sqlite schema in this form: CREATE TABLE [ACCOUNT] ( [ID] ...
1
vote
0answers
543 views

Pure-managed C# SQLite client library

I am looking for a client-side library to read/write to an SQLite3 database. Requirements: Pure managed C#, does not use any .dll or .so No separate 32bit and 64 bit binaries Supports SELECT, UPDATE,...
4
votes
1answer
73 views

Database technology recomendation for simulator

Alright so I am developing a simulation application and I need to know what database is advisable (Or the pro's con's of some options). tl;dr: C# application Only the application will be using it ...
3
votes
4answers
441 views

SQLite viewer for Mac OS X

I need to inspect an SQLite file on Mac. What viewer should I use? Requirements: Free, ideally open source Browse schema, data. Run queries Bonus if updated in near real time when the file is ...
1
vote
0answers
39 views

SQLite browser that reloads data on-the-fly

There are many SQLite browsers out there, but for all of those I have tried, you don't see when data is modified by an external program. To make sure you are watching the most recent data, you have to ...
3
votes
0answers
55 views

Non-stock Android SQLite library?

For some reason and others, I want to avoid Android's official SQLite implementation. Requirements: SQLite format Has SELECT, INSERT, UPDATE, DELETE The most implemented operations the better Basic ...
13
votes
1answer
552 views

Which database should I use? Locally stored, about 20 writes per minute, 1 read per minute, will grow 15MB each day

I'm building a self-tracking system to log e.g. my phone's accelerometer, the keys I type, my mouse activity, and so on. So which database should I use? My research so far suggests SQLite3, because ...
8
votes
1answer
19k views

Free program to generate ER diagram for exisiting SQLite Database

I have a SQLite database that I have created. In order to document it, I hope to create an ER diagram. Is there a free tool out there that will import the database and spit out an er diagram? Any ...
2
votes
3answers
126 views

RDBMS for newbies in IT

I need to teach my two interns how to use RDBMSes in general and "standard" SQL during their free time, using the outdated windows notebooks we have laying around. They come from math courses and have ...
12
votes
2answers
4k views

SQLite GUI editor

I'm working with SQLite. The database is used by a software. For some purposes I have to see the database and edit it. Can anyone recommend me software for doing this? Requirements: Show database/...