Re: [sqlite] Multiple Independent Database Instances

Have you tried utilizing a RAMdisk in your pipeline? Before adding a database to the queue of work move/copy the file to somewhere in /tmp/ then point the worker thread at it. The accesses should be much faster. Hope you’re making progress. -Tommy On Apr 22, 2019, at 6:44 PM, Keith Medcalf

[sqlite] Best way to ALTER COLUMN ADD multiple tables if the columns don't already exist

Hi all, I'm still working on this journal app and ran across a need to update our table schema, I want my entries to be _essentially_ immutable. My solution to this problem is a linked list type dependency where each entry has a parent and a child, which corresponds to an entry's past and

Re: [sqlite] SQLite error while fetching the data from a table

Hi All, Hi Ananta Need quick help to resolve one issue i am getting now. I am a new user of SQLite. my code: connection = DriverManager.getConnection("jdbc:sqlite:C:\\sqllite\\sqlite-tools-win32-x86-328\\Stories.db"); Statement st = connection.createStatement(); ResultSet b =

Re: [sqlite] JDBC stmnt.executeQuery returns empty ResultSet

On 19/04/21 08:25, jordydew...@gmail.com wrote: > Hi there My Easter is great, what about yours? Jordy, Mine is going well too, thanks.?n > I am not pretty sure if that is a thing and it has been a while since I did > Java, but I have the feeling that you actually should move the statement from >

[sqlite] JDBC stmnt.executeQuery returns empty ResultSet

All, Hope you Easter is going well. I am working on a simple journaling application which I'm choosing to write in Java. Before I get into this description if this is not the place to ask for help with the sqlite wrapper (https://bitbucket.org/xerial/sqlite-jdbc/downloads/) please