What database software can we use in Puppy?

Business software, financial software, etc.
Message
Author
muggins
Posts: 6724
Joined: Fri 20 Jan 2006, 10:44
Location: hobart

#46 Post by muggins »

I don't use databases myself, but two possible alternatives to portabase are:

QT4 based symphytum, and GTK based muibase

Pelo

Mighty Query runs Slacko 5.5

#47 Post by Pelo »

MightyQuery is a single user SQL database management software working with data stored as comma separated values (.csv, .txt) in plain, flat, textual files. It is serverless, self-contained, simple and effective SQL DBMS for querying CSV files. In contrast to most database systems, MightyQuery does not require neither server installation, neither external libraries.
Though there are other database solutions that can process single textual file, MightyQuery is distinguished from them by its SQL engine, by which you can query and modify CSV tables with power that is normally reserved for huge enterprize-level SQL engines.
If you need to process heterogenous business data exported from various enterprize ERP, MRP, Data Warehouse, Accounting or other database systems, MightyQuery could be your solution. It is, also, suitable for managing simple personal databases, in cases where installing and managing complicated SQL servers is overkill for you.
To enable processing of external data, Mighty Query contains importing utility, supporting wide range of SQL database servers, such as: PostgreSQL, Interbase, Firebird, MSSQL, Sybase, SQLite, Oracle, ado, ASA.

