Forum Posts Feed
Outliner that supports SQL queries?
< Next Topic | Back to topic list | Previous Topic >
Posted by andrew73249
Aug 15, 2015 at 11:17 PM
I’m interested in a program that would function mainly as a front end for a database with hierarchical data. Browsing would be through the typical outline/tree seen in information manager software, but search would need to support full SQL queries, or at least support plugins or macros that can be used to perform such queries. The individual pieces of data would ideally be HTML5 pages in which I can embed sounds. (I know that last one is kind of weird!)
I can’t seem to find anything that does all of those. For example, TreeDBNotes and TreePad are very nice, but sound files can not be directly embedded and the search functions are very simple and nowhere near a fully customizable SQL query. I came across something called InfoQube (http://www.infoqube.biz), that allows SQL-like queries and Visual Basic macros, but it is still in a partially functional beta stage and does not seem to handle sounds.
Does anyone know of anything like this? I don’t mind having to pay for it, even if it’s very expensive, and I don’t mind if it’s a stand alone program or some kind of front end for another large database system like SQL Server. I’m on Windows 7. Thanks for any advice.
Posted by Jon Polish
Aug 17, 2015 at 02:42 PM
What about NoteCase Pro? It can write to a SQL file (ncdb extension) and record sound files. It also handles attachments. Ultra Recall can do even more.
Jon
Posted by Alexander Deliyannis
Aug 17, 2015 at 09:24 PM
andrew73249 wrote:
>I came across something called
>InfoQube (http://www.infoqube.biz), that allows SQL-like queries and Visual
>Basic macros, but it is still in a partially functional beta stage and
>does not seem to handle sounds.
I believe that InfoQube (originally called SQL Notes) is your best bet. In my experience it’s a fully mature product—the fact that it hasn’t formally reached v1 yet is rather irrelevant.
The learning curve matches its power, which is similar to Zoot’s: I don’t think there’s anything these programmes can’t do, but how it is done is far from evident.
I expect that the developer, Pierre Paul, will respond soon; he’s a regular contributor to this forum (beyond InfoQube). In the past he has added functionalities upon request, and I don’t think that sound would be a problem.
Posted by Pierre Paul Landry
Aug 17, 2015 at 09:35 PM
Alexander Deliyannis wrote:
>I expect that the developer, Pierre Paul, will respond soon; he’s a regular contributor to this forum (beyond InfoQube). In the past he has added functionalities upon request, and I don’t think that sound would be a problem.
>
>
Ha ! Alexander did beat me to it. I’m on part-time holidays right now, after the release of a major update last friday.
Links to sound files should not be an major dev. work. If you can, describe me the optimal system for you and I’ll see if it can be added.
(options could be one of : drag-drop a sound file, file > open multiple files, drag-drop a URL link, hyperlinks directly in the outlining grid, etc)
Pierre Paul Landry
IQ Designer
Posted by Jon Polish
Aug 18, 2015 at 04:02 PM
Pierre, are you implying that you could add the ability to embed files (attachments)?
Jon