Hot answers tagged

12

You could take a look at SQLite Expert. This application has a large number of features and is available in both a free and a paid version (which has more features like data importing from various file formats, exporting to various file formats, more drag and drop database manipulation, automatic query generation and some repair tools). You can take a look ...


10

One tool is Schema Crawler (along with a graphics add-on) which is open source. It is java based, so should run on windows (or almost any other OS). Schema Crawler Official Page Schema Crawler Github Page


9

I would suggest you keep using SQLite3: most applications that need an embedded database for local/client storage use it, and 20 writes per minutes doesn't sound to me like a lot, all the more so as from what you describe the writes are probably just inserts, which you can easily batch provided that you use SQLite 3.7.11 or up: INSERT INTO 'tablename' ...


5

The viewing part can be achieved using SchemaCrawler; amongst its features, it generates database diagrams. It supports various database formats, including SQLite. Disclaimer: I haven't used it (yet). Here is an example image, found on the roman10 website.


5

I'm using Sqliteman to work with my SQLite databases. One reason for my selection was I can invoke it from the command-line while passing the database file to work with. Requested features: Show database/tables: Sure. Edit database/tables: Yes. Show overview about database: in a tree-structure, so you can dive in where you like. Execute SQL statements: ...


3

You can use the Firefox addon SQLite Manager: Free and open source (and still maintained) Browse schema, data. Run queries


3

I would use MySQL as RDBMS and MySQL Workbench as IDE: free works on Windows/Linux/Mac straightforward to install (to make it simpler you could even install MySQL on some server, and just have your interns connect to it) syntax highlighting auto completion SQL documentation on the side in addition to the SQL Editor, you can design visually database (usual ...


3

Check the sqlectron. It comes both in GUI and in Term version. Also there is sqlcrush.


2

Datagrip by jetbrains supports SQLite. I've used it for other (MySQL, Oracle) types of databases, and it's been good. However, I haven't used it for SQLite.


2

I haven't used this, just DuckDucklGo'ed it, but what about KS DB Merge Tools for SQLite is an easy to use diff & merge tool for SQLite databases. This tool allows to compare and import/export database objects and data between two database files. It can run in two modes - basic free version and paid Pro mode that provides extended functionality and ...


2

The SQLite package includes the sqlite3 command-line client, which appears to offer equivalent functionality to mysql (MySQL), psql (PostgreSQL) or sqlplus (Oracle). I don't see that it supports network connection, but that is really outside the intended use-case for SQLite and is unnecessary if you have SSH access to the server.


2

You can use Database Browser: free Microsoft Windows portable version Works directly with Oracle, MS Sql Server, ODBC, MySql, OleDB, BDE, PostgreSQL, SQLite, MS Sql Server Compact, Interbase and Firebird Execution history SQL Builder


2

Am using PostgreSQL(open source database) on my VB.NET Desktop Application. I think you need an embedded database to use within the application, Microsoft SQL Server Compact if you don't want to install anything on the user side Firebird Embedded Firebird Embedded is a relational database engine. It's an open source fork of InterBase, is ACID ...


2

You might wish to take a look at Sqliteman (see my answer here for details and screenshots). According to its download page at Sourceforge, a MacOS version is "in progress", and you can use 1.3.x series, it's working (quote from there). How does it meet your requirements: Free, ideally open source: It's free alright, and its code is available at Github ...


2

I'd give them sqlite - it's perfect for beginning situations like this: The DB is in a single file, making it really easy to start using, and really easy to reset if you screw it up. The DB engine is a single executable - just type sqlite3 <db file name> to get started. Imports from CSV are pretty easy. Supports the usual set of SQL operations. The ...


2

I would recommend phpMyAdmin - works with MySQL (also MarioDB & Drizzle though I can't comment on the those). It does require PHP and MySQL/MarioDB/Drizzle - WAMP has it pre-setup through the installer if you want a simple Windows installation solution. With phpMyAdmin you have full console abilities and also a very very easy to play with learn from/use ...


1

There is alway an "it depends" aspect to these type of questions, however let's give it a try. I will give 3 scenario's which you have determine which best describes your situation. Proof of concept / v1 If you just create a simple chatbot, without expectation of large traffic you might as well use any DBMS of choice. SQLite might be perfect for a proof of ...


1

Several open source webapps (namely Alfresco and Liferay) distribute a small amount of data with the webapp, to make it easy to get started with. A beginner can just run the start script, and the webapp is up and running already with sample data. Here is how they do: Write a standard SQL script that creates the data. Write some code that creates an empty ...


1

Dbeaver is also a great tool to work with databases including SQLite and can visualize the relations between tables


1

You can use DB Browser for SQLite: Free and open source (and still maintained) Browse schema, data. Run queries


Only top voted, non community-wiki answers of a minimum length are eligible