MightyQuery is developed by using Lazarus Free Pascal RAD IDE (www.lazarus.freepascal.org) and zmsql package (http://www.4shared.com/account/dir/3Cw6 ... r=94126104; http://lazarus.freepascal.org/index.php ... l#msg74492).
ZMSQL package is based on TBufDataset and JanSQL database engine, which original code is written Jan Verhoeven (http://jansfreeware.com) and released under MPL 1.1. license.

You can download MightyQuery's source code and binaries from:
http://matalab.freehostia.com
Last edited by Pelo on Fri 13 May 2016, 03:17, edited 1 time in total.

User avatar
charlie6
Posts: 1230
Joined: Mon 30 Jun 2008, 04:03
Location: Saint-Gérard / Walloon part of Belgium

#48 Post by charlie6 »

Hi,
muggins wrote:I don't use databases myself, but two possible alternatives to portabase are:

QT4 based symphytum, and GTK based muibase
MUIbase requires gtk+v3.4 ...

on a fresh pristine dpup-wheezy_3.5.2.11 install: it has embedded gtk+3

Just got a quick install of the MUIbase deb archive: it seems to run OOTB (no claim for extra dependency addition).

Good news: there are both french and german locales :D;
as also an embedded html tutorial !

I'll try to define a table when I'll get more free time, maybe this coming winter... :?

Regards, Charlie

User avatar
Dingo
Posts: 1437
Joined: Tue 11 Dec 2007, 17:48
Location: somewhere at the end of rainbow...
Contact:

#49 Post by Dingo »

maybe portabase 2.1 made stand-alone (built with static qt 4.7.3 libs and then packaged as stand-alone application) can be worthy to be considered?

http://dokupuppylinux.info/stand_alone_ ... :databases

tested in Puppy linux from 5.2.5 to 3.01 (theoretically it runs into any Linux environment), without dependencies needed

portabase 2.1 also supports html export
replace .co.cc with .info to get access to stuff I posted in forum
dropbox 2GB free
OpenOffice for Puppy Linux

User avatar
Dingo
Posts: 1437
Joined: Tue 11 Dec 2007, 17:48
Location: somewhere at the end of rainbow...
Contact:

#50 Post by Dingo »

muggins wrote:I don't use databases myself, but two possible alternatives to portabase are:

QT4 based symphytum, and GTK based muibase
I built symphytum 1.2 with qt 4.7.3 static libs

http://dokupuppylinux.info/stand_alone_ ... mphytum_12

no dependencies needed, hopefully working in any puppy version
replace .co.cc with .info to get access to stuff I posted in forum
dropbox 2GB free
OpenOffice for Puppy Linux

Pelo

database medicinal : Puppy's Memory disease

#51 Post by Pelo »

I shall try it with polarpup QT. I suppose we can change column' names,
Databases are daily used at office; More than generic office suites. The challenge is adapting them to personal needs.
Create a new collection.
Collections group your structured data together.
Before you begin to enter data, you need to define at least one input field.
Input fields have a data type (text, numeric, image...) and delineate how data is presented and inserted.
You can add an unlimited amount of fields.
The structure of a collection can be modified at any time.
Once the data structure is defined, you can start to add as many records as you wish.
Records are data entries of your collection, they can be modified, deleted and duplicated
Attachments
forum.jpg
Database of people, dead.. or alive (Gramps)
(68.47 KiB) Downloaded 788 times
Last edited by Pelo on Fri 13 May 2016, 03:07, edited 2 times in total.

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

#52 Post by musher0 »

Dingo wrote:
muggins wrote:I don't use databases myself, but two possible alternatives to portabase are:

QT4 based symphytum, and GTK based muibase
I built symphytum 1.2 with qt 4.7.3 static libs

http://dokupuppylinux.info/stand_alone_ ... mphytum_12

no dependencies needed, hopefully working in any puppy version
Hi, Dingo.

Thanks for this symphytum package. Looks interesting.

However I get an error when I try to run it. (Please see attached picture.) How can I correct this error?

The Puppy I tried it on is Puppy Precise 5.4.3 "CanBike".

Thanks in advance and best regards.

musher0
Attachments
symphytum-standalone.jpg
(60.72 KiB) Downloaded 1270 times
musher0
~~~~~~~~~~
"You want it darker? We kill the flame." (L. Cohen)

Pelo

head-ache (mal de tête) prenez symphytum package

#53 Post by Pelo »

I shall try it with Tahrpup, the brand new QT Puppy i shall look at the PPM if Sumphytum if available (for french druids)
Loaded from archives.org pets here
I must change my pendrive (i'm running an old Racy 5.3)
That is done, and symphytum runs without adding anything in my Tahrpup puppy. Qt and python stuff is included in that distro.
And so does Symphytum in LXPUP Qt issued december 2014
Last edited by Pelo on Tue 17 Mar 2015, 09:09, edited 2 times in total.

Pelo

LXPUPQT 14.02 now installed at home

#54 Post by Pelo »

You can move Gui where you like on the page, resize them, rename, add, or delete fields, so easily :)
Last edited by Pelo on Fri 13 May 2016, 03:05, edited 2 times in total.

Pelo

MUIbase The bee will not fly Puppy

#55 Post by Pelo »

libgtk-3 libgdk-3 missing
Puppy will not use GTK3. Finished.

Pelo

DPUP SQUEEZE miss LibQtSvg.04 to run Symphytum

#56 Post by Pelo »

libQtSvg.so.4: cannot open shared object file: No such file or directory
#
My developers are searching... I'am afraid they will not find it.
That was just to see how easy is Symphytum to install. It's the first failure. :oops:
Gui's for apps are often sad. Symphytum brings some Joy not only with medecines but for pleasure of playing Puppy Linux, by a nice sunny afternoon. Is'it ?
"It would be the package managers job to find the packages that provide those files. This would be incredibly easy for the package manager" said the haikipup vietnamese conceptor in 2010. I Agree.
https://packages.debian.org/wheezy/libqt4-svg on try

Pelo

blitz is the name in germany

#57 Post by Pelo »

blitz is the name in germany
Sales force is the english one.
camsegscm is the Linux apps (Qt)
Attachments
Blitz.jpg
Puppy ASRI edu 310 version beta runs it easily
(60.73 KiB) Downloaded 1061 times

Pelo

SQLiteStudio Vividpup 6.5

#58 Post by Pelo »

SQLiteStudio Vividpup 6.5 vesion from the web installed today. Nothing to say, just Fullfill columns, by importing a CSV file from OSMO.
Attachments
SQliteStudio.jpg
version 3.0.6
(85.48 KiB) Downloaded 940 times

Pelo

MightyQuery to fullfil

#59 Post by Pelo »

MightyQuery to fullfil. None of my employees had even added one record ! they told me mys Slacko 5.5 is too old, and hat didn't found any help on forums about building the database..
Thats is true that windowsians use more databases than Linux, but Puppy is free of charge, and windows is a lot of money.
If people here really use data base, please contact me..
Libre-Office is very popular in Puppy, and seems to satisfy anybody...

Pelo

Portabase

#60 Post by Pelo »

Portabase now included in some puppies as defaut database. Try it and feed back ! I don't like Portabase, but it's not a reason... CSV cannot be imported, what a pity

Post Reply