I have that same problem, tried looking for a while I couldnt figure out how to fix that. However, I did figure how to make a new database. Just click the folder icon, and in the it brings up the file system. Name the database in the filename box. Then just click enter. If you just hit enter, it be created as a file, and if you add .db it will make it a sqlite file. Dont know which one you will need. Not yet.
database on the left pane as you have it in your video minute 01:49. How can I make it appear or how can I add the Chinook database in the left pane?. By the way, I dont have a left pane because I beleive I have not fully connected
My Connect & disconnect Icons are greyed out. If I click on the "Database" Icon (3rd from left to right), select 1st radio button "Select and existingdb file" or select the 2nd radio button,create a new database
@@NetworkingNewbies that would be great, thank you. I actually installed both, liked both, kept both. Each has a small memory footprint so I don't mind. If I have to choose one though, I would choose SQLite Studio, for 2 reasons: 1. The latest version of it is more recent than that of DB Browser for SQLite, which was released in 2021 or something. 2. I like the SQLite Studio interface more, and it gives me more (configurable) keyboard shortcuts unlike DB. If you do make a video, maybe this information could help. Thanks again.
I have downloaded it 3 times to C:\Program Files\SQLiteStudio\chinook.db and the vip file too. Nothing, it keeps teelling now that "could not open database: unable to open database file". I made the folder NOT read-only. I just can't connect to the chinook.db. Any other idea? And Thanks.
This is helpful video, many thanks...
Glad it was helpful!
Hello. The green "+" button does not appear in order for me to create the database. Can you help me? Thank you
Is it working from File menu?
@@NetworkingNewbies no, everything is just like the video, except for the green “+” button :(
same for me
@@nicas901 I still haven’t found out how to fix this :(
I have that same problem, tried looking for a while I couldnt figure out how to fix that. However, I did figure how to make a new database. Just click the folder icon, and in the it brings up the file system. Name the database in the filename box. Then just click enter. If you just hit enter, it be created as a file, and if you add .db it will make it a sqlite file. Dont know which one you will need. Not yet.
database on the left pane as you have it in your
video minute 01:49. How can I make it appear or how can I
add the Chinook database in the left pane?. By the way, I dont
have a left pane because I beleive I have not fully connected
I think, simply download the Chinook database, launch your SQLite and open the database
My Connect & disconnect Icons are greyed out. If I click on the "Database" Icon (3rd from left to right), select 1st radio button
"Select and existingdb file" or select the 2nd radio button,create a new database
Sir, please how can I add primary key on two different columns. It only allows it on one.
Here is some discussion, it may be helpful.
stackoverflow.com/questions/734689/sqlite-primary-key-on-multiple-columns
Could you do a "DB Browser vs SQLite Studio" video, or point me to some such video/article which compares the two tools?
I would simply google for its difference; I will try to make a video on it. Thanks for your comment
@@NetworkingNewbies that would be great, thank you. I actually installed both, liked both, kept both. Each has a small memory footprint so I don't mind. If I have to choose one though, I would choose SQLite Studio, for 2 reasons:
1. The latest version of it is more recent than that of DB Browser for SQLite, which was released in 2021 or something.
2. I like the SQLite Studio interface more, and it gives me more (configurable) keyboard shortcuts unlike DB.
If you do make a video, maybe this information could help. Thanks again.
to the database Chinook. Can you spare some knowledge please.
Thanks.
DH
Excellent Sir
Many many thanks Roshan
Easy to follow
Thank you for your words.
I have downloaded it 3 times to C:\Program Files\SQLiteStudio\chinook.db and the vip file too. Nothing, it keeps teelling now that "could not open database: unable to open database file". I made the folder NOT read-only. I just can't connect to the chinook.db. Any other idea? And Thanks.
perfect!
Thanks!
How can I put a password to the database?
stackoverflow.com/questions/1381264/password-protect-a-sqlite-db-is-it-possible
thanks
Thank you too