Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Wed 14 Nov 2018, 12:26
All times are UTC - 4
 Forum index » Advanced Topics » Cutting edge
Puppy Database
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 12 of 19 [272 Posts]   Goto page: Previous 1, 2, 3, ..., 10, 11, 12, 13, 14, ..., 17, 18, 19 Next
Author Message
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Fri 27 Nov 2015, 13:10    Post subject:  

Hello all.

Here is probably one of the best names and addresses database ever:
http://www.tranglos.com/free/phonedeck.html
A bit old, lacks incorporation of pictures, but still very good.

On the download page, don't forget the import-export module and
the language pack -- if you need them.

The tool to use if you have to do regular follow-ups with your
business or community contacts, IMO.

You need wine installed, though. I never had a problem
with it running under wine.

The grey-ish screenshots on the author's site are ugly. Phonedeck
will look much better than that if you have themed your wine.
( Here is another explanation of how to theme wine. )

BFN.

musher0

_________________
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
View user's profile Send private message 
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Fri 27 Nov 2015, 23:21    Post subject:  

Hello all.

I found an interesting "fields.awk" script through ask.com:
http://www.ask.com/youtube?q=fields.awk&qsrc=1&o=0&l=dir&qo=serpSearchTopBox
and I thought I'd share the discovery. It is a simple universal flat file database. You
request a copy by e-mailing the author, Ian R. Forsyth. (His e-mail address appears in
the intro of the video.)

Judging from the video, you can adapt it to any collection (photographs, etc.) or follow-
up situation (car maintenance, etc.). The video explains quite nicely how to work with it.

BFN.

musher0
~~~~~~~~~~
PS. As greengeek pointed out to me here, this is the correct address for the
fields.awk video:
https://www.youtube.com/embed/HC8Az9W8FV4?rel=0&autoplay=0
Thanks, greengeek.

Last edited by musher0 on Sat 18 Jun 2016, 16:46; edited 1 time in total
Back to top
View user's profile Send private message 
Pelo

Joined: 10 Sep 2011
Posts: 12591
Location: Mer méditerrannée (1 kms°)

PostPosted: Sat 28 Nov 2015, 01:26    Post subject: Many have bugs, they are still free of charge
Subject description: To check a database, you need .... data !
 

i took a glance at awk videos. The guy speaks slowly enough to make me understand what he means.
What i want to underline, is that to judge a photo editor software, you must at least got one picture to work on it.
A database as for instance open concerto, you must at least enter one employee and give him existence to know if database works, only one ! That is not done...
Same for Laurux.. or GNUcash... How can you judge if a database has no bugs.
Many have bugs, that's the reason why they are still free of charge.
One serious guy is jopervasco from french forum. Beyond words, he acts.
SQLiteStudio last version is a real database, and Puppy can go with. Waiting for some customers... Really Windows users are more reliable, some even pay euros for using databases.
meute.jpg
 Description   A csv file is needed. Create it with Osmo, then, export it to your real database.
 Filesize   49.55 KB
 Viewed   725 Time(s)

meute.jpg

openconcerto.jpg
 Description   openconcerto need at least one employee. Please enter one to test.
 Filesize   37.5 KB
 Viewed   744 Time(s)

openconcerto.jpg


_________________
Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Back to top
View user's profile Send private message Yahoo Messenger 
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Sat 28 Nov 2015, 13:23    Post subject:  

Hi pelo.

As for me, I find OpenConcerto, Laurux, & Company, "overkill" for my
needs. I see no point in spending more time keeping the database up-to-
date than doing my actual job.

But you did work in very large concerns, and that's your frame of
reference. That's fine, but please do not think that all businesses need
BIG databases.

Thanks for your understanding.

BFN.

musher0

_________________
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
View user's profile Send private message 
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Sat 28 Nov 2015, 21:34    Post subject:  

Hello again all.

Regarding the fields.awk post above, here's a *.pet archive containing it.

