Main Area and Open Discussion > General Software Discussion
SQLNotes...what is it exactly?
PPLandry:
Hi suleika,
I'll answer in more depth later on, but in a nutshell:
1- SQLNotes is based on a relational database
2- Relational databases (i.e. Access and others) can read SQLNotes data
3- Using inheritance, you can arrange SQLNotes data so it it appears relational to other databases to the point that you can base Access reports on SQLNotes data.
Armando:
An example of the "relational" sort of thing I would want to use it for is a historical work database for my singing gigs (to help me remember what I've done!). I would be listing jobs, singers, conductors, venues, dates of performances, works performed etc. Any given singer might have performed in any number of jobs with me, any work might have been performed in any number of jobs, any job might have many works performed and even more than one conductor, and a work would have a composer and might have other properties such as translation or edition.
--- End quote ---
You can do that in SQLNote. Items can have multiple parents, items can be in different "grids", etc. Wikis aren't as powerful and aren't as flexible.
Like Pierre likes to say : Think of SQLNotes and its grids as a 3d container (like a cube) to allow you to have different perspectives on your data. Each face is a different way at looking at your own data. (Of course, the "container" could have as many faces as you want... a dodecahedron?... :) )
SQLNotes can be used to organize many many things. SQLNotes can also export to html (you can also create special templates...).
Of course, even if I'm not yet an "expert", I could help you too... but this week is going to be pretty busy for me... I'll try.
In the mean time, you could start with the basic Wiki. Have a look the Getting started page. In the Wiki documentation you'll learn a a bit about Items, Fields, Equations, Search/Filtering, etc.
Don't forget to also have a look at some of the examples! (look at the column on the left of the Getting started page) And look inside all the forums for help.
:)
(IMO, the hardest think with SQLNotes might be all the subtleties allowing to display your data exactly the way you want (flat view, hierarchical view, save item state, filter criterias apply to subitems, etc.), and also the filters/sources "language" if you're not used to writing your own filters.)
PS : I,m also including the new alias I use with farr to search for info concerning SQLNotes! If you use farr, put the alias in your find and run robot alias directory.
PPLandry:
Just a heads up... Latest build is the first version to support Unicode content (in grid, properties pane and rich-text pane) (http://mantis.sqlnotes.net/view.php?id=78)
Also, grid hyperlinks is partially enabled (http://mantis.sqlnotes.net/view.php?id=62):
<a xxx>linkText</a>
where xxx can be:
1- an itemID
2- a Field/folder enclosed in [ ]
3- a Wikitag. Wikitags are enclosed in { } and entered in the WikiTag field
If the linked item is in the grid, focus is moved to it. Otherwise or if the link returns more than 1 item, the scratchpad grid is opened with the linked item(s).
Armando:
Great!!!! :)
PPLandry:
Just a heads up: Daily build was updated to include in the properties pane, the parents tree (sometimes called lineage):
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version