SmartData™ for SQLite

  1. 5 months ago

    Alwyn B

    Jun 13 Pre-Release Testers Johannesburg, South Africa

    {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 .

  2. Dave S

    Jun 13 San Diego, California USA
    Edited 5 months ago

    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)
  3. Alwyn B

    Jun 13 Pre-Release Testers Johannesburg, South Africa
    Edited 5 months ago

    @Dave S ERROR: Database file doesn't exit in the specified location

    @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.

    @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.

    @Dave S shows a table as EMPTY if it were created with the "WITHOUT ROWID" constraint

    Will also look into this.

    @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.

  4. Joost R

    Jun 14 Pre-Release Testers, Xojo Pro The Netherlands

    @Alwyn B - 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.

  5. Emile S

    Jun 14 Europe (France, Strasbourg)

    This exercise seems to be pretty popular nowadays. ;-)

    Welcome in the game.

    Check there Easy Display SQLite 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.

  6. Alwyn B

    Jun 14 Pre-Release Testers Johannesburg, South Africa

    @Joost R @Alwyn B - 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.

    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.

  7. Peter F

    Jun 14 Pre-Release Testers, Xojo Pro New England

    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?

  8. Alwyn B

    Jun 14 Pre-Release Testers Johannesburg, South Africa

    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.

  9. Alwyn B

    Jun 14 Pre-Release Testers Johannesburg, South Africa

    PS. The Open menu item should definitely NOT be grayed out. Will look into this.

  10. Alain B

    Jun 14 Europe (Belgium)

    @Alwyn B 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/ ), 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 ) because it has a familiar visual builder like MSAccess. Could be an idea to add this 'extra' in your tool ;)

  11. Alwyn B

    Jun 14 Pre-Release Testers Johannesburg, South Africa
    Edited 5 months ago

    @Alain B 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.

    @Alain B ... 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 ;-)

    @Alain B To build queries, I use FlySpeed SQL Query, windows only I think, (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.

  12. Joseph E

    Jun 14 Pre-Release Testers CA

    Here's another one... SQLite Manager which is a Plugin/Add in for Fire Fox browser, it seems to work really well:

    SQLite Manager

  13. Joost R

    Jun 14 Pre-Release Testers, Xojo Pro The Netherlands

    I use Navicat Premium, the one fits all solution for database-developments.
    Not cheap but provides everything you need. Available for Mac and Windows.

  14. Alwyn B

    Jun 14 Pre-Release Testers Johannesburg, South Africa
    Edited 5 months ago

    @Joseph E 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.

    @Joost R 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 ;-)

  15. Joost R

    Jun 14 Pre-Release Testers, Xojo Pro The Netherlands

    @Alwyn B Time for me to get back to coding now so that I can catch up with the competition ;-)

    You're doing well Alwyn.

  16. Alwyn B

    Jun 16 Pre-Release Testers Johannesburg, South Africa

    {Zoclee}™ SmartData v2.0.9 is now available for download.

    You can download the latest version at 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.

  17. Alwyn B

    Jun 16 Pre-Release Testers Johannesburg, South Africa

    @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.

  18. Alwyn B

    Jun 16 Pre-Release Testers Johannesburg, South Africa

    @Peter F 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)

    @Peter F Remember window size/position on relaunch.

    Both of these are now sorted out in version 2.0.9.

  19. Peter F

    Jun 17 Pre-Release Testers, Xojo Pro New England
    Edited 5 months ago

    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.

  20. Alwyn B

    Jun 17 Pre-Release Testers Johannesburg, South Africa

    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.

  21. Newer ›

or Sign Up to reply!