sqlite:How to use in memory

sqlite in-memory-database
junaidp picture junaidp · Jan 12, 2012 · Viewed 9.2k times · Source

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.getConnection("jdbc:sqlite:mydb.db");

         Statement stat = con.createStatement(); 

        stat.executeUpdate("drop table if exists weights");

        //creating table
       stat.executeUpdate("create table weights(id integer,"
       + "firstName varchar(30)," + "age INT," + "sex varchar(15),"
       + "weight INT," + "height INT,"
       + "idealweight INT, primary key (id));");

Now where should i put this statement[ ":memory:"] to store my this data in memory and the data should keep saved until i delete it .

Thanks

Answer

Paul Rigor picture Paul Rigor · Feb 7, 2012

Try:

con = DriverManager.getConnection("jdbc:sqlite::memory:");

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
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
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More