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.

Development Tools

Marcus Tisäter
Marcus Tisäter
4,886 Points

MySQL or SQLite3

Hello everyone,

I'm in school taking database and programming courses. We are using SQLite3 in the database course, and ruby as the programming language for the programming course.

I don't like SQLite3 that much so I looked myself into another database program called MySQL here at treehouse(btw I love the tutorials). Now I'm very new to databases so excuse me if my question is going to sound kind of wired.

Is SQLite3 and MySQL 2 different things when it comes to creating tables,schema etc..? are the two programs in the same language? Can someone walk me through what's the difference between these two?

What do you guys pref? SQLite3 or MySQL? Which of them is better for newbies?

If I choice to continue with MySQL will I have difficulties understanding the SQLite3 at school and then do the same thing at home with MySQL?

So final question, What do you guys think? Should I go for SQLite3 or MySQL?

2 Answers

Abilon V
Abilon V
529 Points

Hello Marcus. They both have the same objective, store data in a database organized as tables.

MySQL can be used for serious application in production environment, It can handle multiple users accessing the same database and different from SQLite, MySQL requires authentication.

SQLite can't be used in production environments when working with big amounts of data, since It rely on a database file, as the file gets bigger you may have some performance issues.

  • I would go with MySQL.
  • I don't think you will have issues learning both.
  • Final question: you should go with MySQL
Marcus Tisäter
Marcus Tisäter
4,886 Points

Thank you for the response! So the language in MySQL I'm currently using is the same as in SQLite3?

SQL is pretty much the language that is used in database management systems like MySQL, SQLITE3, Postgresql, etc. @Marcus, your answer is right.

Abilon V
Abilon V
529 Points

Yeah, you use SQL for both of them.

Marcus Tisäter
Marcus Tisäter
4,886 Points

okay thank you very much Abilon! Great answers :)

Abilon V
Abilon V
529 Points

Glad to help.