Make sure to not show "NULL" for empty but non-NULL values in the Edit dialog ( #2204).Add status message when opening a file from the recent file list ( 4dfe4f7).Fix initial table view when using the -t / -table command line option ( #2113).Fix loading of project files with empty filter values ( #2288).New predefined settings for simplified window layout ( #2307).Add more options for setting font sizes ( #2306).Net DateTime.Ticks to list of supported display formats ( #2378) Completely reworked interface for accessing DBHub.io.The changes in this over the 3.12.0 release include: Enhancements There aren't any "super critical must upgrade" bugs fixed, so updating isn't urgent. This is the first bug fix release for our 3.12.x series. Updated the "public" certificate, used for communicating with DBHub.io anonymously ( d85953c291b5f0bb467e2c12dfa4438f997d4f28).Updated the included SQLite and SQLCipher libraries to their latest release (SQLite 3.35.5, SQLCipher 4.4.3).Corrected a typo in the French translation ( 3bbd4ee271f98301476143749f7bf4abed052efe).Fix saving the list of extensions in the Preferences dialog ( bd0e1feead6bb446f8a703338aa9893bf281e5b4).The changes in this over the 3.12.1 release include: With your own client certificate, this upgrade won't really do much either. You don't need to upgrade unless you're using DBHub.io anonymously. This is a minor maintenance release, primarily to update the internal certificates forĪnonymous communication with the DBHub.io servers. In closing, SQLiteStudio comes in handy for users who need to manage and alter SQLite databases by inserting new tables, views, triggers and indexes.Update - We've added a native arm64 (eg M1/M2/etc) macOS download below, for people using Apple Silicon. In this manner, you can view specific information from each table, or gather data from multiple tables using INNER JOIN statements.Īlso, you can add a new trigger for the selected database by specifying its name, choosing its action, then writing the proper code. In case you want to insert a new table in the existing database, you need to choose the proper options, then specify the table name, set table constraints and add as many columns as you want.īy using the ‘SQL query editor’ option, located in the Tools menu, you are able to manually create your SQL scripts and execute them. The Tables menu allows you to erase data, as well as create a new table and populate it by specifying the number of rows you want to add. After that, you can view all the existing data and manipulate it the way you want. Additionally, you can import schema from other databases or from various file formats such as CSV and dBase. The hierarchical tree view allows you to select any table, trigger, procedure or statement and view the data in the main window.įrom the ‘Databases’ menu you are able to open a new *.db, *.sdb, *.sqlite or *.db2 file and connect to it using the right-click menu. The left panel displays all of the available databases along with their data. Since it does not require you to install it, all you have to do is to double-click the installer and start managing your SQLite databases effortlessly. The application comes with an intuitive interface and well-organized menus. SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |