Welcome to the Treehouse Community
Looking to learn something new?
How can i run sqlite locally ? with xampp or wampp ?
I using xampp and Netbeans IDE as my text editor. I would really like to know how i can use sqlite with xamp. Currently if i try the console with phpmyadmin (localhost) i get a syntax error. Any help is appreciated !
I want to say that you don't need anything installed for SQLite - atleast not inside xampp..
SQLite is basically a database in a file. Php does the heavy lifting of managing that database and it's php where you need to have sqlite installed. This should come packaged with xampp by default (if it's not being rubbish).
You can check if it's installed by running this at the very top of a script:
<?php phpinfo(); exit;
Scroll down the list or (cmd + f or ctrl + f) for sqlite. Generally speaking, if a plugin or software has made it to the phpinfo() list, it's installed okay. Source
If you want an equivalent gui like PHPMyAdmin, I've used this in the past. There are lot's available, some paid some free, just search 'sqlite gui' or similar.
Hope this helps!
Tomasz Budny14,588 Points
As far as I know XAMPP comes only with MySQL. Also phpMyAdmin supports only MySQL. So if you want to use SQLite you should install it separately and use a different database administration client or just its command line.
Thanks a lot guys ! I will try to make this work.