Hi!
So I am very new to this and I am trying to figure out what type of computer I need or if this Chromebook will do for now. I have the SQL extension which I believe is all that’s available for CB. On another site it said to download dbeaver and a terminal and connect them to SQL? I am having a tough time doing this! If this is possible, does anyone have a link to some instructions on how (I tried to find some)? Is the SQL extension all I really need (Im not totally sure what the dbeaver is for)? Or is Chromebook just not the right thing for this and I need to go ahead and order a Thinkpad or something? Thanks so much!
Hi. Dbeaver is a GUI (graphical user interface) client to connect to any type of database that it has drivers for (the DBMS it supports include sqlite, postgres, MS SQL Server, mysql, and many more).
It often connects through port connection but if you wanted to keep it simple, you can connect to a sqlite database by providing the filepath of where your sqlite database is.
SQL itself is just a language standard that (mostly) relational databases implement to query their data (for example, syntax on two DBMS’s is going to vary slightly, but early on the distinctions are super subtle).
So to summarize, a simple setup would involve:
- choose your database management system (I recommend sqlite for its simplicity to begin with). You would need to install it first. (https://www.youtube.com/watch?v=DjZclqD-qHM)
- Via the command line you can create a test database with a command like
sqlite3 test.db
- If you have dbeaver you can choose to connect to your sqlite database by finding the path for it. But you can also just use the command-line, or use it programmatically (via python or any programming language). It’s up to you.
- Once connected, you can write all the sql you want to query and perform actions on the database.
2 Likes