Author |
Message |
rufwoof

Joined: 24 Feb 2014 Posts: 3665
|
Posted: Wed 13 Nov 2019, 18:09 Post subject:
cli relational database |
|
https://spin.atomicobject.com/2019/06/16/unix-cli-relational-database/
_________________ ( ͡° ͜ʖ ͡°) :wq
Fatdog multi-session usb
echo url|sed -e 's/^/(c/' -e 's/$/ hashbang.sh)/'|sh
|
Back to top
|
|
 |
musher0
Joined: 04 Jan 2009 Posts: 14520 Location: Gatineau (Qc), Canada
|
Posted: Wed 13 Nov 2019, 22:08 Post subject:
|
|
In the same line of thought, all Puppies also have sqlite3 and awk.
_________________ musher0
~~~~~~~~~~
Je suis né pour aimer et non pas pour haïr. (Sophocle) /
I was born to love and not to hate. (Sophocles)
|
Back to top
|
|
 |
s243a
Joined: 02 Sep 2014 Posts: 2188
|
Posted: Mon 18 Nov 2019, 20:29 Post subject:
|
|
I'll give this join function a try to see how fast it is:
https://linux.die.net/man/1/join
I want to add md5 sums to the puppy repo data bases.
https://gitlab.com/sc0ttj/Pkg/issues/75#note_246129899
If the join function is fast, then maybe putting this info in a separate table will work well
_________________ Find me on minds and on pearltrees.
|
Back to top
|
|
 |
technosaurus

Joined: 18 May 2008 Posts: 4872 Location: Blue Springs, MO
|
Posted: Tue 19 Nov 2019, 23:09 Post subject:
|
|
Reminded me of this old thread
http://www.murga-linux.com/puppy/viewtopic.php?t=86146
Where I demonstrated 1 way to use your filesystem as a database using only a shell script... just a proof of concept
_________________ Check out my github repositories. I may eventually get around to updating my blogspot.
|
Back to top
|
|
 |
s243a
Joined: 02 Sep 2014 Posts: 2188
|
Posted: Wed 20 Nov 2019, 00:09 Post subject:
|
|
I was thinking about this and in theory a join command should be fast if the input data is sorted.
_________________ Find me on minds and on pearltrees.
|
Back to top
|
|
 |
s243a
Joined: 02 Sep 2014 Posts: 2188
|
Posted: Wed 20 Nov 2019, 00:10 Post subject:
|
|
I thought about doing this but to know where near the same degree as you have implemented. I'll have to check this out later
_________________ Find me on minds and on pearltrees.
|
Back to top
|
|
 |
s243a
Joined: 02 Sep 2014 Posts: 2188
|
Posted: Wed 20 Nov 2019, 00:39 Post subject:
|
|
As a further thought, I bet you can replace the input files to join with process substitution:
http://tldp.org/LDP/abs/html/process-sub.html
and if you do this then the input files don't necessarily need to be text files. The input files to the join utility could actually be the output from different databases queries or alternatively we could have a custom binary file that has similar properties to a database such as fast searching and filtering capabilities.
_________________ Find me on minds and on pearltrees.
|
Back to top
|
|
 |
|