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

Python Using Databases in Python Meet Peewee Meet Peewee, Our ORM

igsm '
igsm '
10,440 Points
Posted by igsm '
igsm '
10,440 Points

What database to install?

We're going to use SQLite in this course and I'd like to use a database on my machine. Can you advice what should I do and learn next? Would learning MySQL be the same as learning SQLite? I am little bit concerned over my knowledge by now, as some things do not look straightforward to me, particularly when it touches database...

2 Answers

Kenneth Love
STAFF
Kenneth Love
Treehouse Guest Teacher
Kenneth Love
Kenneth Love
Treehouse Guest Teacher

For production, I prefer Postgres over any other database. It supports a lot of NoSQL behaviors and follows the rules of SQL databases better than SQLite or MySQL does.

That said, MySQL is fine for most people's needs and is more commonly available than Postgres is.

Jose Soto
Jose Soto
23,407 Points
Jose Soto
Jose Soto
23,407 Points

SQLite is great to practice on. MySQL is used all over though. So getting your hands dirty with MySQL is highly recommended. I started learning MySQL by installing MAMP on my laptop. I would then write scripts to interact with the database in MAMP.

The nice thing about MAMP is that it is easy to install and it has phpMyAdmin to help you interact with your database via a web portal.