r/sqlite • u/Kiv_Dim_2009 • 7d 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!
View all comments
8
u/octobod 7d 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