I have run just about into a deadend in trying to get Infoqube to run in Linux, which is where I do most of my work nowadays. Before I pester Pierre about that some more, I am wondering if anyone knows of any grid-oriented database software that would work for a personal information database. Here's my direction:

I keep looking at CintaNotes (even though it doesn't work in Linux) because I am realizing that all I really want for 98% of my uses is a "scrolling" list of text-oriented items that can be sorted by tags (CintaNotes) or by associated column markers (Ecco) or in the way that Evernote used to do at the beginning (maybe still does; I'm not sure). In other words, I want to be able to keep a running list of items, probably marked by dates, that I can just pick a filter and scroll up and down the list, and copy and paste from that list, as needed.

I realize as I describe this that I can probably do most of this with a simple spreadsheet that allows rich text and word wrap in columns, but I want the searching and filtering capabilities that Ecco or CintaNotes offers.

Another way of saying this is that after almost 30 years as an Ecco user I realize I don't use the folder tree, I don't use the calendar, I don't use the phonebook, I don't use the Gantt charting -- all I really use is the flexible spreadsheet/outlining window where I enter rich text and then organize and sort it by columns (or tags in the new parlance).

I am sure Pierre is tired of hearing that infquube is overkill for this use, but I'd probably still be using it if I could get it to run in Linux.

But the reason for this post is to find out if anyone has recommendations on either an online or offline (that runs in Linux) grid-oriented database program that might fit what I am describing. I remember as I end this post that this forum is the "OutlinerSoftware" forum and not the "Database" forum, so I will say that having the ability for the main text to be in an outline, or at least to contain an outline, like Ecco and Infoqube do, is highly desirable.

But even if I couldn't get that, I still think I would do much of my work in a spreadsheet-looking environment if it had easy to use tagging/columns/filters.

Thanks for any ideas.

This may be a bit too much on the simple side, but have you tried Simplenote?
https://simplenote.com/2017/11/20/windows-and-linux-app-update-now-available-2/

It doesn't support rich text as such, but it does markdown, including preview.

I haven't tried the applications myself, though I use the service for syncing Cintanotes.

Thanks for the suggestion.

Oh yes, I have and use Simplenote, but I don't want another "two pane outliner" where the right-hand pane is one entire item, and I have to scroll through the headers on the left to get new content on the right. I am looking much more for the data itself to be scrolling, as in Cintanotes, without the data being separated into "panes"

In the time since I made my post I did some more googling and ran across MATRIFY -- https://www.matrify.com/en which I had never seen before.

That paradigm seems to fit MANY of my checkpoints in terms of an easy-to manipulate spreadsheet/database combination. However my heart sunk when I saw the pricing -- way out of my price range. I'm really looking for something like this that's open source or much more reasonable in cost. I'm a single user, but I have many different computers in different locations and I need to access the data on them all.

Again, thanks for the suggestion.

On reading the description at matrify, maybe I should be specifying "TABLE-based" rather than "grid-based" -- although both words probably get the meaning across.

And a really desirable feature of such a format would be in-cell editing with rich text, including word wrapping within the cell. Again, all of which Infoqube will do (in addition to much much much much much more ;-) )

Reminds me of AirTable and ZenKit (and I think they are cheaper). Of course, they are both subscription services and web-based, which may not be what you are looking for.

This may be overkill, but with a little configuration you can do what I think you want. Very fast and light on resources. Not sure if it will run on Linux.

Jon

I second Airtable. It's cloud-based, but powerful, intuitive, and there's a free version. Feels like a spreadsheet, but in fact a relational database. Also very configurable, but the defaults ate same.

Jon I am sorry if I miss the reference but to what does "this" refer?

Jon Polish wrote:

This may be overkill, but with a little configuration you can do what I
think you want. Very fast and light on resources. Not sure if it will
run on Linux.

Jon

http://tkoutline.sourceforge.net/cgi-bin/scm/wiki?name=Download+and+installation


http://buzz.sourceforge.net


