On a sunny day (Tue, 1 May 2018 09:40:34 +0100) it happened The Natural
Philosopher wrote in :
>*shrug* my point exactly. For all their theoretical elegance, the
>language which most easily (if not 1:1) maps onto the underlying machine
>architecture, rather than mapping to and abstract computational concept
>that then has to be shoe-horned into assembler, is teh one that is the
>most popular. I have cionsiderable exposure to (My)SQL (alhtough not
>Oracle or any other heavyweight commercial implementation) and even here
>my experience proves my point. Anything more than the simplest of
>queries leads to performance issues which are solved by ignoring the
>elegant flexible features of the language and hard coding exactly what
>you are trying to do with the data ine.g. C.
>
>And it better had be C, and not PHP, because the memory management of
>that is such that it collapses in a heap (sic!) when handling large SQL
>data objects.
>
>C sits nicely between the overwight syntax and non portability of
>assembler, and teh ineffeicient and unintelligent langeuages of computer
>scientists, who instead of respecting the hardware upon which their code
>nust run, as COBOL, FORTRAN and B/BCPL/C did, instead ignore it in their
>search for symmetry elegance and presumably geek status, whils what they
>have implemented rumbles along overblown and overweight and bug filled.
Nicely stated
As to data bases, I once started making records for my CD/DVD/BDR disk
collection,
and got fed up really fast (entering records).
Now use one big text file and search with editor or use:
cat dvd-list.txt | grep movie_name
cat dvd-list.txt | grep amovie
shows all the movies I have, and their length in bytes, any other important
info, gives you disk number... and all that is on it.
As disk capacity gets bigger and bigger, anytime I buy a new PC I make a
partition with the old OS (tar / untar).
Can boot that, search it (is always mounted), or run software in it with chroot
So all data is there too.
The effect is that if I type
locate keyword
or
locate keyword | grep something
then find what I need in seconds.
All project I did are there.
Or find some code.
It sort of overrides any database that may or may not be there.
For example this newsreader I wrote and use, NewsFleX, has its own database
structure, based on Unix directory names.
Amazing, I can look up a keyword in Usenet posts I saved or postings I did,
going back to 1998 when I wrote it.
It is getting of historical value, saved a lot of interesting postings from
people.
Same disk, all back-upped too of course on several media, harddisk, flash,
bluray.
Of course data-beasts (hehe) are big business, companies like .. sell that to
other companies... for lots of $$$$$.
Much much harder to use than locate and grep, and there is awk too, it is
really worth it knowing those little utilities.
And faster, and no overhead.
To stay in the same perspective, been using 'pine' as email reader since 1998
too.
A simple 'grep' for a word in the ~/mail directory for any keyword gives me all
references in emails to that word back to 1998.
I never had a - or needed a change in email client in all those years,
'pine' is a university project by University of Washington, now called 'alpine'
it seems, but does the same thing as pine.
Sometimes I wonder how people get along without it,
And fetchmail.
Maybe the best way to sell bloat is not educate people of the right way to do
things, of the underlying system architecture.
There is a poster in sci.electronics.design who runs a very high tech company,
he wrote his own (thousands of electronics parts) database in BASIC, just a few
lines...
Now you may think that for millions of records you really DO need ..
well they tried to overhaul the tax system here, that project lasted years, did
cost millions and millions, and failed.
I had to be stopped.
To me, from the complexity of the few lines really (compared to the many
thousands of lines code I wrote) tax laws,
it seems the data-beast they used died.
Just simple money making strategy imposed by greedy companies on the technical
clueless (often by clueless politicians).
Top down does NOT work,
an architect that does not know about bricks and concrete etc cannot build a
skyscraper (not one that I want to be near anyways).
There is more, but the advice here is IF you use a raspberry, and want to find
something,
use
locate something
search in a txt file use
grep keyword
and to see if anything has a manual about it, use:
apropos subject
If you have some stuff make a text file and search it with grep.
I use those utilities many times each day.
--- SoupGate-Win32 v1.05
* Origin: Agency HUB, Dunedin - New Zealand | FidoUsenet Gateway (3:770/3)
|