# SmartData™ for SQLite (Now free) **URL:** \ **Category:** Extras\ **Created:** [June 13, 2017, 7:26pm UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200 "2017-06-13T19:26:58Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 13, 2017, 7:26pm UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/1 "2017-06-13T19:26:58Z")
{Zoclee}™ SmartData is a bespoke SQLite database editor designed to make data authoring easy and convenient. It was written from ground up in Xojo, and are released for Windows, OS X and Linux. For a more information, or to download {Zoclee}™ SmartData, you can visit the product home page at [https://www.zoclee.com/smartdata](https://www.zoclee.com/smartdata) . ---
**Author:** ![DaveS](https://forum.xojo.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@DaveS](https://forum.xojo.com/u/DaveS)\ **Post date:** [June 13, 2017, 8:59pm UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/2 "2017-06-13T20:59:20Z")
I downloaded the demo for macOS Fired it up… and immediatedly got > [@](#): > > ERROR: Database file doesn’t exit in the specified location Uh… I hadn’t even been given a chance to do anything… so what database is it seeking and what location is it expecting to find it? a few more observations… - it can’t handle large tables (million + rows)… or at least I gave up waiting - shows a table as EMPTY if it were created with the “WITHOUT ROWID” constraint - doesn’t support table VIEWS, Indexes or Triggers (or so it seems) ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 14, 2017, 6:11am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/3 "2017-06-14T06:11:39Z")
> [@335936:@Dave S](#): > > ERROR: Database file doesn’t exit in the specified location > [@335936:@Dave S](#): > > Uh… I hadn’t even been given a chance to do anything… so what database is it seeking and what location is it expecting to find it? I will look into this for you Dave. It might be that it is trying to access the license file (database) that accompanies the application, but I will have to confirm this. > [@335936:@Dave S](#): > > it can’t handle large tables (million + rows)… or at least I gave up waiting Will do some stress testing on my side to see if we can improve access to large data sets. > [@335936:@Dave S](#): > > shows a table as EMPTY if it were created with the “WITHOUT ROWID” constraint Will also look into this. > [@335936:@Dave S](#): > > doesn’t support table VIEWS, Indexes or Triggers (or so it seems) It doesn’t support these features yet, but I have created feature request tickets for this, and this should be available in a future version. Thank you for all the valuable feedback Dave. I will make sure to post more information as development progress. ---
**Author:** ![Joost\_Rongen](https://forum.xojo.com/letter_avatar_proxy/v4/letter/j/a9a28c/32.png) [@Joost\_Rongen](https://forum.xojo.com/u/Joost_Rongen)\ **Post date:** [June 14, 2017, 9:18am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/4 "2017-06-14T09:18:48Z")
@Alwyn Bester - you could consider using the [Lexing](https://forum.xojo.com/26958-lexing-plugin-version-3-5/0) control to provide syntax SQL highlighting . I use it in my query-builder project for more than a year now and it works super. ---
**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\ **Post date:** [June 14, 2017, 9:36am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/5 "2017-06-14T09:36:18Z")
This exercise seems to be pretty popular nowadays. 😉 Welcome in the game. Check there [Easy Display SQLite](https://forum.xojo.com/25362-get-sqlite-files-properties-schema-and-contents) to watch mine. Mine is pretty simple, reject \> 64 Columns Tables, does not shows TABLE VIEWS, TRIGGERS, INDEXES, etc. In mine, there are some special buttons (special here means for my own use, I will remove them later), other squared buttons are work in progress, etc. Oh, and look at the other window… and always check a copy of your SQLite db file. I shared this application… 2 years ago (2015-08-30 ). Rough, but displays what I need. Enjoy. ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 14, 2017, 9:39am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/6 "2017-06-14T09:39:19Z")
[quote=335989:@Joost Rongen]@Alwyn Bester - you could consider using the Lexing control to provide syntax SQL highlighting . I use it in my query-builder project for more than a year now and it works super.[/quote] I will take a look at Lexing. In the meantime I did create a feature request ticket for Syntax Highlighting, so expect to see it in a future version. ---
**Author:** ![Peter\_Fargo](https://forum.xojo.com/user_avatar/forum.xojo.com/peter_fargo/32/977_2.png) [@Peter\_Fargo](https://forum.xojo.com/u/Peter_Fargo)\ **Post date:** [June 14, 2017, 9:54am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/7 "2017-06-14T09:54:38Z")
Alwyn I gave it a quick spin. I received the same message as Dave (MacOS) If I close the main window I am stuck. I understand a license is required for the “New” menu item but the “Open” menu item is grayed out as well. I need to quit and relaunch. (MacOS) A couple of things that would be nice Remember window size/position on relaunch. Recent files. Does it handle encrypted databases? Any plans for CubeSQL support? ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 14, 2017, 10:10am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/8 "2017-06-14T10:10:23Z")
Thank you for all the feedback Peter. I plan to do some proper testing on MacOS for the next version to resolve all the issues you and Dave are experiencing on MacOS. There is already a future request ticket for recent files, and I’ve created another feature request ticket request for the remembering of window size/position on relaunch. Yes, it handles encrypted databases, but currently only for AES-128 (OFB) encryption. This should be fine for working with encrypted databases in your Xojo projects. Our first goal is to get SmartData as stable as possible on all platforms, where after we’ll evaluate how to proceed with the tool. I’ll make sure to include the possibility of adding support for CubeSQL in our discussions and planning. ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 14, 2017, 10:12am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/9 "2017-06-14T10:12:17Z")
PS. The Open menu item should definitely NOT be grayed out. Will look into this. ---
**Author:** ![Alain\_Bailleul](https://forum.xojo.com/user_avatar/forum.xojo.com/alain_bailleul/32/1370_2.png) [@Alain\_Bailleul](https://forum.xojo.com/u/Alain_Bailleul)\ **Post date:** [June 14, 2017, 10:43am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/10 "2017-06-14T10:43:21Z")
> [@335969:@Alwyn Bester](#): > > it can’t handle large tables (million + rows)… or at least I gave up waiting I wouldn’t be to concerned about this one. Most professional tools only show the top 1000 rows. You could build in pagination, but in practice one writes a query to limit what one needs. I always use the free SQLite Browser ([http://sqlitebrowser.org/](http://sqlitebrowser.org/)), which works nice so be aware that if you plan to sell it, it will need some extras, not freely available. To build queries, I use FlySpeed SQL Query, windows only I think, ([http://www.activedbsoft.com/overview-querytool.html](http://www.activedbsoft.com/overview-querytool.html)) because it has a familiar visual builder like MSAccess. Could be an idea to add this ‘extra’ in your tool 😉 ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 14, 2017, 10:53am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/11 "2017-06-14T10:53:42Z")
> [@336000:@Alain Bailleul](#): > > I wouldn’t be to concerned about this one. Most professional tools only show the top 1000 rows. You could build in pagination, but in practice one writes a query to limit what one needs. I am considering the pagination idea to allow for the convenient editing of large data sets. Will play around with a few ideas to see what we can come up with. > [@336000:@Alain Bailleul](#): > > … it will need some extras, not freely available. We have a lot planned for the tool. One of the focus points at this stage is CSV support. To make it super easy to import and query CSV data with the tool. (or to export CSV data). But I hear what you say… some extras will have to be on the table 😉 > [@336000:@Alain Bailleul](#): > > To build queries, I use FlySpeed SQL Query, windows only I think, ([http://www.activedbsoft.com/overview-querytool.html](http://www.activedbsoft.com/overview-querytool.html) ) because it has a familiar visual builder like MSAccess. Could be an idea to add this ‘extra’ in your tool I will definitely take a look at FlySpeed. The idea with SmartData is to make working with data as easy and convenient as possible, and such a tool might add to that goal. Thank you for the ideas Alain. Much appreciated. ---
**Author:** ![Joseph\_E](https://forum.xojo.com/user_avatar/forum.xojo.com/joseph_e/32/613_2.png) [@Joseph\_E](https://forum.xojo.com/u/Joseph_E)\ **Post date:** [June 14, 2017, 11:32pm UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/12 "2017-06-14T23:32:23Z")
Here’s another one… SQLite Manager which is a Plugin/Add in for Fire Fox browser, it seems to work really well: [SQLite Manager](https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/) ---
**Author:** ![Joost\_Rongen](https://forum.xojo.com/letter_avatar_proxy/v4/letter/j/a9a28c/32.png) [@Joost\_Rongen](https://forum.xojo.com/u/Joost_Rongen)\ **Post date:** [June 15, 2017, 5:26am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/13 "2017-06-15T05:26:49Z")
I use Navicat Premium, the one fits all solution for database-developments. Not cheap but provides everything you need. Available for Mac and Windows. ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 15, 2017, 6:29am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/14 "2017-06-15T06:29:12Z")
> [@336193:@Joseph Evert](#): > > Here’s another one… SQLite Manager which is a Plugin/Add in for Fire Fox browser, it seems to work really well: The SQLite Manager plugin looks real neat Joseph. > [@336208:@Joost Rongen](#): > > I use Navicat Premium, the one fits all solution for database-developments. Yes, I’m well aware of Navicat. It definitely is a well-matured DB solution. Time for me to get back to coding now so that I can catch up with the competition 😉 ---
**Author:** ![Joost\_Rongen](https://forum.xojo.com/letter_avatar_proxy/v4/letter/j/a9a28c/32.png) [@Joost\_Rongen](https://forum.xojo.com/u/Joost_Rongen)\ **Post date:** [June 15, 2017, 6:38am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/15 "2017-06-15T06:38:08Z")
> [@336225:@Alwyn Bester](#): > > Time for me to get back to coding now so that I can catch up with the competition 😉 You’re doing well Alwyn. ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 16, 2017, 9:21pm UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/16 "2017-06-16T21:21:07Z")
{Zoclee}™ SmartData v2.0.9 is now available for download. You can download the latest version at [https://www.zoclee.com/smartdata/download.php](https://www.zoclee.com/smartdata/download.php) This version mainly focuses on smoothing out the user experience for OS X users. Release Notes: [Fix] Fixed “Database file doesn’t exist in the specified location” error on OS X. [Fix] Fixed issues with release notes on OS X. [Fix] Menu items on application menu are no longer grayed out on OS X when the main window is closed. [New] Window size/position is now remembered on relaunch. ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 16, 2017, 9:23pm UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/17 "2017-06-16T21:23:38Z")
> [@335936:@Dave S](#): > > Uh… I hadn’t even been given a chance to do anything… so what database is it seeking and what location is it expecting to find it? It turns out the error was caused by code written for Windows that uses command line parameters when you open files from the explorer using the “Open With” option. This should be sorted now in version 2.0.9. ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 16, 2017, 9:24pm UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/18 "2017-06-16T21:24:33Z")
> [@335993:@Peter Fargo](#): > > If I close the main window I am stuck. I understand a license is required for the “New” menu item but the “Open” menu item is grayed out as well. I need to quit and relaunch. (MacOS) > [@335993:@Peter Fargo](#): > > Remember window size/position on relaunch. Both of these are now sorted out in version 2.0.9. ---
**Author:** ![Peter\_Fargo](https://forum.xojo.com/user_avatar/forum.xojo.com/peter_fargo/32/977_2.png) [@Peter\_Fargo](https://forum.xojo.com/u/Peter_Fargo)\ **Post date:** [June 17, 2017, 9:36am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/19 "2017-06-17T09:36:19Z")
Menu issues fix confirmed. Window size/position is not working for me. Always opens fully expanded to display (not fullscreen mode). Another quirk… Select t\_project.name, t\_vendor.name, t\_expenditure.date\_expenditure, t\_expenditure.amount From t\_project Join t\_workorder On t\_project.project\_id = t\_workorder.project\_id Join t\_vendor On t\_workorder.vendor\_id = t\_vendor.vendor\_id Join t\_expenditure On t\_workorder.workorder\_id = t\_expenditure.workorder\_id My resulting records are not distinguishing the two fields “name”. I get the vendor name in both columns of the listbox. Easy enough to workaround with aliases but shouldn’t have to. Edit: Also there is not edit menu so I had to contextual click to paste in a query I created outside the app. ---
**Author:** ![Alwyn\_Bester](https://forum.xojo.com/user_avatar/forum.xojo.com/alwyn_bester/32/23099_2.png) [@Alwyn\_Bester](https://forum.xojo.com/u/Alwyn_Bester)\ **Post date:** [June 17, 2017, 10:05am UTC](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200/20 "2017-06-17T10:05:38Z")
Thanks for the feedback Peter. I’ve created tickets for - Window size/position not working as expected on OS X - Distinguish between similar columns without using aliases - Add edit menu to SQL window. Peter, with regards to the window size/position, could you please confirm for me if the position/size is at least saved when your window is not maximised? E.g. if you set the window to a size smaller than the screen and move it to some position, close the app and then re-open it, that it remembers this size and position correctly? You can replay previously runned queries using the replay icon above the SQL console window, or run queries directly from files using the file icon above the SQL console window. But I will add a proper edit menu for the SQL console. I have already implemented the Recent Files, which will be in the next version. Before I do the next release though, I would like to just give some attention to the issues Dave mentioned as well, like for example dealing with very large data sets efficiently. Once again, thank you for the feedback. [Next page](https://forum.xojo.com/t/smartdata-for-sqlite-now-free/38200.md?page=2)