There's no way to delete actual database file using SQLiteStudio. You will be asked for confirmation, before the database is actually removed from the list.ĭeleting database from the list does not delete database file! It only removes it from the list of databases in SQLiteStudio. right-click on it and pick 'Remove database',.To delete database from the list, select the database and either: If you right-click on the database and pick 'Create group', then the clicked database will be automatically moved into the group after the group was created. Then you can drag & drop databases into that group: To create a group, right-click on the databases group and pick 'Grouping' → 'Create group'. It helps maintaining big number of databases on the list. You can create virtual 'directories' where you can group databases. You can move databases up and down with mouse 'drag & drop'. If you want to convert one SQLite version into another, use database conversion dialog. When editing database details it's not possible to change it's type (SQLite2, SQLite3, or any other), because this is allowed only when creating new datababase. It will not copy nor move the old database file to new location. When changing database file path, it will mean that under the same name you will access the new database file. The database name is just symbolic name, an alias used by SQLiteStudio to present database in the list. The standard database dialog will appear.Ĭhanging database's name is allowed as far, as the new name is unique across all databases being currently on the list. Just right-click on it and pick 'Edit database' from context menu. You can edit database details at any moment. Managing database list Editing database details You can double-click on it to open it:Īlternatively you can use drag&drop mechanism: drag database file from your file manager and drop it onto the database list, then confirm the database dialog. Then click 'Save' and 'Ok' in next dialog and your database will be added to the list. In the file browsing dialog pick an existing database file: Then you click (just like before) on browse button: Repeat steps from above, util you see database dialog: Using existing databaseĪdding an existing database to the list is very similar to creating new database. If this option is not checked, then the databases will disappear from the list after SQLiteStudio was restarted. This means that when you close SQLiteStudio and start it again, the database will remain on the list. When this option is checked, then the database is added permanently to SQLiteStudio. You may have noticed the 'Permanent' check in the database dialog: You will see it in the databases list on the left: You can now press 'Ok' to create the database. If there was any problem, the red icon will appear. If everything is okay, than you will see green icon next to it: You can press 'Test connection' to make sure that your database file can be created in specified localisation (in regards of directory permissions, free space, etc). You can pick any name you want, it just has be unique in context of databases already added to SQLiteStudio. You can change the name to whatever you want (in which case you have to disable the checkbox on the right hand side), or just leave it as it is. Now the database dialog has file name and database name filled in. In this dialog go to directory where you want to create your database and type in the file name for your database (on the image above it's 'test.db'). You will see filesystem browsing dialog (this may look different on various operating systems):

Right-click on database list and pick entry from context menu:.

You can create new database in three ways:

Installing binary package Installing from source code Installation and running Supported platforms Platform I'm using Fcitx input method, but it doesn't work in SQLiteStudio.I have saved binary data into SQLite 2 database, but now it's damaged, empty or truncated!.Moving and copying objects between databases.

Mode csv sqlite studio