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
Rafail Mavrogordatos
5,324 PointsHow safe is mysqlite?
How safe is to build a website on 2020 using the mysqlite to create a login system?
1 Answer
Jennifer Nordell
Treehouse TeacherHi there, Rafail Mavrogordatos! I think you mean sqlite as opposed to mysqlite. There's nothing intrinsically less secure about that database system over another. It is quite often used as an embedded database in mobile devices. For instance, if you're using an iPhone and you have an app that uses a persisted database in memory for offline usage, chances are that is built on sqlite.
The problem here isn't really security, it's more likely scalability. The reason it was used in this course, in my opinion, is because sqlite is portable. You don't need to set up a special server to have access to it and you can download it or send it to a friend just like any other file.
In most cases, if you're using PHP and definitely if you're using Laravel, the most common database system to use is MySQL. But one of the great things about PDO is that your PHP code doesn't change all that much even if you switch database systems. Mostly, it will be the initial connection to the database and setting up the PDO initially that changes.
Hope this helps!
