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
Ceil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 PointsHow to make a database?
Hi! Good day. I was just wondering, since I already have a skill on SQL, I still don't know how to make a database.
I am thinking of like maybe make a website that people can register to, get passwords, stuff like that. Thank you in advance!
2 Answers
Jonathan Grieve
Treehouse Moderator 91,253 PointsHi there Ceil...
The simplest way of making a database is in Sqlite. There's a course for getting you started in SQLite3 here on Treehouse via the Command Line
Here you'll be able to use all the power that SQLite3 has to create database tables, add data to them, make them relate to each other with foreign keys and save these as .db files.
The other way I manage databases is with the phpyMyAdmin feature in your local host and your web server when I want to manage WordPress installations. These work with .sql files.
This should help you get started. :)
Ari Misha
19,323 PointsHiya there! I want to add something to Jonathan Grieve's well put answer. There are seeding libraries out there where you can seed the Database with fake data. At least, that's what I do. But if you'd like to know how to program a Database itself, you're gonna have to dive deep in C programming language. A tad bit mixture of Bash Scripting with C language and you can actually program your own Database.
I hope it helped!
~ Ari ~
Ceil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 PointsCeil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 PointsHi Jonathan! Wow, I'm blown away right now cause the treehouse community always seem to have answers on my questions. You guys really are the best! Thank you so much for this! I'm sure I'm not the only one you're helping! :)
Jonathan Grieve
Treehouse Moderator 91,253 PointsJonathan Grieve
Treehouse Moderator 91,253 PointsNo worries, it's why we're all here! :)
Ceil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 PointsCeil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 PointsHello Jonathan Grieve ! Hope you're not busy. I've taken the course you gave me and learned how to create my own database, but I feel like I'm lost in the treehouse courses because it is so many.. I can't figure out what courses to take first, etc.
I searched online for how to connect a database to my website, how to process it, how to secure it but what I always find is MySQL and PHP working together. Can I do this using just JavaScript and not PHP? I looked at PHP though, and finished the PHP Basics course, but it seems like a very long way before I get to the user authentication course, because it says it is advanced.. and I'm running out of time for my quota.
If yes, do you happen to know what course it is or some prerequisites before taking it? Would really appreciate it. My goal is to be a full stack developer and this is the only thing stopping from doing it. Learning how to connectmy website to a database, learning how to secure it, and authentication for users.
Thank you!
Ceil
Jonathan Grieve
Treehouse Moderator 91,253 PointsJonathan Grieve
Treehouse Moderator 91,253 PointsHi there,
The best thing I can do is advise you on curricula here on Treehouse. The best thing to do if you're lost is to try and narrow your pathway down. You seem to want to take the JavaScript path to authentication which is fine. :-) although in my opinion, the best way to learn about databases and authentication is on Treehouse is via PHP.
That said, there may be good news for you. There is a course coming later this month called Using SQL Databases with node.js This might just be the course you're looking for getting started authenticating websites with JavaScript.
Until then have a look at my filtered search here which looks at a different kind of database called Mongo with the JavaScript Express library.
But really, the main stuff about Databases and authentication is in PHP and SQlite at the moment.
You will absolutey motor through the PHP Basics courses, so if you're continuing with PHP, do that until you're more comfortable with the language, then I would advise you to go through the Intermediate PHP Track. At least then you'll be able to filter out the "noise" of the wealth of courses on Treehouse and follow a defined path. :)
Hope this helps :)
Ceil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 PointsCeil-Ian Maralit
Front End Web Development Techdegree Graduate 19,434 PointsOh, that explains why I only see PHP and MySQL being mentioned on the internet when I talk about databases.
I also enjoyed learning PHP today, it seems great. Thank you so much for helping, I would take the course you showed me but I would also take your advice after it, I would learn PHP more.
I started the track Beginning PHP, I think I should continue with that too and proceed to the intermediate then look for the course Iām looking at here at treehouse.
Again, thank you so much for this! :)