http://treeline.bellz.org/index.html
https://github.com/doug-101/TreeLine

https://kynikos.github.io/outspline/index.html
https://github.com/kynikos/outspline/wiki/Getting-started#installation

cicerosc wrote:

I have run just about into a deadend in trying to get Infoqube to run in Linux, which is where I do most of my work nowadays. Before I pester Pierre about that some more...

Hi cicerosc,

I'll make a stripped down version of IQ for you to see if we can get it to run on Wine. Give me a few days...

Pierre

@Pierre: A stripped down version of IQ? Sounds interesting, very interesting.

I'm finishing up the new tag system and will then do some test on a linux virtual machine, any preferred distribution ?

For those not aware, I'm currently implementing a true multi-parent hierarchical tagging system for InfoQube with support for AND, OR, NOT operators as described by Paul here:
https://pauljmiller.wordpress.com/2018/06/20/note-taking-software-back-to-basics/

(he doesn't mention multi-parent... that's my contribution :-) )

It is very powerful !!!

Pierre

Pierre --

1 - I would be very grateful for a slimmer version and will look forward to testing it and giving feedback.

2 - I use MX-17 linux, which is debian based. I've done a lot of distro-hopping and it's my two cents that debian (the root of Ubuntu) is the best guarantee of the widest compatibility. I am no expert but I also observe the continuing wars between gnome developers and others, such as QT-based developers, and I think if I were a developer I would avoid trying to use the very cutting edge distros (such as the GTK3 ?) and I would use something that's been out a while (such as in ubuntu's case 16.04 rather than 18, or debian 8 jessie rather than stretch 9) No doubt there are others here better than me for this kind of advice, but using a version of a distro that is a year or two old for development would probably mean the end result has greater compatibility with the widest variety of distros. All that being said, anything you produce I will be testing using MX17 and Crossover wine.

cicerosc wrote:

Pierre --

1 - I would be very grateful for a slimmer version and will look forward
to testing it and giving feedback.

2 - I use MX-17 linux, which is debian based. I've done a lot of
distro-hopping and it's my two cents that debian (the root of Ubuntu) is
the best guarantee of the widest compatibility. I am no expert but I
also observe the continuing wars between gnome developers and others,
such as QT-based developers, and I think if I were a developer I would
avoid trying to use the very cutting edge distros (such as the GTK3 ?)
and I would use something that's been out a while (such as in ubuntu's
case 16.04 rather than 18, or debian 8 jessie rather than stretch 9) No
doubt there are others here better than me for this kind of advice, but
using a version of a distro that is a year or two old for development
would probably mean the end result has greater compatibility with the
widest variety of distros. All that being said, anything you produce I
will be testing using MX17 and Crossover wine.

Wondered about these limiting & suspicious assumptions, asked a Linux expert friend who agreed with details, also informed me on several more killer Linux apps for outlining/note takers-2-xls/csv/db, as am increasingly using Linux mode on Chromebook myself.

The "details" include me having problems recently with a Qt based app & graphic servers/cards, whereas never had problems with GTK+ based apps which always seem lighter, smoother & more optimum to me personally. Qt based apps always seem a heavy graphics layer on top compared to GTK+ variations, more like simulating an O/S on top of another. Maybe why graphics ambitious/intensive apps choose Qt. YMMV.

cicerosc wrote:

Jon I am sorry if I miss the reference but to what does "this" refer?

Jon Polish wrote:
This may be overkill, but with a little configuration you can do what I
>think you want. Very fast and light on resources. Not sure if it will
>run on Linux.
>
>Jon

Sorry for my late reply. I thought I included the link. Here it is.

https://citadel5.com/gs-base.htm

Jon

cicerosc wrote:

Jon I am sorry if I miss the reference but to what does "this" refer?

Jon Polish wrote:
This may be overkill, but with a little configuration you can do what I
>think you want. Very fast and light on resources. Not sure if it will
>run on Linux.
>
>Jon