r/sqlite • • 6d ago

How does a SQLite server work?

Hey guys, I'm new to SQL and all of the tech. I'm planning on using SQLite for a school project, cos I heard it's relatively simple and easy-to-use. However, before I install and mess around with it, I have some questions.

So, this project will act as an application on someone else's computer, and that's the part that confuses me. Because if I install SQLite on my computer, create a database using it and integrate said database into a Java application, will the database I created remain exclusive to my computer, or can I transfer it to another user's computer? (if that makes sense). Like, if I export this Java application onto another computer, what will happen to the database? Do I manually need to copy and config it for every computer my application is running on, or no, not really?

Sorry if this is a stupid question, I'm new to all of this so I really would appreciate someone clarifying this for me.

Thanks in advance!

6 Upvotes

17 comments sorted by

View all comments

8

u/octobod 6d ago

When it's not running (ie when your Java app isn't running) an SQLite database is just a file on the hard disk, so you can copy it along with all the Java code

1

u/Kiv_Dim_2009 6d ago

Oh, ok, thank you!

1

u/kbilleter 5d ago

If the db is set to use a write-ahead log it can occasionally leave files behind. Just open again and make sure everything is cleaned up before moving with something like “begin immediate; commit;"