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äter4,886 Points
MySQL or SQLite3
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?
Abilon V529 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