Puppy Database

Under development: PCMCIA, wireless, etc.
Message
Author
Pelo

newer version needs Qt5.

#226 Post by Pelo »

newer version needs Qt5. I think training with Qt4 version until somebody compiles QT5 is a good idea. Some prefer compiling than adding data in already existing database. That does not make such a progress. :!:
What database do you need ? Your home furniture, your car repairs, Your friends and their phone, Your customers, your pending posts in the forum, everything is already available, but needs some work . Barry Kauler asked some help from everybody about the pets, but our Puppy builders are so occupied to build their own puppies from Woof Ce.
Post scriptum :
If furthermore you run our wonderful Polar Qt005 build with so much care by Pemasu, no Qt SFS had to be added.
Nevertheless, i will feed back when my version 2.1 ready. I hate Dropbox.

To be done with Xenialpup 7.0.2.
Version 2.0
===========

[New Features]
- #11 #12 #16 New fields for web links and email addresses

[Improvements]
- Migration from Qt4 to Qt5 (User interface library)
- Updated Dropbox certificates (Old ones are valid until August 2016)
- Implemented database version checking and upgrading on format change
- Updated about dialog to include github project link
- Compiler warning fixes

You Tube Demo
Attachments
Kittel.jpg
Marcel Kittel
(74.01 KiB) Downloaded 502 times
Symphytum.jpg
My personal database for pets (For Puppies, i use OSMO, considering Puppies as persons)
(71.72 KiB) Downloaded 858 times
Last edited by Pelo on Tue 04 Apr 2017, 17:33, edited 2 times in total.

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#227 Post by smokey01 »

I have a version 2.0 in my Fatdog64-700 repo. It does need the qt5-common package as well. http://smokey01.com/fd700/packages/ Are there any difference between 1.2 and 2.0? I didn't notice any.

Pelo did you say you have a version 2.1 of symphytum coming?

BTW thanks for the tip on TreeSize. I like it but it's a bit unstable when clicking on the Reload or skip directories buttons.

Pelo

Exploring for Symphytum newer version for linuxian colleage

#228 Post by Pelo »

Exploring for Symphytum newer version for linuxian colleages caring of having on self latest version.
personnaly i have been using version one for three years without trouble. I entered some records for my own usage.
With Xenialpup 7.0.2 the final answer is that a driver is missing. Symphytum 2.0 refuse to restore my backup done with version 1

For people still having Windows beside Puppy Linux, taste Windows version to see what you could miss running version one with Puppy Linux.
I believe i was the only Puppy passenger having run Symphytum in the forum. Perhaps it's no worth loosing time..
Xenialpup still has some trouble with desktop. Everybody is busy.. in the electronic bulk.
Last edited by Pelo on Sat 18 Mar 2017, 00:22, edited 1 time in total.

Pelo

i just took a glance at your fatdog 64 repository.

#229 Post by Pelo »

i just took a glance at your fatdog 64 repository.
With Puppy i decided to run only 32 bits.
Smokey01, i want to thank you here for your works. How often i found happiness in your stores :)
A database manager, again, a new one is born in QT5 PPM Xenialpup... you should not miss databases to fulfill in 2016 !
Screenshot Table created in five minutes importing data from .packages (tahrpup). You can do the same with OSMO (rename columns thru file .mo)
Attachments
DB browser.png
I prefer Symphytum, for the fun.
(46.32 KiB) Downloaded 746 times

Pelo

Symphytum is no longer free.

#230 Post by Pelo »

Symphytum is no longer free. you must pay for it, at least for Windows version (checked yesterday)

User avatar
Colonel Panic
Posts: 2171
Joined: Sat 16 Sep 2006, 11:09

#231 Post by Colonel Panic »

Has everyone else given up on Portabase now? It may be more limited than other databases but I still use it, and perfectly contentedly. (BTW, yes it can import .csv files - that was how I created the data files I use in it now).
Gigabyte M68MT-52P motherboard, AMD Athlon II X4 630, 5.8 GB of DDR3 RAM and a 250 GB Hitachi hard drive running Ubuntu 16.04.6, MX-19.2, Peppermint 10, PCLinuxOS 20.02, LXLE 18.04.3, Pardus 19.2, exGENT 200119, Bionic Pup 8.0 and Xenial CE 7.5 XL.

Pelo

ToOpPy Linux, a Precise Puppy 5.7.1. portabase as Database

#232 Post by Pelo »

Argolance has included POrtabase in its brand new ToOpPy Linux, a Precise Puppy 5.7.1.

slavvo67
Posts: 1610
Joined: Sat 13 Oct 2012, 02:07
Location: The other Mr. 305

#233 Post by slavvo67 »

Has everyone else given up on Portabase now?
Looks like Portabase hasn't been updated in about 4 years. Old isn't necessarily bad but looks like it's no longer being developed....

User avatar
Colonel Panic
Posts: 2171
Joined: Sat 16 Sep 2006, 11:09

#234 Post by Colonel Panic »

