![]() This is the portable edition of Sqlite Browser, with its main particularity being linked to the fact that there is no need to install it on your system. When you alt+shift the customer id and select "join tables" (name is just an example), a new query window opens with "select * from books as b join customer as c on b.cid = c.id where c.id = 2".If you are in search of a responsive piece of software to help you open SQLite files and collect database info, Portable Sqlite Browser might be worth your attention. You have a book with Id 1 and referenced costumer id 2. When you alt+shift the customer id and select "query record" (name is just an example), a new query window opens with "select * from customers where id = 2". For example, the option to select the referenced record, or to join with the table. Might be nice to have an ALT+SHIFT shortcut that opens a popup with advanced "quick queries". You already have reference support when clicking the ALT key.Allow for values to be added to the chart points.The terminal window makes the application crash when you input something it does not understand. Also possible are scrollbars, but it is not suggested Ideally your chart should scale to the window it is in. When charting a lot of data, the data goes off-screen and you cannot see it anymore. The reason for the above suggestion is because date-time field are seen as text and load as bar graph, whereas in my opinion datetime related data can be viewed more easily on a plot chart.You can still use the automatic choosing as "best guess" for when you first open the chart. ) so you can switch to a different chart type when you want. In the chart window you could have a drop-down with chart types to select from (plot, bar. Type of chart is chosen automatically, however, you should let the user decide this.There are a couple of issues I ran into you might want to take a look at: Export/Import data via ODBC.īeen checking out your tool, looks promising! : Finally, Windows 10 support :D and new Edit data dialog with column filters and Excel-style editing : Up to 1.3.4 - Enable/Disable indexes and triggers : Up to 1.3.2 - add whole database search, database comparison, import data via ODBC : Up to 1.3.0 - add quick preview of referenced data I have to learn how to work with threads to fix it.Ģ3-09-2020: Up to 1.2.2 - add BLOB support and tab renaming. They aren't perfect for long time queries because use one thread. Also I don't have a Vista/Win8/Win10 machine, so I'll be glad to hear any report for these OS.ġ8-08-2020: a new release with implementation techsnapp remarks.Ġ1-09-2020: Up to 1.1 - add database diagram with foreign keys and table references in views/triggers and regexp extension.Ġ9-09-2020: Up to 1.2 - add Editor tabs. Therefore I can't appreciate some UI moments in practice. ![]() At this time I don't have any project assigned with SQLite (except this). and size :DĪny comments and suggestions are welcome :)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |