Tadpole - for SQLite

  1. 4 months ago

    Dave S

    Jun 14 San Diego, California USA

    Well I figured I better make my approach to an SQLite tool visible since there seems to have been a few others released lately :)

    So here is my contribution....

    Tadpole for SQLite will soon be released for both macOS and Windows, Written in 100% Xojo it offers many features found in tools costing a lot more.

    Some of the features to be found in Tadpole

    • Syntax Highlighting
    • Ability to create/delete/alter Tables (the Alter Table is the last feature in works for now)
    • Ability to create/delete/alter Indexes
    • Ability to create/delete/alter Triggers
    • Ability to create/delete/alter Views
    • Ability to view/edit tables with Millions of records
    • Import from CSV tables with most common delimiter types
    • Export to CSV tables
    • Export to JSON
    • Export to HTML
    • Export to Microsoft Excel (even under macOS)
    • ability to attach up to 10 databases together
    • ability to run SQL Scripts (mulitiple statements in one query)
    • full ability to load/save SQL Scripts
    • built in SQL "Pretty" formatter
    • Add/Delete/Edit rows
    • user has full control over Fonts, colors
    • and much more

    In this Beta version, the ALTER TABLE feature only supports adding new columns. A full featured ALTER TABLE in currently in work and will be in a soon to be released version. This is a time limited evaluation copy (15 days).

    Once released, it will offer a one time fee for a LIFETIME license. And future versions are scheduled to have things such as Visual Query Builder, Data Visualization, Foreign Key support, built in reports and perhaps other features.....

    macOS version : www.rdsisemore.com/tadpole/tadpole4macos.zip this is a signed AppWrapped version
    Windows10 : www.rdsisemore.com/tadpole/tadpole4win.zip NOTE : this does NOT include an installer (yet)

    -image-
    -image-

  2. Peter F

    Jun 14 Pre-Release Testers, Xojo Pro New England

    Dave - Looks powerful. I did have the following issue...

    First run I opened the Chinook database. I quit, relaunched and double clicked Chinook in the recent database list and got a NOE.

    -image-

  3. Dave S

    Jun 14 San Diego, California USA
    Edited 4 months ago by Dave S

    Lovely..... I wonder what the issue could be.... because when I tried it opened it with no problem at all :(

    have you added/deleted/modified anything in this copy of Chinook vs the version deployed in the Examples folder?

    Don't you hate when you test the cr*p out of something, and someone breaks it in two seconds? (sigh) ... :)

    The next release has a proper handler for "unhandled exceptions".....

  4. Beatrix W

    Jun 14 Pre-Release Testers Europe (Germany)

    Grin.... that happens to me for ALL new versions of my app. Don't you have handler for this? All methods in my apps have

    exception exc
      theException = new ErrorException(exc, currentMethodName)

    in it. This cleans the stack, writes everything to a log file, shows the user a nice window and offers to send all files to me.

  5. Dave S

    Jun 14 San Diego, California USA

    @Beatrix W Grin.... that happens to me for ALL new versions of my app. Don't you have handler for this? All methods in my apps have

    exception exc
      theException = new ErrorException(exc, currentMethodName)

    in it. This cleans the stack, writes everything to a log file, shows the user a nice window and offers to send all files to me.

    It does now :)

  6. Alwyn B

    Jun 14 Pre-Release Testers, Xojo Pro Johannesburg, South Africa
    Edited 4 months ago by Alwyn B

    Very impressive list of features Dave. It is obvious that a lot of hard work went into building Tadpole.

    I love the visual look of the tool... it's very user friendly.

  7. Richard D

    Jun 14 Pre-Release Testers Europe (UK, London)
    Edited 4 months ago by Richard D

    i try on ACMS Data file and it work fine... BUT on my ARTSCENE data file i got the following error.

    -image-

  8. Peter F

    Jun 14 Pre-Release Testers, Xojo Pro New England

    I may very well have modified it although there is nothing obvious. I did download a fresh copy and do not have the problem.

    One other issue is a couple of times when I quit the app confirmed my wanting to disconnect and they quit but I got the system message about The application quit unexpectedly - do you want to send data..... May or may not be related.

    Let me know if you want the copy that caused the NOE.

  9. Peter F

    Jun 14 Pre-Release Testers, Xojo Pro New England

    Something weird going on. I've got 6 databases that it can not open - yet all my other tools open them with no problem. One is another standard database "Sakila" and the other 5 are client projects.

    -image-

    Let me know if I can help.

  10. Dave S

    Jun 14 San Diego, California USA

    Encrypted databases???

  11. Tim P

    Jun 14 Pre-Release Testers, Xojo Pro

    Not Sakila: https://github.com/jOOQ/jOOQ/tree/master/jOOQ-examples/Sakila

  12. Peter F

    Jun 14 Pre-Release Testers, Xojo Pro New England

    @Dave S Encrypted databases???

    No. I have sent you copies of my Chinook and Sakila.

  13. Peter F

    Jun 14 Pre-Release Testers, Xojo Pro New England

    Good news :)
    I do not have these issues under Windows 10.

  14. Dave S

    Jun 14 San Diego, California USA

    Well I think I found the "cause"..
    I cannot get Chinook to not open... I have opened, closed, open again... shut Tadpole down, and it opens each time.

    But Sakalia will open in my dev copy, but NOT in the AppWrapped version???
    If I compile and don't wrap it ... seems to be no problem (And the Win10 version obviously isn't "wrapped")

    Anyone know if AppWrapper might have some switch that causes something like this?

  15. Tim P

    Jun 14 Pre-Release Testers, Xojo Pro

    Are you sandboxing your code signed version?

  16. Dave S

    Jun 14 San Diego, California USA

    @Tim P Are you sandboxing your code signed version?

    Isn't that what AppWrapper is all about?
    Why would that be an issue? It can open other databases sitting right next to this one that it cannot connect to

    Plus. to qualify for the AppStore it has to be sandboxed

  17. Dave S

    Jun 14 San Diego, California USA

    Great :(
    It seems the "sandbox" is causing the issue... If I AppWrap without that option it works just fine..
    Any ideas??????

  18. Jürg O

    Jun 14 Pre-Release Testers, Xojo Pro

    @Dave S Any ideas?

    no, just a suspicion... .shm and/or .wal - files could be involved :)
    opening a sqlite file may want/need to write these files - which the user hasn't allowed in the sandboxed version.

  19. Tim P

    Jun 14 Pre-Release Testers, Xojo Pro

    I'm looking at your entitlements in AppWrapper. You don't need access to the Downloads folder with a SQLite app, you'll likely get rejected for that.

    Jürg is probably right on the nose. To get the desired behavior, you'll have to find out how to tell SQLite to use a different temporary location to sandbox your app properly.

  20. Tim P

    Jun 14 Pre-Release Testers, Xojo Pro

    I'm not sure what's up with your app icon, but the original stock image isn't as pixelated or rough.

  21. Newer ›

or Sign Up to reply!