With the data tab all the entries can be edited easily.
All the tables which are available are displayed in the left side of the panel so that you ca easily restructure the fields, foreign keys, triggers and indexes without losing the information. The main interface of this application will let you view all of the connected databases and then execute your own SQL scripts by using SQL Builder tab. SQLite Expert Professional Edition is a simple and easy to use application and can be used by both the beginners and advanced users alike. Now that opens some possibilities.It has got a very intuitive interface and the database management and maintenance has been integrated in it. PS turns out AutoIt has SQLite implemented and ready to be used. However I am not qualified to make judgment if pro version worth its money. It is quite good for a novice (like me) and I am going to stick with it for now. However free version has some serious limitations that may easily be deal killer. SQLite Expert works great for initial database design. I can understand cutting more complex stuff but lack of even basic dump of database into SQL statements is more than annoying.
editing triggers and constraints added since version 2.1.8.import or export of data, limited - via clipboard.Some of them are for advanced features but I was unpleasantly surprised to see some functions basic for native utility blocked. LimitationsĬonsidering SQLite Expert has commercial Professional version it was a given that there will be limitations. There is even decent help file on top for which I don’t look often but appreciate when exploring new tech. It has excellent interface with large buttons, fonts and fitting use of zebra tables. browse data, including filtering and support for images in binary fields.What it doesĪpp allows to do most of tasks in easy and graphical way: After some time I encountered SQLite Expert Personal which is nice graphical front-end for designing (and more) of SQLite databases. I had need to do some programming making use of SQLite and drafting database in native command line tool felt clunky. For example it is used in Firefox to store bookmarks and other stuff. SQLite is interesting database management system (sounds boring) that usually works behind the curtains as component in various software.
0 kommentar(er)