This archive contains, in addition to the script, a launcher and a *.desktop
file, plus an icon that I've derived from one of Ian's illustrations. Those
don't make a "GUI" per se, but they do make launching the script from a
menu easier. A "lazy" user won't have to open a console and then launch
the database script, (s)he'll just click on the menu item to open it.

Depending on the categories activated in your Puppy, after installation,
you'll find the menu entry for the fields.awk script available either under
the "Personal" or the "Business" sub-menu.

I am joining a screen capture of the result. As you'll see I took the liberty
of adding a grey border and of using the DejaVuSansMono font, which is
already included in all Puppy distros, I believe (this way it doesn't weigh
down the *.pet archive any more than it needs to).

The *.pet also contains the author's permission to publish his script here,
under /usr/share/doc/fields.awk-1/. There is a short help panel available
by typing 'H' in the menu. If you need more, please remember to refer
to Ian's youtube video.

Finally, the jpg's at /usr/share/doc/fields.awk-1/ contain, near the top, Db
structures for receipts and car maintenance. You can recreate them and/or
use them as templates for other Db's.

Enjoy!

musher0
~~~~~~~~~~
(Edit, 2015-12-05.)
PS. I would be remiss not to mention that Ian R. Forsyth's attached
fields.awk script is licensed under GPL.
fields.awk.gz
Description  Although the exact same is in the attached pet, for reference, here is a g'zip of Ian
Forsyth's bash/awk DB script as I received it from him by e-mail Nov. 28, 2015.
gz

 Download 
Filename  fields.awk.gz 
Filesize  3.89 KB 
Downloaded  211 Time(s) 
fields.awk_15-11-28.jpg
 Description   
 Filesize   29.38 KB
 Viewed   696 Time(s)

fields.awk_15-11-28.jpg

fields.awk-1.pet
Description 
pet

 Download 
Filename  fields.awk-1.pet 
Filesize  160.01 KB 
Downloaded  208 Time(s) 

_________________
musher0
~~~~~~~~~~
Je suis né pour aimer et non pas pour haïr. (Sophocle) /
I was born to love and not to hate. (Sophocles)

Last edited by musher0 on Fri 17 Jun 2016, 23:49; edited 2 times in total
Back to top
View user's profile Send private message 
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Sun 29 Nov 2015, 01:55    Post subject:  

Hello all.

I just received this precision from Ian R. Forsyth, the author of the
fields.awk script:
Quote:
(...)
Also there is one small thing I wanted to mention as it might trip some
users up if not mentioned. That is the default labeling of all the
database files with .txt suffix. This could cause confusion in options S
(Select) and N (Create New). In the Select option the list of already
created database files is listed from which to select, and they all are
presented with their .txt suffix endings. But you don't include that in
your typed entry, just the name of the file.
If you also include the
".txt" the script will think you mean [basename].txt.txt since it
handles the suffix by default. The result will be reading of a NULL file
with no data. Similarly in the N option, when it asks for the name of
the new datafile you want to create, don't include the ".txt".
(...)
(Underlining by me).

BFN.

musher0

_________________
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
View user's profile Send private message 
gungsukma

Joined: 18 Sep 2011
Posts: 19

PostPosted: Sun 29 Nov 2015, 03:04    Post subject:  

SQLite must be good as Puppy database.
It is very small, it understands SQL, it is used anywhere,
may be you are using it now but you don't notice it.

