Database Structure

[roland_cita]

I am currently coding for some external tool something like a bugtracking and would like to use as well the Database-Structure of CintaNotes. The MAIN-idea would be to place there some notes and have access to it without my tool. Some kind of additional reminder.

Is it somewhere (briefly) described, how to insert e.g. a new entry into the database? e.g. new 'Topic' with 'blah-blah-bla-content' Or is this internal and no help provided?

[Thomas Lohrum]

It is a sqlite database. You can query its structure using standard tools. The same is true for manipulating its data. However i suggest to use the IMPORT feature instead. It is easy to create such a structure, e.g. using the XML-format. To retrieve the schema-format simply do an export of some note. You'll need the commercial version for that feature to use.

Thomas

[CintaNotes Developer]

No it is not described and actually for a good reason: this is an internal format which may be changed in every new version of CN.
CN handles the DB upgrades itself and is always backward-compatible.
But this also means that becoming dependent on this format is hardly a good idea. So if it's an option (I'm still not sure I completely understand your intentions and direction of data exchange), you'd probably be better of with XML format, like Thomas suggests.

Of course if you're willing to accept the upgrading challenges, there's no problem: the DB structure is pretty straightforward.
If you have questions regarding specific tables or columns, you can ask here and it will be my pleasure to help.

[Pacerier]

Hi Admin, where is the metadata for the notes stored? : viewtopic.php?f=3&t=2285

[yogi]

Hi Alex,
maybe you consider some sort of simple CN-API.
Lets say a call to store a text to a new note, find a note, and retrive the content.
CN is such a versatil tool, probably other programmers find many applications for it.
I wrote a programm for astrology, but without a database for the client data. In this way I could use CN instead of programming a database system myself.
Kind regards
Yogi

[CintaNotes Developer]

Hi Admin, where is the metadata for the notes stored? : viewtopic.php?f=3&t=2285

Sorry for late reply, didn't see this question. What kind of metadata exactly do you mean?

[CintaNotes Developer]

Hi Alex,
maybe you consider some sort of simple CN-API.
Lets say a call to store a text to a new note, find a note, and retrive the content.
CN is such a versatil tool, probably other programmers find many applications for it.
I wrote a programm for astrology, but without a database for the client data. In this way I could use CN instead of programming a database system myself.
Kind regards
Yogi

Do you mean a command-line API or something like a plugin system?

[yogi]

I thougt of some standart windows C DLL (not a c# dll) with functions which can be called from the other programm.
Yogi

[CintaNotes Developer]

I see. Well, this is possible, but unless there is a really high demand for that, will hardly be implemented. You're welcome to prove demand by posting an idea to the roadmap though!