How to browse an in-memory SQLite database with the command line tool sqlite3

sqlite in-memory-database
ezequiel-garzon picture ezequiel-garzon · Jul 1, 2011 · Viewed 8.5k times · Source

Is there a way to load an entire SQLite database into memory for faster results, using the sqlite3 CLI tool? Thanks!

Answer

user610650 picture user610650 · Jul 1, 2011

I'm not sure of what you are trying to accomplish here, but I have two ideas to propose:

1- Copy everything from your database to some attached in memory database. This link will tell you how to attach an in memory database: http://www.sqlite.org/lang_attach.html

2- Increase your cache size, keep transactions in memory, and keep the "temp store" in memory: http://www.sqlite.org/pragma.html#pragma_cache_size http://www.sqlite.org/pragma.html#pragma_journal_mode http://www.sqlite.org/pragma.html#pragma_temp_store

Related questions

Create SQLite database in memory

Trying to learn a bit about PDO and is going through this tutorial. It has the following snippet of code: <?php try { $db = new PDO('sqlite::memory'); echo "SQLite created in memory."; } catch(PDOException $e) { echo $e->getMessage(); } …

Read More
sqlite:How to use in memory

I am trying to store my data in memory here is what i have right now //sq lite driver Class.forName("org.sqlite.JDBC"); //database path, if it's new data base it will be created in project folder con = DriverManager.…

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More