Hello, I'm occasionally developing plugins for clients with MySQL compatibility. I used to test these on remote SQL servers, but i 'd like to test those localhost. Then I asked around and some of my friends told me they use SQLLite because it's easier to configure. However I dunno how SQLLite works and how I could use it in my plugins. Could someone explain to me how I could use it in my plugins and how I connect with them? A tutorial is welcome too! Regards, DeamonZ
Google. https://forums.bukkit.org/threads/tutorial-sqlite-setup.92901/ https://forums.bukkit.org/threads/mysql-sqlite-database-storage.80992/
One of them is a thread about someone asking how to use sql in common and the other one requires to change SQLite own files what i think is a little bit weird
DeamonZ The main change is that the DriverManager uses the following as first parameter Code: jdbc:sqlite:<file path> The rest is pretty much the same (aside a few subtle differences between SQLite and MySQL)