Kinook Software Forums

Go Back   Kinook Software Forums > Ultra Recall > [UR] Suggestions

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 12-07-2016, 07:21 AM
aaronjsolomon aaronjsolomon is online now
Registered User
 
Join Date: 07-06-2011
Posts: 14
Programmatic access of SQLite/Ultra Recall database

Hi,

Huge fan of UR, use it all day every day.

I've been doing a fair amount of manipulating UR databases using VBScript and the specially-compiled sqlite3.exe you provide elsewhere in this forum. (IIRC, Kinook made a minor change to the .urd file format so that other products would not recognize it as a SQLite file.)

However, it would be a real boon to be able to use more robust programming tools such as ADO.NET wrappers, ODBC drivers, etc.

RazorSQL is a great RDBMS because it performs all of its functions via the command-line tool, which gives me an opportunity to point to your custom sqlite3.exe.

However, in a scripting/programming environment, I haven't been able to figure out how to access a UR database directly, other than by constructing query strings and passing them to the command-line shell (and even this limited functionality is very useful!). This works reasonably well for simple updates and deletes, but provides no means (AFAIK) to load a result set into memory and iterate/manipulate results via code.

Question: please advise on how one might programmatically connect to a UR database via COM, .NET, ODBC, or the like. One obvious approach would be to tweak UR itself so that it can access .urd files that internally conform to the SQLite file spec, in addition to Ultra Recall's slightly tweaked version. (I'm not looking for a file conversion tool, I can figure that out myself. Just a registry entry that allows a standard SQLite file to be opened and accessed.) This approach seems ideal because I could then access the full set of SQLite tools that are out there, many of which are limited and/or costly.

Alternatively, please advise if there are other paths to this same end. There are supposedly some open source SQLite connectors where I might be able to tweak them to read .urd files, but I'm not an alpha programmer (hence VBScript), and many SQLite dev projects are dormant/flaky, so I'm reluctant to burn time on that path unless absolutely necessary.

Eagerly looking forward to your thoughts!

Cheers, Aaron

Last edited by aaronjsolomon; 12-07-2016 at 08:46 AM.
Reply With Quote
  #2  
Old 12-07-2016, 09:02 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,490
Currently, in order to access the .urd file from other SQLite tools, you would need to modify the .urd file in a binary file editor and change the first 15 bytes from

Ultra Recall DB

to

SQLite format 3

and then change it back to open again in Ultra Recall.

We'll look into modifying UR to support opening .urd files with either beginning signature.
Reply With Quote
  #3  
Old 12-07-2016, 11:17 AM
aaronjsolomon aaronjsolomon is online now
Registered User
 
Join Date: 07-06-2011
Posts: 14
OK, thanks.

The scripts I'm creating require UR to be running at least part of the time (e.g. to sync items to Outlook), so it would be great to be able to programmatically query the database while UR is running. So, allowing UR to open files with the SQLite format string would be insanely cool.

Thanks again for the quick response. I'll hold my breath until UR natively supports the SQLite signature

Cheers, Aaron
Reply With Quote
  #4  
Old 12-22-2016, 03:27 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,490
Implemented in v5.2.0.9.

http://www.kinook.com/Forum/showthread.php?t=5344
Reply With Quote
  #5  
Old 12-22-2016, 04:55 PM
aaronjsolomon aaronjsolomon is online now
Registered User
 
Join Date: 07-06-2011
Posts: 14
Thumbs up

AWESOME!!!!!!!!!

Thanks!

Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 02:57 PM.


Copyright 1999-2017 Kinook Software, Inc.