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
Marcus Tisäter
4,886 PointsMySQL 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
529 PointsHello 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
Abilon V
529 PointsYeah, you use SQL for both of them.
Marcus Tisäter
4,886 Pointsokay thank you very much Abilon! Great answers :)
Abilon V
529 PointsGlad to help.
Marcus Tisäter
4,886 PointsMarcus Tisäter
4,886 PointsThank you for the response! So the language in MySQL I'm currently using is the same as in SQLite3?
Victor Miclovich
9,108 PointsVictor Miclovich
9,108 PointsSQL is pretty much the language that is used in database management systems like MySQL, SQLITE3, Postgresql, etc. @Marcus, your answer is right.