Thanks for your replies. Portabase for Debian doesn't look like it's being actively developed either (it's still at version 2.1).

I'm only dimly aware of ToOpPy Linux but I may check it out if I get the time soon.
Gigabyte M68MT-52P motherboard, AMD Athlon II X4 630, 5.8 GB of DDR3 RAM and a 250 GB Hitachi hard drive running Ubuntu 16.04.6, MX-19.2, Peppermint 10, PCLinuxOS 20.02, LXLE 18.04.3, Pardus 19.2, exGENT 200119, Bionic Pup 8.0 and Xenial CE 7.5 XL.

Pelo

portabase is one of the worse

#235 Post by Pelo »

portabase is one of the worse, IMO, CSVpad does better :)

Pelo

Symphytum topic in Business section

#236 Post by Pelo »

Symphytum topic in Business section Take a glance here
Attachments
deb.jpg
Trouble With That Version
(46.38 KiB) Downloaded 400 times

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#237 Post by smokey01 »

@musher0, some time ago you posted about fields.awk pet.
http://murga-linux.com/puppy/viewtopic. ... 741#874741
I just tried this again in Fatdog64-710 and it failed to add or modify a record. I'm pretty sure the attached is you original pet you provided. I couldn't find it from your post so I have attached it below.

I'm not sure if this is a Fatdog problem or I missed it before. After pressing enter on the last field when adding a record the terminal closes. Have you experienced this?

Cheers
Attachments
fields.awk-1.pet
(160.01 KiB) Downloaded 134 times

musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#238 Post by musher0 »

Hi Smokey.

I must confess I haven't used Ian's fileds.awk in a while.

I just tested it again. I changed the word "Duo" to "Duet" in the little CD.txt
database that's included in the pet, without any problem.

But fields.awk refused to edit anything before I selected an editor. I chose
leafpad as editor, and after that I was able to do what I wanted. Ian has
set the default editor to vim, we have to change it, we don't have vim on
Puppy.

Tell me how it goes?

BFN.
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#239 Post by smokey01 »

@musher0, found the problem.

I had a directory called tmp in /root that was created by another app. This prevented touch from creating a file called tmp in /root.

It's working again. Better yet my modified version is working.

musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#240 Post by musher0 »

Excellent ! :)

Modified version ?
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#241 Post by smokey01 »

Yeah the original version menu wasn't in a very logical order and the terms used didn't make much sense, not to me anyway, so I changed it.
Attachments
old.png
The original version
(16.61 KiB) Downloaded 1406 times
new.png
My modified version
(17.86 KiB) Downloaded 1366 times

User avatar
6502coder
Posts: 677
Joined: Mon 23 Mar 2009, 18:07
Location: Western United States

#242 Post by 6502coder »

smokey01 wrote:@musher0, found the problem.

I had a directory called tmp in /root that was created by another app. This prevented touch from creating a file called tmp in /root.
I noticed this too when I played with fields.awk. It's one of the first things I changed. Applications writing temporary files in the user's home directory is a BIG NO-NO in my book. That's what /tmp is for!

User avatar
greengeek
Posts: 5789
Joined: Tue 20 Jul 2010, 09:34
Location: Republic of Novo Zelande

#243 Post by greengeek »

6502coder wrote:
smokey01 wrote:@musher0, found the problem.

I had a directory called tmp in /root that was created by another app. This prevented touch from creating a file called tmp in /root.
I noticed this too when I played with fields.awk. It's one of the first things I changed. Applications writing temporary files in the user's home directory is a BIG NO-NO in my book. That's what /tmp is for!
But wouldn't the same problem have occurred if the file already existed in /tmp? The way I read it the problem is the failure to detect if the file already exists (and choose a different file name or location if so...). Doesn't matter where the file already exists - the question is what to do about that.

User avatar
6502coder
Posts: 677
Joined: Mon 23 Mar 2009, 18:07
Location: Western United States

#244 Post by 6502coder »

Well, first off, touch simply changes the timestamp on a file -- it doesn't matter whether the file already exists or not -- so there shouldn't have been a permissions problem, unless maybe some of that shady spot/fido business was involved.

Secondly, the shell provides mechanisms for making unique temporary file names, and that's what I always do. The mktemp command is probably the best way, but being old-school I usually use the classic method of including $$ (the process ID) as part of the file name.

musher0
Posts: 14629
Joined: Mon 05 Jan 2009, 00:54
Location: Gatineau (Qc), Canada

#245 Post by musher0 »

Hello everyone.

Have we forgotten that all Puppies have on board THE very powerful
sqlite3 database processor? ;)

Now that we're reminded, the next thing we lazy bones must do is learn
the sqlite language! :lol:

This one-liner will call it as a stand-alone window, like in the attached pic.

Code: Select all

urxvt -bg snow -fg "#432D1E" -g 90x28 +tr -cr orange -bd orange3 -b 20 -e sqlite3
You may fiddle with it as you like.

Please remember that If you use the above line in a script or make it into
a string, the foreground color ( -fg ) will have to be written '\#432D1E'. As
a general rule, in such situations, the # character of any hex color needs
to be escaped.

BFN
Attachments
sqlite3-on-Puppies.jpg
(54.11 KiB) Downloaded 1221 times
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

Post Reply