Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.Start your free trial
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:
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.