![]() You can connect to an in-memory database using SQLite3 Editor: Connect to In-Memory Database in the command palette. You can check the available options by using import -help or export -help. These import and export features rely on a helper program bundled with this extension. Importing and Exporting Data in CSV, JSON, or SQLīy clicking the "Other Tools." button, you can access various features, including CSV, JSON, and SQL imports and exports. To open other files, right-click the file in the explorer and select Open with… then SQLite3 Editor. To rename a table, right-click the table name in the SELECT statement, and then select "Rename Table". You can access this feature by either clicking on the SQL statement at the bottom of the editor, or by right-clicking the table name in the SELECT statement, and then selecting "DROP TABLE". ![]() You can access this feature by either clicking the SQL statement at the bottom of the editor, right-clicking the table name in the SELECT statement, or clicking "Schema" then "Index > + Add". To create a complex table, such as ones with GENERATED columns or COLLATE clauses, use the query editor. The tables that can be created by this feature are limited to simpler ones. You can access this feature by clicking on the statement at the bottom of the editor, then selecting "CREATE TABLE". Please ensure you check the generated query and/or create a backup before using this feature, especially if you're working with a critical database. We've tested this feature extensively, but we won't take any responsibility for possible data loss. You can change the order of table columns by dragging the table header. You can change the type affinity and the constraints of a column with this feature.Įditing Table Schema - Changing Column Order Conversely, when you hover your cursor over the dotted text in the columns, it highlights the associated indexes in the "Schema" pane.Įditing Table Schema - Changing Column Definition When you hover your cursor over an index, it highlights the corresponding columns. For example, if you have CREATE TABLE table1(a, b, c) CREATE INDEX index1 ON table1 (c, a), then the coloring of the boxes would be blue, gray, blue, and the numbers would be 2, -, 1. They represent which column the index applies to, with numbers indicating the order. The "Index" section displays an array of blue and gray boxes for each index. This feature supports both tables and views. This will open a panel displaying the table schema, indexes, and triggers. To view the schema of the active table, click on the "Schema" button located at the top of the editor. The extension will automatically initialize the file as a database if it is empty and has one of the supported extensions.Įditing Table Schema - Checking Table Schema To create a database file, simply create a file with a supported file extension, such as. Feel free to explore each feature as per your interest. The arrangement of the features listed in this section does not reflect any particular order. The editor supports context-aware auto-completion, syntax highlighting, hover documentation, signature help, and syntax validation. You can run arbitrary queries in the query editor. In addition to tables, you can also edit a view's name and definition. You can edit table schemas as shown in the video. In addition to simple UPDATEs and INSERTs shown in the recording above, you can bulk-set a value to a selection, delete multiple rows by dragging over row numbers, set a value to a cell in a foreign key column using a dropdown, edit a table via a view, etc. It also comes with some fancy features, such as conditional formatting, image BLOBs preview, foreign key hover, etc. ![]() ![]() In addition, the data is automatically reloaded when the table is modified by another process. At the same time, only the data that is currently visible on the screen is retrieved from the database, so it loads fast even on large databases. This extension uses scrolling for browsing records, which should be more intuitive than pagination. Here are some videos of the main features: □ Viewing Database Contents Most of these features are not present in other VSCode extensions for SQLite, such as alexcvzz/SQLite and SQLite Viewer. This extension can be used to □ view and edit database contents, □ view and edit table schema, and □ execute SQL queries. This extension allows you to edit SQLite 3 files without having to write SQL queries.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |