SQL is a domain-specific language designed for managing data held in a relational database management system. In our poker example, we initially used the SQLite DBMS and then migrated to PostgreSQL. For example, the file 'development.sqlite3' in the above image is a database that stores valuable information for our poker app in tables like Users, Cards, Hands, etc.Ī database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data (run queries). While this seems like a basic topic - I've noticed the terms "database" and "database management system" used interchangeably, and it's important to get these right.Ī database is an organized collection of data, generally stored and accessed electronically from a computer system. I think this topic will prove even more relevant as we continue developing more complex websites, which is why I wanted to learn more about it! While we were eventually able to migrate our sqlite3 database over to postgres and deploy to Heroku, it was not immediately clear to me why the database migration was necessary, or even what the differences were between the two Database Management Systems (DBMs)'s. Heroku, it turns out, is not compatible with SQLite. However, we had started our project using a SQLite database instead of using PostgreSQL, which ended up causing a frustrating (but not insurmountable) problem. At end of my 6th week at Flatiron School's Web Development course, my partner and I had finally completed our Caribbean Stud Poker Rails Project and were ready to deploy it to Heroku.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |