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
1
vote
0answers
6 views

How to visualize / debug SQLite database? (python application)

What would be the best tool to debug / visualize & dig in to the a SQLite database in application development phase. The tool should be free or cheap (max. 50 USD). What kind of development ...
0
votes
0answers
7 views

Database Management System for saving arround 3000 objects and variables in a single offline OS, using python3?

Is a single script for business management. It saves objects and variables in a database,modify objects and variables from the database, sees and remove them. I estimate it will make arround the ...
3
votes
1answer
41 views

C# What is the best free and reliable database solution for storing configuration?

I am about to choose a database solution for my c# project: to store simple configuration at first, bools, ints, paths etc. to store lots of small text blocks in the future probably to store small ...
0
votes
0answers
19 views

Database for student and progress attendance web application

In the project I want to do I will be requiring a database for the following: Store and access login details for Admin, Managers and Faculty. Store students and their information, i.e. Phone numbers, ...
1
vote
2answers
31 views

General-purpose database GUI software for cataloging

I recall coming across an open-source, user-oriented (local) database software which allows generic use of a database engine (SQLite if I recall correctly), it would be perticularly nice for ...
0
votes
0answers
10 views

Concise Scala ORM library with SQLite support

I am looking for something like Squeryl: works well with Scala (e.g. collections, Option support, Scala-ish API) type-safe (library must not allow type-unsafe columns access, e.g. writing a string ...
0
votes
0answers
16 views

looking for a (free) web hosting service that support flask, sqlite, and socketio

I built a simple web app with flask, socketio, and sqlite. Can anyone recommend a web hosting service that supports all three? I tried Pythonanywhere but they do not support websockets. I also ...
1
vote
0answers
12 views

Web server that runs on Android and comes with SQLite

I would like the software to run on Android be a web server be able to execute PHP pages come with SQLite installed so that I can just load the files and sqlite db into htdocs allow the user of ...
1
vote
0answers
13 views

Comparison tool for SQLLite that generates scripts

Can anyone suggest me software that compares SQLite tables/databases, and creates a script to update one to the other - like SQL Delta does for other database types?
1
vote
0answers
27 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 ...
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 ...
1
vote
0answers
56 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 ...
1
vote
1answer
38 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 ...
1
vote
1answer
57 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
1answer
38 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
45 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 ...
1
vote
0answers
17 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
44 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 ...
3
votes
2answers
52 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
1k 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
26 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
35 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. ...
2
votes
1answer
77 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?
0
votes
0answers
184 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 ...
6
votes
2answers
4k 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
285 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
327 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
683 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
77 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
496 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
43 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
56 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
554 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 ...
9
votes
1answer
23k 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
128 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/...