Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

PHP Integrating PHP with Databases Databases and PHP Getting to Know the Project

How safe is mysqlite?

How safe is to build a website on 2020 using the mysqlite to create a login system?

1 Answer

Jennifer Nordell
Jennifer Nordell
Treehouse Teacher

Hi 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! :sparkles: