Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
0answers
5 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
15 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
49 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
2answers
67 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
9 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
30 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
27 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
184 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
142 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
2k 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
235 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
239 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
439 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
68 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 ...
4
votes
4answers
390 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
36 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
547 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
17k 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
125 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
3k 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/...