 |
Puppy Linux Discussion Forum Puppy HOME page : puppylinux.com "THE" alternative forum : puppylinux.info
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in|
The time now is Fri 06 Dec 2019, 07:49 All times are UTC - 4 |
 Forum index » Off-Topic Area » Programming |
|
cli relational database
|
 
|
View previous topic :: View next topic |
| Page 1 of 1 [7 Posts] |
| Author | Message | ||||
|---|---|---|---|---|---|
rufwoof
 Joined: 24 Feb 2014 Posts: 3665 |
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 |
||||
|
|||||
 |
|||||
|
musher0
Joined: 04 Jan 2009 Posts: 14520 Location: Gatineau (Qc), Canada |
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) |
||||
|
|||||
|
|||||
|
s243a
Joined: 02 Sep 2014 Posts: 2188 |
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. |
||||
|
|||||
|
|||||
technosaurus
 Joined: 18 May 2008 Posts: 4872 Location: Blue Springs, MO |
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. |
||||
|
|||||
|
|||||
|
s243a
Joined: 02 Sep 2014 Posts: 2188 |
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. |
||||
|
|||||
|
|||||
|
s243a
Joined: 02 Sep 2014 Posts: 2188 |
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. |
||||
|
|||||
|
|||||
|
s243a
Joined: 02 Sep 2014 Posts: 2188 |
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. |
||||
|
|||||
|
|||||
cli relational database
| Page 1 of 1 [7 Posts] |
|
|
View previous topic :: View next topic |
|
Forum index » Off-Topic Area » Programming |
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum |
Powered by phpBB © 2001, 2005 phpBB Group