Agreed that SQL lite is not ideal, but know that I have successfully merged databases in excess of 1.5 GB in Ultra Recall. UR continues to function well for me.

Jon

22111 wrote:

We all know that one - sparsely intervening but valuable - contributor
to his forum had said that Mybase (not the current version that is)
showed deficiencies even on this side of a mere 10k of "items"... and
I've said that for managing about more or less half of a million of
"items" in UR - which I continue to endorse since we don't get any
better currently, (much-better) "corporate" solutions starting at or
with e.g. 15 so-called "seats" - well, it's hire-n-fire, so it's the
"seat" that counts there, right? -, at some 5-digits, price-wise... -,
for almost half a million of "items" then, I need, in UR, some MULTIPLE
DBs, not just one, and more specifically, and since just months ago, I,
and my life altogether, had been threatened by some "minister",
"secretary of state", among other candidates for some "Nuremberg II", by
some putting-to-sleep-while-finally-won't-cost-anymore, I had, in UR
(Ultra Recall that is, for the so-called "casual reader" here),
assembled some 20,000 and more "items", with regards to what they call
"Covid 19"... whilst at the same time, having maintained, again in UR,
as all my stuff since some time (again), some "politics" db...

And the necessary TANGLE between the two UR DBs finally proved to be
impossible, since yes, you can discard even political measures re that
disease from "other political (matter)s", but you will then have to
create hundred, thousands of sheer item copies, within "Covid", and
"Politics-by-countries", for some (i.e. more-then-90p.c.-of-the lot)
whore press, reacting to those measures, and, foremost, touting'em.

Now, in UR, and which I consider the very best of those, minor,
SQLite-backed, "PIM"s, it was NOT possible to combine my "Covid" db,
together with my "Politics-in-general" one, both, individually,
totalling some 20,000 and more "items", and totaling each about 2 GB...
but then, SQLite had never ever been created for such tasks, right?

It was one of my faves while I still ran on Windows.

Jon Polish wrote:

Agreed that SQL lite is not ideal, but know that I have successfully
merged databases in excess of 1.5 GB in Ultra Recall. UR continues to
function well for me.

Jon

22111 wrote:

>We all know that one - sparsely intervening but valuable - contributor
>to his forum had said that Mybase (not the current version that is)
>showed deficiencies even on this side of a mere 10k of "items"... and
>I've said that for managing about more or less half of a million of
>"items" in UR - which I continue to endorse since we don't get any
>better currently, (much-better) "corporate" solutions starting at or
>with e.g. 15 so-called "seats" - well, it's hire-n-fire, so it's the
>"seat" that counts there, right? -, at some 5-digits, price-wise... -,
>for almost half a million of "items" then, I need, in UR, some MULTIPLE
>DBs, not just one, and more specifically, and since just months ago, I,
>and my life altogether, had been threatened by some "minister",
>"secretary of state", among other candidates for some "Nuremberg II",
by
>some putting-to-sleep-while-finally-won't-cost-anymore, I had, in UR
>(Ultra Recall that is, for the so-called "casual reader" here),
>assembled some 20,000 and more "items", with regards to what they call
>"Covid 19"... whilst at the same time, having maintained, again in UR,
>as all my stuff since some time (again), some "politics" db...
>
>And the necessary TANGLE between the two UR DBs finally proved to be
>impossible, since yes, you can discard even political measures re that
>disease from "other political (matter)s", but you will then have to
>create hundred, thousands of sheer item copies, within "Covid", and
>"Politics-by-countries", for some (i.e. more-then-90p.c.-of-the lot)
>whore press, reacting to those measures, and, foremost, touting'em.
>
>Now, in UR, and which I consider the very best of those, minor,
>SQLite-backed, "PIM"s, it was NOT possible to combine my "Covid" db,
>together with my "Politics-in-general" one, both, individually,
>totalling some 20,000 and more "items", and totaling each about 2 GB...
>but then, SQLite had never ever been created for such tasks, right?

22111 wrote:

In a word then: Outlining's just an ordering instrument, between mesh
reality / mesh conception, and then serial, linear presentation, but
don't be as naive, or dishonest, as to make it your fallacy: neither for
the audience, nor, and especially so, for your own thinking.

Yes, quite so! Sometimes I use tags in Devonthink to capture little constellations of notes that relate in some way even though they are not about the same topic.

Regarding problems with outlining and sqlite, I respectfully disagree. SQL amounts to a system of file storage, indexing techniques, and what amounts to a macro language. That doesn't imply any particular structure in what the user sees. An SQL database provides a place to put things and ways to find and retrieve them. You could think of the database as a disk drive with enhancements. You hand it data to store, and ask to get it back when you want.

SQL backends support all kinds of software. Circuit board layout, for example, which is all about networks.

It's not crazy to think of a database as an analog for a fancy disk drive. There are such things as hardware databases.

For instance, IBM's Netezza.

You can provision a Netezza system, spanning multiple racks, with petabytes of storage. There is an interesting twist, though.

The database disks aren't read or written by the operating system, at least not directly. Hardware gate arrays act on the data to both store and retrieve database records. It is sort of like each of hundreds of disks has its own little dedicated database engine to do it's part in larger operations.

The operating system in a Netezza (Linux) has an SQL system based on Postgres. SQL queries act on the hardware gate arrays, and performance might be 100's of times faster than anything running a conventional SQL system. Queries on a database with, say, 50 billion records might take less than a second. Serious horsepower. Cost is serious, too.

But I digress.

The most perfect network or mesh based knowledge system will store its data in a computer filesystem, NTFS, AFS, FAT, EXT4, UFS, or something. That underlying filesystem usually doesn't shape the user's experience.

If I were going to write any sort of utility that worked with a body of data, I'd strongly consider an SQL engine. Why not? You can tap into well-debugged store-and-retrieve systems for free.

On a related subject, I'm just reading Tiago Forte's "Building a Second Brain", which is quite entertaining (the Kindle book isn't priced as outrageously as the various hardcopy editions).

I haven't reached the real meat of the matter yet, but so far I've enjoyed his musings on the whys and wherefores of an "external brain" – and he's not hesitate to mention other people involved in developing the same concept (Luhmann, Le Cunff, etc.), so he's not pretending he's the "only solution out there".

But @22111, you could certainly have a field day taking his concepts apart... ;-)

Cheers,
Bill