The simplest way to use SQLite:
- install Firefox
- install add ons SQLite Manager
(Warning: just don't accidentally mesh your firefox database!)
Back to top
View user's profile Send private message 
Pelo

Joined: 10 Sep 2011
Posts: 12591
Location: Mer méditerrannée (1 kms°)

PostPosted: Sun 29 Nov 2015, 08:56    Post subject: I did it with OpenConcerto, and lot of questions arrive at t
Subject description: SQLite is enough
 

That's fine, but please do not think that all businesses need
BIG databases.
sure, i agree. Personally what would I do with a big Database.
I was thinking about our businessmen, not retired employees as me.
Nevertheless enter one record to check if everything runs as scheduled, wouldn't be a so big effort.
I did it with OpenConcerto, and lot of questions arrive at the top, mainly the taxes to be applied depending on items

The coach on the blackboard has easy task, People in the workshop hardly run this database.
The main thing generally is time spent doing task, spare parts to do it, and level of employees.
the cost is apart, because employees are not aware of how much the boss makes benefits on their labour. Gnu-cash is the tool for the girls at the budgeting department.

Somebody used to Microsoft Access would easily manage with Puppy databases.
SQLite is enough, included in browsers. and a majority of us use it, by importing CSV files from Gnumeric or Osmo,
AWK pet downloaded. It's a barebone database, really.

_________________
Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.
Back to top
View user's profile Send private message Yahoo Messenger 
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Wed 02 Dec 2015, 12:42    Post subject:  

gungsukma wrote:
SQLite must be good as Puppy database.
It is very small, it understands SQL, it is used anywhere,
may be you are using it now but you don't notice it.

The simplest way to use SQLite:
- install Firefox
- install add ons SQLite Manager
(Warning: just don't accidentally mesh your firefox database!)


Hello gungsukma and all.

The SQL superseded the DBF as the de facto database format
+/- twenty years ago. It gathered a lot of enthusiasts.

I'm not saying SQL is no good, problem is I still can't wrap my head
around it. I have smaller and simpler needs, like most people,
probably -- needs that are met with "good old" csv-type, so-called
"flat-file databases".

I find it easier to use join or combine on plain text files if I need to
establish some form of "relationship" between them or bring them
together. (String concatenation in a bash script may work too.)

~~~~~~~~~
Edit, 2015-12-05: That's why I find Ian Forsyth's "fields.awk" script
(above) interesting: it's quick to load, it's simple and to the point during
its operation, and it has no fancy commands or logic to remember.
~~~~~~~~~

Best regards.

musher0

_________________
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
View user's profile Send private message 
Colonel Panic


Joined: 16 Sep 2006
Posts: 2036

PostPosted: Mon 07 Dec 2015, 15:56    Post subject:  

musher0 wrote:
gungsukma wrote:
SQLite must be good as Puppy database.
It is very small, it understands SQL, it is used anywhere,
may be you are using it now but you don't notice it.

The simplest way to use SQLite:
- install Firefox
- install add ons SQLite Manager
(Warning: just don't accidentally mesh your firefox database!)


Hello gungsukma and all.

The SQL superseded the DBF as the de facto database format
+/- twenty years ago. It gathered a lot of enthusiasts.

I'm not saying SQL is no good, problem is I still can't wrap my head
around it. I have smaller and simpler needs, like most people,
probably -- needs that are met with "good old" csv-type, so-called
"flat-file databases".


I find it easier to use join or combine on plain text files if I need to
establish some form of "relationship" between them or bring them
together. (String concatenation in a bash script may work too.)

~~~~~~~~~
Edit, 2015-12-05: That's why I find Ian Forsyth's "fields.awk" script
(above) interesting: it's quick to load, it's simple and to the point during
its operation, and it has no fancy commands or logic to remember.
~~~~~~~~~

Best regards.

musher0


Me too, this is why I use PortaBase, which both imports and exports .csv files (Warren, aka WhoDo, produced an excellent pet of it a while back).

EDIT: DaveS's is more current;

http://puppylinuxstuff.meownplanet.net/DaveS/portabase/

_________________
Acer Aspire M1610 (Core 2 Duo, 2.3 GHz), 3 GB of RAM, 320 GB hard drive running Sparky 4.7 (32-bit), Emmabuntus 3.1.02, AntiX 17.2 (32-bit), Bunsen Labs Helium, CentOS 6.10, LXLE 14.04.5, Pardus 17.4, VLocity 7.2, CrunchBang Plus Plus and Mint Debian 3.
Back to top
View user's profile Send private message 
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Mon 07 Dec 2015, 17:49    Post subject:  

Quote:
Thanks for reminding us, Colonel Panic.

I noticed on the portabase site a "call for templates", so to speak. However I
could not find any portabase templates on the site. Would anyone know
where to find some? It'd make life easier for a few people, no doubt.

Thanks in advance. BFN.

About portabase: heads up! I had to un-install it on my LibrePup because
its Qt libraries prevented vlc and qupzilla from launching.

_________________
musher0
~~~~~~~~~~
Je suis né pour aimer et non pas pour haïr. (Sophocle) /
I was born to love and not to hate. (Sophocles)

Last edited by musher0 on Tue 08 Dec 2015, 13:11; edited 1 time in total
Back to top
View user's profile Send private message 
gcmartin

Joined: 14 Oct 2005
Posts: 6730
Location: Earth

PostPosted: Mon 07 Dec 2015, 19:48    Post subject:  

I know I will get some heat on this concern. And coming from the old school PUPPY user background, many will scream "size".

But, has anyone looked around at smartPhones/smartTablets. No matter which mature one you look at, there is a "common" database in it. In fact, you CANNOT program without using it ... at some point via direct/indirect knowledge.

If we started to look at DBs for a PUP,
  • Should we consider "future proofing" our selection?
  • Shouldn't it contribute to a skillset that is universal?
The DB mentioned mesh with scripts, compiled code, widgets, etc and those with skills in smartPhones/Tablets will be at home in PUPs which uses them.

In fact, @BarryK's development Puppy distro; namely Appril has it built in, OOTB.

If it is used, there is little to no need to re-invent skills.

Just a thought. I whole-heartedly (maybe whole-heatedly) support DB use for any/everything 10 items or more!!!

_________________
Get ACTIVE Create Circles; Do those good things which benefit people's needs!
We are all related ... Its time to show that we know this!
3 Different Puppy Search Engines or use DogPile
Back to top
View user's profile Send private message 
musher0

Joined: 04 Jan 2009
Posts: 12959
Location: Gatineau (Qc), Canada

PostPosted: Mon 07 Dec 2015, 23:46    Post subject:  

Hello, gc.

Borrowing Brahms reply to Wagner about music, I'll answer you:
"To the database of the future, I prefer the database that has one."

I don't see the value of deliberately making obsolete to users any
previous database format they may have stored their data in.

Unless of course you have a pricey database program to sell them.

BTW, man, looking at your recent posts, I am beginning to wonder:
"Are you on a campaign to bring down anything of traditional value in
computing?"

Your comments about touch screens, now this. You're still a good
Puppyist, but geez...

Don't impose your own views on the future, man, just let it become.

BFN.

_________________
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
View user's profile Send private message 
gcmartin

Joined: 14 Oct 2005
Posts: 6730
Location: Earth

PostPosted: Tue 08 Dec 2015, 03:47    Post subject:  

Sorry @Musher0. As you know it is not meant to either offend. I only bring up the DB issue as I am looking at an industry pattern where I think it may be overlooked in its value. And, I see it as consistent with what your topic is drawing attention to. All DB products, that I am aware of, provide import-export/mapping abilities so that extracts for whatever reason are useful.

None of what I refer to is closed-source, proprietary, or commercial. That mentioned DB is open-source and anyone, using @BarryK's distro can create applications, even DB applications, which run on smart devices as well as Puppy Linux.

And, I am not trying to suggest that past technologies are not good technologies. I was a big dBase user back in the day, as well as DOS, as well as ... well you know.

My comments were to bring awareness.

_________________
Get ACTIVE Create Circles; Do those good things which benefit people's needs!
We are all related ... Its time to show that we know this!
3 Different Puppy Search Engines or use DogPile
Back to top
View user's profile Send private message 
amigo

Joined: 02 Apr 2007
Posts: 2641

PostPosted: Tue 08 Dec 2015, 07:20    Post subject:  

The 'mentioned DB' -thus mentioned twice, has yet to be named... 'you CANNOT program without using it'... Oh my! Just what is this thing you mention?
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 12 of 19 [272 Posts]   Goto page: Previous 1, 2, 3, ..., 10, 11, 12, 13, 14, ..., 17, 18, 19 Next
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Cutting edge
Jump to:  

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
[ Time: 0.1127s ][ Queries: 13 (0.0271s) ][ GZIP on ]