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
Gabor Galantai
Courses Plus Student 17,247 PointsIs Sqlite adequate for a larger project?
I wonder if Sqlite could be sufficient for a project that will grow a massive database. I'm not familiar with Sqlite and I don't know what is the benefit of it compared to MySQL. Any thoughts?
1 Answer
tobiaskrause
9,160 PointsDepends...what is your idea of an "massive database"? I would not recommend it. Sqlite is ok for mobile application and small applications but I would avoid it for larger projects. Go for something like MySQL, SQL Server (Windows) or Postgre. SQLite can be really slow in big projects. It depends on what are your wanting to do and what a "large project" in your view is. This SoF Thread might also help u: http://stackoverflow.com/questions/784173/what-are-the-performance-characteristics-of-sqlite-with-very-large-database-file Is there a reason for using SQLite? Is it required for your type of project?
Gabor Galantai
Courses Plus Student 17,247 PointsGabor Galantai
Courses Plus Student 17,247 PointsThe reason for Sqlite would be that that is what Kenneth discusses in the course with Peewee. I don't see any course with a way to use SQL with Python. A massive database would mean thousands of users, thousands of items with dozens of attributes each, and a lot of different ways to connect them to each other.
Gabor Galantai
Courses Plus Student 17,247 PointsGabor Galantai
Courses Plus Student 17,247 PointsDo you know of any MySQL libraries that support Python 3.5? The ones I've tried are only up to Python 2.7 (MySQLdb and MySQL-python).