Aug 282013

Today I want to present you a commercial application, Symphytum, it’s developed by giowisys and it costs around 9$ (or 6.7 €), but what can do this application for you ?

Symphytum is a personal database software for everyone who desires to manage and organize data in an easy and intuitive way, without having to study complex database languages and software user interfaces.

In fact collecting data is part of our lives, however, organizing information is not always easy, especially without the right tools. While big companies use notable database management systems with advanced functionality and tailored procedures, many people are still using spreadsheets as a database replacement for personal use, because of its simplicity.

Symphytum it’s something much better than a spreadsheet without all the problems that you could have in managing a real database such as Mysql or Postgresql it’s a simple application that can be used to create, design and manage a database with a look similar to the program iDatabase for Mac Osx.

Symphytum comes to help as a general-purpose solution to design and manage any kind of database or collection of information.
With it you can design input forms, move and resize fields thanks to the dynamic layout engine.

It’s possible to define the database fields as text, numbers, images, files and other control fields.

Basic usage

This is a short guide of what you can do with Symphytum to create a new personal database:

1) Create a new collection, this is in Symphytum a group your structured to put data together.
To create it just click the icon in the upper left area of the window


And give a name to your collection, I named it Linuxaria.

2) Now you have an empty collection with no structure at all, so now you must define the fields, click on “New Field”


3) Now you can define the first field, input fields have a data type (text, numeric, image…) and delineate how data is presented and inserted.

In my example I’ve create a simple table with 4 fields:

Name -> Text Field required
Surname -> Text Field required
Date of birth -> Date Field
Photo -> Image Field

You can review your fields clicking on the table tab


4) Now you can start to populate your collection, to do this click on “New record”, you should see something to the following image:


The fields with a red background are the one marked as “required” during their creation, you can insert the information in the “Table” view or in the “Form” view:


These are the basic function for create a collections and adding records, you can always “Search” in your collection with the search form located in top right of the window.

As plus it’s possible to save your data into the cloud with the dropbox plugin to enjoy hassle-free automatic synchronization on all your computers.

Technical Information

The official package on the website it’s a .deb for Ubuntu 12.04 (there is a version for 32 and 1 for 64 bit), I’ve tested the program on Mint 15 (Aka Ubuntu 13.04) without any problem.

The underlying database is provided by the SQLite database management system, which is the leading embedded database solution, used in many mobile apps and modern computer programs, like web browsers, media players and email clients.

SQLite is tiny, efficient and very fast. It can handle huge amount of data while being highly resistant to data corruption and it doesn’t require a daemon always running to work.

Popular Posts:

Flattr this!

  12 Responses to “Symphytum, a Personal database for Linux”

  1. Interesting. Maybe you can compare it to portabase. That was one of my favorite simple database programs from the zaurus (and now mac/win/debian/nokia n900).

  2. Just read on their homepage that the company who wrote the software is undergoing liquidation. It’ll be interesting to see what they do with the sources, hopefully release it under a FOSS compatible license or form a new company and continue development…

  3. prima di procedere all’acquisto un paio di domande a chi lo ha provato:
    supporta “le relazioni”? ovvero è possibile importare i dati di una seconda tabella? ad es. autori – titoli
    secondo: come gestisce i link alle immagini fuori dal db?


    • In efeftti non ti so rispondere, ho fatto solo qualche test per vedere come funziona, però ti consiglio di scaricare la demo, che altro non è che la versione completa utilizzabile per 14 giorni, in questo modo puoi fare tut syesso le prove e vedere se fa quello che ti serve.


  4. Looks nice, but releasing binary Linux packages in. deb only format is very annoying. Half the Linux installed base is excluded. The least they could do is use alien to make an. rpm package.

  5. I’m using Symphytum on Mac OS 10.7.5 and it’s working great! It is (almost) everything I would want for keeping track of a lot of data concerning a novel I am writing (character info, backstories, etc.). However, I am worried because the developer doesn’t seem to be around anymore. My backup is working fine and it syncs a .db file to my Dropbox account. I’m just feeling a bit leery of storing all my important data in this if the company is about to go away. I’ve tried opening the .db file in excel to see if at least the data could be retrieved if Symphytum stopped working, but it was all a garbled mess.

    Has anyone heard from Giowysis lately? I tried emailing them a few days ago but got no reply.

  6. I emailed them as well, but sadly, I got no reply. I wanted to know if the software will be maintained when the liquidation of the company has ended, or if there are plans to make the thing open source…

    I’d relly like to see more programs of this kind.

  7. Now that this company is being liquidated, how do I uninstall this database? First, Ubuntu does not authorize this software, so it won’t auto-update, and second it requires the software be installed under Windows 7. I just checked the registry editor, and it did not find anything under Symphytum! Can someone please tell me how to remove this package from Ubuntu?

  8. Puppy linux has a package for it (see forum anglophone or google : puppy forum symphytum)

  9. FOSS symphytum is still available and is working great

  10. NEW: using 14.04?
    Do NOT upgrade to v 2.0!
    There will be an error like : symphytum: /usr/lib/x86_64-linux-gnu/ version `GLIBCXX_3.4.21′ not found (required by symphytum)

    Save the upgrade for a dist-upgrade to 16.04

  11. Nice database easy to create and modify, just draw the report to show data as you want (installed Puppy Linux) Needs QT.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>