Flamerobin New snapshot 0.9.3.2210.* builds

New snapshot builds (SVN revision 2210) for Windows 32 and 64 bits are
available on SF.net.

Feedback on field and text delimiter settings for save grid data as CSV
file command would be especially welcome.

Thanks

--
Michael Hieke

Trying to insert more that 350MB blob (from file to firebird) ? use #FlameRobin

Via Jiri Cincura tweet we find that works ok to insert more that 350MB blobs with flamerobin

Trying to insert ~350MB blob (from file) using #FlameRobin. Hope it's not going to fail.

and then later

It went absolutely fine. I was pleased.

flamerobin-devel archive is now on new nabble

You can read the threads and react/post quickly to flamerobin-devel mailing list from a better interface

http://flamerobin.2305948.n4.nabble.com/

Quicken home inventory for windows 7 64 bit

What's has this got to do with FlameRobin, you might ask. Well, as few customers of mine wanted to be able to look into their home inventory database with FlameRobin. They are using a program called Quicken Home Inventory which was really popular back in a day. Now they moved to Windows 7 and other 64 bit operating systems (even Linux) and they were left in the dark. This is also a nice story of Microsoft SQL server users converting to Firebird, even if they don't know it.

My program Attic Manager uses Firebird database as backend. This means that it can run on Windows, Linux, 32 or 64bit and still have a very small footprint of only 3MB of download. The main obstacle was ability to import QHIM data into Attic database. I thought about ODBC but gave up soon. Microsoft .NET is much easier and I wrote a nice little extractor program that dumps data from MS SQL Server to text files, and Attic Manager loads that in turn.

And one can even browse data in FlameRobin, which is of course, free.

Statement history dialog layout

In the past week or so I have improved our statement history dialog to allow easier browsing. Now it shows the statements on the left and when you click them, you get the whole sql on the right. This makes it easier to inspect the statements and find what you looking for. Especially if you have a large monitor. Also, the searched term is marked with red color. I also added the timestamp of the history file. Functionality is now good, however, now I'm not sure about this layout. What do you think? (screenshot attached) -- Milan Babuskov

Suggestion: copy as in-list implemented

Kjell Rilbe asked if such a feature can be added and Millan already added it in the copy menu 

Manage your TurboCASH databases with FlameRobin

The FlameRobin Database Admin Software is used to manage your TurboCASH 4 databases (Sets of Books). The FlameRobin software is used to browse, check and edit data
Read more on Turbocash Wiki

#flamerobin Tweet of the day Very lightweight and easy to handle.

Translation of the tweet:

"Flamerobin admin #firebird database. Very lightweight and easy to handle. good megusta"

Or in Spanish:

Flamerobin database admin #firebird. Muy ligero y facil de manejar. #megusta #good

Installation guide for Flamerobin 0.9.3 - r2100 Snapshot binary on #Ubuntu 10.10 or in Natty

Download the binary for your platform from debian repository
uname -m
in my case is x64 (aka amd64, intel 64, x86-64) Usually if you double click gdebi will do the
work bellow for you (graphic installer)


wget http://http.us.debian.org/debian/pool/main/f/flamerobin/flamerobin_0.9.3~svn+2100-1_amd64.deb
sudo dpkg -i flamerobin_0.9.3~svn+2100-1_amd64.deb

From system menu (in my case Lubuntu Natty ) Programming -> Flamerobin

or you can start it from the console
flamerobin&

New Flamerobin snapshot in #debian unstable

The main change is that now it requires firebird2.5-dev instead of firebird3.0 headers and decided that is better to  have a flamerobin 0.9.3 in the distros released for the next 1-2 years with a stable firebird 2.5.x and add firebird 3.0 requirement when is ready and stable ~1-2 years
Changelog:
* New upstream SVN snapshot : revision 2100
* Uploaded to unstable
* Stop using system-wide ibase.h.Unstable has no fb3.0 so system-wide ibase.h has no boolean defines,which are used by FR and were ported to IBPP's embedded copy of ibase.h
* build-depend on firebird2.5-dev instead of firebird-dev(firebird-dev is only in experimental)

You can download and install the package directly from debian sid (tested and works on ubuntu natty too )
http://packages.debian.org/sid/flamerobin

Flamerobin 0.9.3 svn new revision pushed to Debian experimental

new version for flamerobin 0.9.3 is now in Debian experimental for testing
http://packages.debian.org/experimental/flamerobin

I have installed debian unstable sid and i have added in

/etc/apt/sources.list

these lines

deb http://ftp.us.debian.org/debian/ experimental main
deb-src http://ftp.us.debian.org/debian/ experimental main

and install flamerobin

$ su
# apt-get update -t experimental
# apt-get install -t experimental flamerobin

maybe you need an firebird 2.5 super or classic

apt-get install -t experimental firebird2.5-classic

if you want to build the latest version on any ubuntu/debian distribution i have wrote some notes in the wiki here
http://flamerobin.org/dokuwiki/doku.php?id=wiki:howtobuildonubuntudebian
I guess it's easy to create a binary tar.gz/bz2 snapshot
also i will try to put the package into a ppa



..:: FlameRobin ::..:: Firebird ::..

#Flamerobin 0.9.3 Snapshot 2092 is already in #Debian experimental

Flamerobin 0.9.3 Snapshot 2092 is ready in Debian experimental repository
Here is the guide to install it from repository , you can also download the binary package only if you are on sid

Installation guide for Flamerobin 0.9.3 - r2092 Snapshot binary on #Ubuntu 10.10 or in Natty

Download the binary for your platform from debian repository
uname -m
in my case is x64 (aka amd64, intel 64, x86-64)
wget http://ftp.us.debian.org/debian/pool/main/f/flamerobin/flamerobin_0.9.3~svn+2092-1_amd64.deb
sudo dpkg -i flamerobin_0.9.3~svn+2092-1_amd64.deb

From system menu (in my case Lubuntu Natty ) Programming -> Flamerobin

or you can start it from the console
flamerobin&

Svn updates and fixes

Michael commited this fix :
Don't remove database trigger type when creating ALTER TRIGGER statement (fixes SF.net bug tracker item #3188253)
And another one:
Quote name of trigger relation if necessary when creating DDL (addresses second point of SF.net tracker bug #3237718)

Installation guide for Flamerobin 0.9.3 - r2048 Snapshot binary on #Ubuntu 10.10

Download the binary for your platform from debian repository
uname -m
in my case is x64 (aka amd64, intel 64, x86-64)


wget http://http.us.debian.org/debian/pool/main/f/flamerobin/flamerobin_0.9.3~svn20101024r2048-1_amd64.deb
sudo dpkg -i flamerobin_0.9.3~svn20101024r2048-1_amd64.deb

From system menu (in my case Lubuntu 10.10 ) Programming -> Flamerobin

Update: new snapshot available 2092 please use that version

Flamerobin compiles just fine with Clang++

Thanks to Michael patches now Flamerobin compiles without errors with clang++ also seems that it works just fine ;)

export CXX="clang++"
./configure --prefix=/opt/flamerobin
make ; make install

For Testers only : FlameRobin 0.9.3 snapshots for #Windows

We have now Flamerobin 0.9.3 SVN revision 2048 snapshot files for Windows 32 and 64 bits, both setup and ZIP files. Enjoy, and please be sure to report any bugs, regressions or suggestions on flamerobin-devel list.

#Flamerobin new build dependency graph for #debian #ubuntu / #kubuntu #linux

Dalton asked on Flamerobin-devel list

> Can someone please do a series of build requirements for ubuntu/kubuntu
> environments?

here are listed the new dependencies (for svn versions > 0.9.3)
with boost included
http://packages.debian.org/source/experimental/flamerobin

all you need

apt-get build-dep flamerobin 

and then you need to add boost manually


The following NEW packages will be installed:
firebird2.1-common-doc firebird2.1-dev libwxbase2.8-dev
libwxgtk2.8-dev wx2.8-headers

also you need svn to checkout the source

apt-get install subversion

maybe is needed to add the boost devel headers :)

apt-get install libboost-dev

svn co http://flamerobin.svn.sourceforge.net/svnroot/flamerobin/trunk flamerobin_trunk
cd flamerobin_trunk/flamerobin
./configure 
make -j2

make install

ps: you can generate the dependecy tree with debtree

debtree --max-depth=2 --build-dep --no-conflicts flamerobin  > out.dot
dot -T png -o flamerobin.png out.dot
dot -T svg -o flamerobin.svg out.dot

..:: FlameRobin ::..:: Firebird ::..

#Flamerobin mention in Revista Espírito Livre – Instalação do #Firebird e Flamerobin no #Debian

After seeing that the Firebird community is growing, as site sourceforge, I decided to write a tutorial on installing firebird and flamerobin in debian.

DOWNLOAD ISSUE 14 - MAIO/2010

In issue number 13 I talked a little about the Firebird. In issue number 14, I wrote this tutorial targeted for new users of this database.

http://fernandomedeiros.com.br/blog/revista-espirito-livre-instalacao-do-firebird-e-flamerobin-no-debian/

http://www.scribd.com/doc/36583743/Instalacao-do-Firebird-e-Flamerobin-no-Debian


Instalação do #Firebird e Flamerobin no #Debian


..:: FlameRobin ::..:: Firebird ::..

#Flamerobin Screenshots at packages.debian.org | #Debian | #Ubuntu

There are some nice Flamerobin package screenshots at debian

Via debian news :"As it is often easier to get an impression of an application by looking at screenshots, instead of just reading a descriptive text, Gerfried
Fuchs has integrated the screenshots.debian.net service into the
package information at packages.debian.org"

..:: FlameRobin ::..:: Firebird ::..

New Flamerobin snapshots revision 1917

Michael posted new Flamerobin snapshots and announced on the devel list

I have posted new FlameRobin snapshots, SVN revision 1917, for Windows
32 and 64 bit, both installers and ZIP files.

The Refresh command is implemented now for databases, database
collections of views, triggers and so on, and for a few of the objects.
I hopefully didn’t break too much in the process, but since there have
been quite a few changes testing is very much needed. I’d also be
interested in whether FR appears to you to work any faster.

If you want to build FR, please take note that it requires some of the
Boost libraries now, but header-only ones only so there shouldn’t be big
problems. On Windows it was a simple matter of downloading and
unpacking the Boots libraries, and adding the environment variable
BOOST_ROOT.

I also succeeded with building on Ubuntu, where installing the Boost
libraries is just a simple apt-get. Since the headers are then part of
the core system no changes to the configure etc. files were necessary,
but this should definitely be done to allow for using non-system Boost
version by using a –with-boost=… switch to configure. Help with that
(or in general with overhauling the Unix build environment, to properly
detect the Firebird and Boost versions available) would be very welcome.

..:: FlameRobin ::..:: Firebird ::..

New Windows 32 and 64 Flamerobin 0.9.x Snapshots

Hi all,

after quite a long time I have uploaded a new snapshot for Windows (32
bit, and 64 bit).

I'd be glad if you could check this out and provide feedback. Things to
watch out for:

- Newly reserved words of 2.x FB versions should be highlighted now and
quoted if used as column names and the like, please report if any are
missing.

- New menu command in SQL editor frame to set transaction lock
resolution (wait / no wait).

- Modifying column properties should no longer modify the name unless it
was explicitly changed.

- "SELECT FROM ..." for tables and views and "EXECUTE ..." for
procedures should now create statements with the keywords upper- or
lower-cased as specified in the preferences, and which should be
line-wrapped to a width of (currently) 100 chars. They should also use
the correct platform-native line ending now. This is a first step only,
if this works as intended and there are no adverse side effects then the
new StatementBuilder class should be used throughout FR to create
user-visible SQL statements. Testing of this is definitely needed,
feedback especially welcome. There is already a preference setting
"sqlEditorMaxLineLength" that isn't surfaced yet in the preferences
dialog, maybe the line length should simply be taken from the SQL Editor
line marker column? And should it be possible to disable the
line-wrapping completely?

Thanks

--
Michael Hieke



..:: FlameRobin ::..:: Firebird ::..

Happy new year - a small gift

Hi all,

I just committed a new feature into SVN repository.

If you ever tried to alter a single field in table with a lot of
dependencies, you know how painful it is. Our previous "Generate
rebuild script" option is nice, but it regenerates all table
dependencies, so it's hard to track. Especially if you wish to change
a field with, say, 20 deps on table that has 100 deps.

Now, you can select and single table column and get script recreating
only dependencies related to that column. The feature is accessible on
the table property page - there's a new icon for each column, right
next to drop and edit.

Enjoy! (and please report bugs if any).

--
Milan Babuskov
http://www.flamerobin.org

#Flamerobin in #Ubuntu Software Center

I was positively shocked :) that when you search firebird in Software Center you find flamerobin rendered niceley and it installs correctly

Mighty screenshots:

ps: in kubuntu software center is not installed by default (feature? or bug ?)
so you have to type
sudo apt-get install software-center

#Flamerobin 0.9.2 available in major #linux distros : #Mandriva , #Debian, #Ubuntu, #Fedora ,#Gentoo,#OpenSuse

Finaly OpenSuse 11.2 is out. It is the first time that Flamerobin is in official OpenSuse repositories.

After Mandriva (2010.0 that is very nice to use), Debian, Ubuntu, Fedora (and RHEL/Centos Fedora project repositories),Gentoo : we have now OpenSuse

All major free distro have now latest Flamerobin stable version (0.9.2) available in their official repositories.

Here is the list of where flamerobin 0.9.2  is included or can be installed

• Debian [Done] by Damyan Ivanov
• Ubuntu [Done] You can find in the Software Center
• Fedora [Done] by Philippe Makowski
• Gentoo [Done] By Alistair Bush on behalf of wtljr
• Mandriva [Done] by Philippe Makowski
• OpenSuse [Done] by Philippe Makowski
• Red Hat Enterprise Linux [Done] by Philippe Makowski
• Centos [Done] by Philippe Makowski

Small changes to #flamerobin / #firebird packages in #ubuntu #Lucid #Lynx

http://article.gmane.org/gmane.linux.ubuntu.devel.changes.lucid/340

Firebird 2.1.3 is imported from debian also i saw small changes to flamerobin package in the future LTS Ubuntu release

#flamerobin officially included in #arch #linux , not in AUR

while searching for firebird packages i have found that we are officially  included in arch linux (not in AUR)

..:: FlameRobin ::..:: Firebird ::..

#flamerobin and #firebird included in #opensuse 11.2 #linux by default

It's an one click install
Here is the firebird link
http://software.opensuse.org/search?baseproject=openSUSE:11.2&p=1&q=firebird
Here is the flamerobin link
http://software.opensuse.org/search?baseproject=openSUSE:11.2&p=1&q=flamerobin

also is so nice to see that by default we are in the software store/center in ubuntu i will make a screenshot soon


..:: FlameRobin ::..:: Firebird ::..

Firebird 2.1.x and #flamerobin 0.9.2 in the #fedora 12 release notes

In the Applications Databases section from release notes on Fedora core 12 we can see the new Firebird and Flamerobin packages for it

Maybe we should add a notice on the website too

..:: FlameRobin ::..:: Firebird ::..

The best flamerobin bugreport ever :)

http://www.youtube.com/watch?v=dOXl5uEkTko
maybe we should use youtube as bugtracker :P


..:: FlameRobin ::..:: Firebird ::..

Marco Cantu is Installing #Windows7 (From Scratch) + #Flamerobin and Firebird mention

Seems that he is using Flamerobin and Firebird from his list of installed programs
If you don't know who Marco Cantu is here is his humble bio

..:: FlameRobin ::..:: Firebird ::..: Windows7 ::..

#Flamerobin One click install for #OpenSuse #Linux

Here is the oneclick install for flamerobin and for Firebird you might need them both :)

..:: FlameRobin ::..:: Firebird ::..

Firebird and Flamerobin in OpenSuse

It is official
Firebird and Flamerobin have package into OpenSuse main repository
for their next 11.2 version

--
Here is Philippe Makowski's blog post about firebird in suse repo


Supporting users of Firebird
..:: FlameRobin ::..:: Firebird ::..

#flamerobin patch: null-handling in blob editor

Andreas Maier wrote on flamerobin-devel list
Hello

i made some improvements to blob editor. Here is a short list of it:

- The blob editor is now able to handle null values (same logic as in datagrid)
- I added a new context menu "Set field to NULL" to grid menu and sql editor menu.
- The text editor is now readonly and gray when the transaction or blob-field is readonly.

and i fixed some bugs:
- The row (#x) in blob editor caption was wrong (one to less).
- if a non blob field was selected the [Load]-Button shows [Reset].

Tested on Win XP (32bit) and Open Suse Linux 11.1 (32bit).

I hope it works.

Note: If the option "show blob in data grid" is on there will be some problems if you open blobs. In this case you will get the error "Blob already open".
I will try to find the problem next time.

..:: FlameRobin ::..:: Firebird ::..

One happy firebird/flamerobin user

On lazarus db forum

I have discovered zeoslib that fits exactly and "plus" my expectations. And there is/are too much information!
All my frustrations has been changed for happyness.
If anyone have my problem I recommend Lazarus + Zeoslib + {Firebird DB + Firerobin}
Thanks to all.

..:: FlameRobin ::..:: Firebird ::..

Flamerobin builds ok now with wxwidgets 2.9.0 in STL mode

Here is the full thead with wxwidgets 2.9.0 compiling

Well, it did compile before with wxWidgets 2.9, but the fixes were necessary to allow compiling with wxWidgets in STL mode (this was the cause of the bug report we got).

And here is the quick patch already in SVN

..:: FlameRobin ::..:: Firebird ::..

Blob Editor on the way

Here is the thread with new blob editor for Flamerobin with screenshots

..:: FlameRobin ::..:: Firebird ::..

flamerobin will switch to git

Here is the full thread with the svn -> git switch discussion
Seems that everyone agrees that git is faster and better and now there are good tools too for it

http://www.nabble.com/Git-td23725859.html

..:: FlameRobin ::..:: Firebird ::..

Firebird + Flamerobin Tutorial

Guide is in Portuguese

http://silvioprog.blogspot.com/2009/01/flamerobin.html

..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.9.2 around the web

Pages that are already updated

We need some votes or rates on these sites

http://linux.softpedia.com/get/Database/Administrative-frontents/FlameRobin-3807.shtml

http://gnomefiles.org/app.php/FlameRobin

http://www.icewalkers.com/Linux/Software/532120/Flamerobin.html

Seems that flamerobin 0.9.2 is now in debian testing and usage is growing

http://qa.debian.org/popcon.php?package=flamerobin

To do fileforum update , We are best rated in Database area !

http://fileforum.betanews.com/browse/Business-Software/Databases/rated

User settings directory on Windows

we have a bug report for FlameRobin on Windows - see

http://sourceforge.net/tracker/?func=detail&aid=2690351&group_id=124340&atid=699234

which I'm a little unsure about how to handle. Basically since the
introduction of the Config class wxStandardPaths::GetLocalDataDir()
instead of wxStandardPaths::GetDataDir() is used, which results in the
behaviour the bug reporter noticed. This is of concern only in a domain
environment with roaming user profiles, but for users in those it is
probably really a nuisance.

Should we correct this? The way I see it transparently migrating data
from CSIDL_LOCAL_APPDATA to CSIDL_APPDATA won't be noticed on "standard"
systems, and the possible conflicts for domain users with roaming
profiles would be one-time, with the effect of FlameRobin doing the
right thing from then on. I'm not sure about keeping settings in both
locations and merging them on start - this would be the right thing to
do, but the effort to do it now would be too big, especially as the
config() singleton is not a good base for this.

IMHO the meaning of the "$user" path macro should be changed as well,
with "$user" resolving to wxStandardPaths::GetDataDir() and something
like "$user_local" resolving to wxStandardPaths::GetLocalDataDir().

Any comments and insights very welcome.

Thanks

--
Michael Hieke
..:: FlameRobin ::..:: Firebird ::..

Save as CSV file creates tab separated file and how to configure it

There is a config setting that allows user to
choose between comma and tab. We just never exposed it to the
end-user. Just add

CSVDelimiterIsComma=1

to your fr_settings.conf file and see what happens.

See the full thread on flamerobin-devel

..:: FlameRobin ::..:: Firebird ::..

new windows release fixes the double click on the tree items

there was an bug when double clicking on the tree items and is just in 0.9.2 version , but now is fixed if you download from sf area

..:: FlameRobin ::..:: Firebird ::..

Flamerobin 0.9.2 for ubuntu jaunty/intrepid/hardy is released

you need to add my ppa repository to /etc/apt/sources.list

then do an apt-get install flamerobin

here is how installed on my jaunty ubuntu
sudo vi /etc/apt/sources.list.d/mariuz.list
or use pico
sudo pico /etc/apt/sources.list.d/mariuz.list
deb http://ppa.launchpad.net/mapopa/ppa/ubuntu jaunty main
deb-src http://ppa.launchpad.net/mapopa/ppa/ubuntu jaunty main

import my gpg key (in one line)

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com
ea316a2f8d6bd55554c23f680be6d09eef648708

sudo apt-get update && sudo apt-get dist-upgrade
sudo apt-get install flamerobin

..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.9.2-1 Accepted in Debian unstable

Here is the mail with the acceptance message

And the download page for flamerobin package

..:: FlameRobin ::..:: Firebird ::..

FlameRobin 0.9.2 is released

Source, Windows (setup and zip), Linux (Slackware/gtk2) and MacOS X
binary packages are available for download. Win64 port and packages
for various Linux distributions (and maybe FreeBSD) should follow
shortly. This is mostly a bug fix release.

New features:

- Support for trusted authentication
- Databases can now be recreated from existing registration info
- Transaction isolation level can now be selected in SQL editor
- Win64 port
- Allowed deleting from system tables (ex. to stop queries via
MON$STATEMENTS)

As usual, it also has a lot of bugfixes and minor enhancements:

- Fixed problems with mangled UTF8 identifiers
- Improved autoincrement triggers
- Drop FK only once for self-referencing tables in Rebuild script
- Improved management of passwords in connection dialogs
- Case insensitive DoMaIn keyword detection
- Fixed reported length of char fields in DDL extraction of system tables
- Fixed minor DDL extraction problem with BIGINT and scale
- Search words are now highlighted in advanced metadata search results
- DataGrid: sum of values of selected cells in the grid is shown in
status bar
- Data grid cell editor now has a popup menu of a standard edit control
- Data of CHAR type using multibyte character set has correct padding now
- Database file size is now reported correctly for databases over 2GB
- Opening pages in tabs can now be controlled with Shift/Control keys
- Information on database property page is reloaded without reconnecting
- Fixed focus problem with property pages
- Fixed broken descriptions of system table columns in property pages
- Optionally display sources of all triggers on table property page
- Controls are now focused before their popup menus are shown
- Improved usability of menus and commands via keyboard
- SQL Editor: Improved detection of field sizes in resulting dataset
- Fixed statement parsing when SUBSTRING function is present
- Fixed column autocompletion for JOINed tables
- Fixed code completion when tables are listed in SQL89 order
- Fixed crash when opening query window and pressing F5 or F8 at once
- Improved the way views are switched in SQL editor
- Fixed completion under Mac OS X
- Other minor improvements and fixes to SQL editor
- Statement execution time is now displayed with milliseconds precision
- Minimum required version of wxWidgets is now 2.8.



Enjoy!

--
Milan Babuskov


..:: FlameRobin ::..:: Firebird ::..

Flamerobin 0.9.2 Win32 installer and ZIP files, also the Mac OS X DMG

Michael Hieke uploaded Win32 installer and ZIP files, also the Mac OS X DMG. On
Tuesday he will be able to create Win64 files as well.

..:: FlameRobin ::..:: Firebird ::..

Preparation for 0.9.2 release

Here is the list of changes (not final)

Milan Babuskov wrote :

I updated the changelog. I'll upload the Linux binary packages in a
few hours when I get to my dev. computer. Feel free to build and
upload the rest.

When all binaries are up, I'll tag the sources and upload the source
package as well.

..:: FlameRobin ::..:: Firebird ::..

Erlanger Firebird Conference 2009 (EFBT). [Canceled]

Here is the list of papers for EFBT09 in May 2009

http://www.efbt.uni-erlangen.de/vortraege/detail-db.shtml


As till now the willingness of sponsors and the number of applications for the conference is both very low we have to decide in short after Easter wether it can take place at all. So hurry up with registration!

Registration via http://www.efbt.uni-erlangen.de/interaktiv/anmeldung.shtml

flamerobin + python driver in fedora

seems that after firebird , flamerobin will be included in fedora

https://bugzilla.redhat.com/show_bug.cgi?id=488100

..:: FlameRobin ::..:: Firebird ::..

Flamerobin - Robin readbreast

An small blog mention but the translation is funny maybe
Flamerobin will be included in the Russian Linux XP , you know it makes sense if you translate
Flamerobin with google :)

..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.9.0 accepted in ubuntu jaunty

Here is the package and here is the message

Thank you all for finishing this sync request

..:: FlameRobin ::..:: Firebird ::..

FlameRobin user interface: SDI or tab-based?

I have started again to work on the FlameRobin redesign, with multithreaded database access. Since FR 0.9.0 is using the wxAUI library for tabbed property pages I decided to use wxAUI for all of FR:



Ideally it will be possible to open sql editor windows and property windows either in tabs or in their own parent frames. A new poll is up so we get an idea whether the current FlameRobin UI is liked (or not so much) among the FR user base.

Flamerobin + Firebird 2.1.1 on Windows7

I have tested the firebird 2.1.1 classic and flamerobin 0.9 on an Windows7 system

The setup went this way Next Next Next without issues :
1.installed firebird 2.1.1 win32 kit and I choose classic (dual core system)
2.installed flamerobin 0.9 from download area (setup version)

here are the screen shots





Also i downloaded gimp and it installed Romanian version
and is quite difficult in native language :)


..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.9 close to be included in jaunty jackalope

Seem to be an minor bug fixed for the sync request and I hope that flamerobin will be included in ubuntu jaunty jackalope


..:: FlameRobin ::..:: Firebird ::..

flamerobin builds with gcc 4.4

Thanks to debian testers and developers for fixing this bug 



..:: FlameRobin ::..:: Firebird ::..

4 different authentication methods in db registration dialog

Michael Hieke
committed code to support 4 different authentication methods in
the database registration dialog:

 - Use saved user name and password
 - Use saved user name and encrypted password
 - Use saved user name, but always ask for password
 - Use trusted user authentication

The method is selected via a choice control.  For the last two the
password entry field is disabled, for the last one both the user name
and the password entry fields are disabled.

Empty password is supported now for the first method.  Unfortunately our
user management does not allow for empty passwords.  Supporting the
creation of users without password is easy (remove two lines from IBPP),
but deleting the password of an existing user is impossible ATM.  This
needs more work anyway.

I had to modify our internal copy of IBPP slightly, will add patches for
that to SF tracker.

Testing and comments very welcome.

please download an 0.9.x snapshot
..:: FlameRobin ::..:: Firebird ::..

Bundling FirebirdConfig with FlameRobin

after seeing the Firebird Config tool:

http://sourceforge.net/projects/firebirdconfig/
http://jhonny.clubdelphi.com/?page_id=71

I thought how nice would be to have something like that with
FlameRobin. And now I was contacted by FirebirdConfig author, Jhonny
Suarez, about having it as a plugin for FlameRobin.

I know we haven't done any preparation for 'plugins' but maybe we
could simply hook it up to some menu item in Server menu and invoke
the FirebirdConfig executable from there, with some parameters. Or
maybe we should work on some generic plugin architecture first to
allow others to create useful plugins as well.

Only obstacles I see so far:

- it's (currently) Windows only, so an #ifdef would have to take care of that
- license is MPL, which is not compatible. It would be good that
FirebirdConfig is released under MIT license (Expat license) or a
similar one, so we don't have to include two licenses in installer.

P.S. Jhonny is reading this list, so we can discuss the details and
you can ask any question to which he can reply.

--
Milan Babuskov

..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.9.0 for debian is uploaded

Is now uploaded to sid but can be recompiled on other versions


http://packages.debian.org/sid/flamerobin

http://packages.qa.debian.org/f/flamerobin.html




..:: FlameRobin ::..:: Firebird ::..

Flamerobin 0.9.0 ready to install on Ubuntu (Hardy/Intrepid)

All you need is to add my repository
https://edge.launchpad.net/~mapopa/+archive

for example on hardy

add in

sudo gedit /etc/apt/sources.liet

deb http://ppa.launchpad.net/mapopa/ubuntu hardy main
deb-src http://ppa.launchpad.net/mapopa/ubuntu hardy main

for intrepid
deb http://ppa.launchpad.net/mapopa/ubuntu intrepid main
deb-src http://ppa.launchpad.net/mapopa/ubuntu intrepid main

sudo apt-get update

sudo apt-get install flamerobin
or if is already installed 0.8.x on the system
sudo apt-get upgrade



..:: FlameRobin ::..:: Firebird ::..

FlameRobin 0.9.0 released

A new release is out. It brings new features like Firebird 2.1 support, tabbed browsing, etc. Windows, Linux and Mac OS X binaries and source code package are available for download. Here are the details.

..:: FlameRobin ::..:: Firebird ::..

New URL for bug tracker

To make things easier for users (and us, developers), I created a new URL for bug tracker:

http://www.flamerobin.org/bugs.php

It merely redirects browser to the real bug-tracker URL at sourceforge.net.

..:: FlameRobin ::..:: Firebird ::..

database course continues

"Well today I learned a bunch of useful information regarding the use of FlameRobin"

http://wsu-cs385.blogspot.com/2008/09/flamerobin_11.html

..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.8.7 for ubuntu is ready

Can be installed from my ppa and works quite nice

here is one screenshot with flamerobin running in an mini virtual machine (kvm/qemu)




..:: FlameRobin ::..:: Firebird ::..

using flamerobin blog

http://wsu-cs385.blogspot.com/2008/09/flamerobin-db-admin.html
http://wsu-cs385.blogspot.com/2008/09/firebird-and-flamerobin.html

..:: FlameRobin ::..:: Firebird ::..

New snapshot in debian experimental

New 0.8.7 snapshot from svn is now in debian experimenatal

http://packages.debian.org/experimental/flamerobin

..:: FlameRobin ::..:: Firebird ::..

creating an flamerobin/firebird livecd with ubuntu hardy heron

I used this guide for starting point
https://help.ubuntu.com/community/LiveCDCustomization
Download xubuntu-8.04.1-desktop-i386.iso from http://www.xubuntu.org/get
in my case my nearest mirror
$wget http://cdimages.ubuntu.com/xubuntu/releases/hardy/release/xubuntu-8.04.1-desktop-i386.iso
$sudo apt-get install squashfs-tools genisoimage qemu kvm
$sudo modprobe squashfs
$mkdir ~/live/
$mv ~/xubuntu-8.04.1-desktop-i386.iso ~/live/
$cd ~/live
$mkdir mnt
$sudo mount -o loop xubuntu-8.04.1-desktop-i386.iso mnt
$mkdir extract-cd
$rsync --exclude=/casper/filesystem.squashfs -a mnt/ extract-cd
$mkdir squashfs
$sudo mount -t squashfs -o loop mnt/casper/filesystem.squashfs squashfs
$mkdir edit
$sudo cp -a squashfs/* edit/
$sudo cp /etc/resolv.conf edit/etc/
$sudo cp /etc/hosts edit/etc/
$sudo mount --bind /dev/ edit/dev
$sudo chroot edit
$mount -t proc none /proc
$mount -t sysfs none /sys
$export HOME=/root
$export LC_ALL=C

in the Customization part (after you do sudo chroot edit)
I decomented the two lines in /etc/apt/sources.list  sudo vi /etc/apt/sources.list
deb http://archive.ubuntu.com/ubuntu hardy universe
deb-src http://archive.ubuntu.com/ubuntu hardy universe
and added firebird repository
pico /etc/apt/sources.list.d/firebird.list

deb http://ppa.launchpad.net/mapopa/ubuntu hardy main
deb-src http://ppa.launchpad.net/mapopa/ubuntu hardy main

Follow this guide to install firebird
https://help.ubuntu.com/community/Firebird2.1

$apt-get update
$apt-get install flamerobin firebird2.1-super ibwebadmin

Please enter new password for SYSDBA user:masterkey
$apt-get clean
$rm -rf /tmp/*
$rm /etc/resolv.conf
$umount /proc
$umount /sys
$exit
$sudo umount edit/dev

Regenerate manifest 

$chmod +w extract-cd/casper/filesystem.manifest
$sudo chroot edit dpkg-query -W --showformat='${Package} ${Version}\n' > extract-cd/casper/filesystem.manifest
$sudo cp extract-cd/casper/filesystem.manifest extract-cd/casper/filesystem.manifest-desktop
$sudo sed -ie '/ubiquity/d' extract-cd/casper/filesystem.manifest-desktop

Compress filesystem 

$sudo rm extract-cd/casper/filesystem.squashfs
$sudo mksquashfs edit extract-cd/casper/filesystem.squashfs -nolzma

Remove old md5sum.txt and calculate new md5 sums 

$sudo -s
$rm extract-cd/md5sum.txt
$cd extract-cd && find . -type f -print0 | xargs -0 md5sum > md5sum.txt
$exit

Create Iso 

$cd extract-cd
$sudo mkisofs -D -r -V "$IMAGE_NAME" -cache-inodes -J -l -b isolinux/isolinux.bin -c isolinux/boot.cat -no-emul-boot -boot-load-size 4 -boot-info-table -o ../xubuntu-8.04.1-desktop-i386-flamerobin.iso .

$qemu -cdrom xubuntu-8.04.1-desktop-i386-flamerobin.iso -boot d -m 512
or with kvm
$kvm -cdrom xubuntu-8.04.1-desktop-i386-flamerobin.iso -boot d -m 512

or write the iso xubuntu-8.04.1-desktop-i386-flamerobin.iso on the dvd with k3b or nautilus
after the system boots you can create an database with
the username:sysdba
password:masterkey
and the path
/tmp/flamrobin.fdb


I have tested it by using virtual manager similar to this guide 
only that i used this iso xubuntu-8.04.1-desktop-i386-flamerobin.iso instead of jeos

I will upload the final live cd soon

..:: FlameRobin ::..:: Firebird ::..

New Win32 setup snapshot

New Win32 setup, Win32 ZIP and source ZIP uploaded to SF.net. Feedback
welcome.
..:: FlameRobin ::..:: Firebird ::..

Changes in FlameRobin 0.8.7 ALPHA

Here is the changelog for FlameRobin 0.8.7 just commited by Milan

New features

- 100% Firebird 2.1 compatible

- Tab-based property pages for database object (like Firefox browser)



- DataGrid: load and save to file options for BLOB data.



- A new improved dialog for inserting new rows.



Enhancements and Bug fixes

- Firebird 2.1: Support for database triggers
- Firebird 2.1: Support for global temporary tables
- Firebird 2.1: Descriptions can be set for generators
- Firebird 2.1: Support for domains as stored procedure parameter types
- Firebird 2.1: Detect when the equals sign (=) is be used instead of DEFAULT
- SQL Editor: Improved autocomplete for table columns
- SQL Editor: fixed problems with scolling of log control
- SQL Editor: removed flicker when executing scripts with COMMITs or AUTODLL ON
- DataGrid: Copy as Update and Insert for single cell does not require cell to be selected anymore
- DLL extraction for GRANTs fixed
- Fixed random crashes when dropping object from its property page
- Implemented missing prompt for dropping of some objects

- GRANT statements moved to end of database DDL script for easier diffs



..:: FlameRobin ::..:: Firebird ::..

Firebird 2.1.1 and Flamerobin 0.8.6 on Windows 2008 Server

I have created an video with Flamerobin and Firebird 2.1.1

on Windows 2008 Server that runs under an Vmware Instance (Ubuntu Host )

http://video.google.com/videoplay?docid=2523856701166019580&hl=en



or here is the youtube version , still low resolution

http://www.youtube.com/watch?v=_pX30l65CiI



..:: FlameRobin ::..:: Firebird ::..

Accepted flamerobin 0.8.7 in debian unstable/experimental

Changes:
flamerobin (0.8.7~svn20080714r1718-1) experimental; urgency=low
.
* New upstream SVN snapshot
* Build depend on libwxgtk2.8-dev
* rules: detect SVN snapshots and mangle update-svn-rev.sh accordingly
* fetch-upstream-svn: use gzip -9 -n
* fetch-upstream-svn: use 'set -u'
* add README.source documenting how to generate snapshot upstream
releases
* Claim support for Policy 3.8.0

http://packages.qa.debian.org/f/flamerobin/news/20080715T073203Z.html

ok thanks for thouse with debian unstable

in /etc/apt/sources.list

after these lines

deb http://ftp.us.debian.org/debian/ unstable main
deb-src http://ftp.us.debian.org/debian/ unstable main

Add:

deb http://ftp.us.debian.org/debian/ experimental main
deb-src http://ftp.us.debian.org/debian/ experimental main

Then:

# aptitude update
# aptitude install -t experimental flamerobin

and do some tests


..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.8.7 with tabs on ubuntu

Some screenshots with new tabs features in flamerobin





..:: FlameRobin ::..:: Firebird ::..

nice changelog from bazaar imports

flamerobin is daily mirrored to bazaar repository from ubuntu

here is the nice changelog for the head

and to get it from bzr write just this


bzr branch lp:flamerobin
cd flamerobin
./configure
make ; make install

..:: FlameRobin ::..:: Firebird ::..

Build details on Ubuntu Itrepid Ibex

Builds

• intrepid sparc Successfully built (DONE)
• intrepid powerpc Successfully built (DONE)
• intrepid lpia Successfully built (DONE)
• intrepid ia64 Chroot problem
• intrepid hppa Needs building
• hardy i386 Successfully built (DONE)
• hardy amd64 Successfully built (DONE)

here are the build details for the flamerobin source package in Ubuntu Intrepid Ibex


..:: FlameRobin ::..:: Firebird ::..

flamerobin Portability

Damyan Ivanov wrote on the mailing list :

Recently Flamerobin Debian package was built[1] on arm, ia64
(Itanium), mips, mipsel (little-endian mips), powerpc and sparc.

[1]http://buildd.debian.org/build.cgi?pkg=flamerobin

The failures in the above table are due to Firebird not being ported
to hppa, m68k and s390.

So, I want to say "Good work everyone!" and thanks for writing
portable code :)


..:: FlameRobin ::..:: Firebird ::..

flamerobin with tabs screenshot

here are the screenshots with new tabbed browser and wxAUI build

http://javivf.alasombra.net/blog/?p=988

..:: FlameRobin ::..:: Firebird ::..

software listing for flamerobin has been updated

macosx section
http://mac.softpedia.com/get/Business/FlameRobin.shtml
linux section
http://linux.softpedia.com/get/Database/Administrative-frontents/FlameRobin-3807.shtml
windows
http://www.softpedia.com/get/Internet/Servers/Database-Utils/FlameRobin.shtml

..:: FlameRobin ::..:: Firebird ::..

Nominate Firebird & Flamerobin for SourceForge awards

This link is for firebird nomination

This link is for flamerobin nomination

..:: FlameRobin ::..:: Firebird ::..

Ubuntu 8.04 released with Firebird+Flamerobin included

Ubuntu Hardy Heron 8.04 is released with firebird2.0 and flamerobin included in their repository

Here is an easy guide for installing firebird2.0 and then follow the flamerobin 0.8.6 guide

..:: FlameRobin ::..:: Firebird ::..:: ubuntu ::..:: hardy ::..

Tabbed browser and wxAUI - build

Milan Babuskov wrote:

> Any chance of making an experimental Windows build, so people who
> don't compile FR can test?

Test builds (Ansi + Unicode) for Windows can be loaded at

<http://www.flamerobin.org/mghie/flamerobin-0.8.7.1684.zip>


Thanks

--
Michael Hieke


..:: FlameRobin ::..:: Firebird ::..

Roadmap changes

Some changes in the roadmap wiki with features already done and what is left to be done
Also some rewrite ideas are already implemented

..:: FlameRobin ::..:: Firebird ::..

simple way to install flamerobin in ubuntu hardy

flamerobin 0.8.6 is now included in official hardy rapository
and can be installed by an simple

$sudo apt-get install flamerobin
Or click here to install

First question on apt-url install

Another question about apt changes

Downloading the package

Screenshot with flamerobin 0.8.6 after all is finished



..:: FlameRobin ::..:: Firebird ::...:: Ubuntu ::..

Tabbed browser and wxAUI

Milan wrote on devel-list

I have committed to SVN the experimental tab-based implementation of
property pages (using wxAUI). I have developed it on Linux, but it
would be nice if others (i.e. you) could test on other platforms to
see how it works. It's a single commit, and if it turns out that it
doesn't work, we can revert it (at least it would be a nice demo for
what I'd like to see in 'new' FR Michael is working on).

What is done:

- added a notebook control to the main frame (when you start FR,
maximize the window)
- notebook control shows tabs of all opened metadata item property pages
- you can also open links in separate "windows" like the "old" FR
using the "open link in a new window" context menu
- browsing around should be complete and bug free
- maybe adding a 'open link in a new tab' would also be a good idea,
as you currently cannot watch both 'triggers' and 'fields' of a table
(for example) in separate tabs (only in a separate window).

- I also added a special "items" tab, that shows children of the
currently selected tree item (in the main tree)
- "items" tab is only a 'demo', it just shows items, you cannot do
anything with them
- also, each part of the address label (home > localhost > ... ) could
be made a clickable link to go back in hierarchy

Here are some screenshots:

Table properties:
http://www.flamerobin.org/aui/table_properties.png

Showing how list control makes browsing a lot of objects easier:
http://www.flamerobin.org/aui/tables_list.png

Simple split view:
http://www.flamerobin.org/aui/split_view.png

Users can easily split the screen however they want:
http://www.flamerobin.org/aui/split_3way.png

How table columns are displayed (useful when field properties page
cannot fit the screen):
http://www.flamerobin.org/aui/table_columns.png


To do all this, I moved all the property-page functionality from
MetadataItemPropertiesFrame to a new class,
MetadataItemPropertiesPanel. Currently, MetadataItemPropertiesFrame
only show a single item, but I guess it could be extended to support
multiple tabs as well.

Before going further I have few doubts, and I'd like others to try it
out and give some input. There seem to be many ways to handle
'tab-based browsing'. We can have the current code, or have ability to
have multiple MainFrame's (i.e. tree+notebook), or we can have a
single main frame (tree-only) and many notebook-frames.

The more 'separation' (i.e. freedom) we have for these elements, it
would be harder to do navigation. Currently it's easy since one tree
maps to one list control.

Also, there seem to exist some wxAUI classes for MDI, so maybe they
would be interesting to play with.

P.S. I know that some of the classes might need to get renamed after
this, for example framemanager doesn't make much sense when it
actually manages panels. If left it as-is as it's a public interface
to other classes, and I'm still not sure about the final shape of the
whole thing.

--
Milan Babuskov


..:: FlameRobin ::..:: Firebird ::..

flamerobin used at infovark.com

We’ve been using Firebird as infovark’s SQL database for several months now. It’s an open source fork of Borland’s InterBase SQL server. So far, we’ve been extremely impressed by the database itself. Its companion database administration tool, FlameRobin, is shaping up nicely too. It’s currently in version 0.86, but it handles most of what we need.


..:: FlameRobin ::..:: Firebird ::..

flamerobin 0.8.6 officially acepted in ubuntu hardy

it should appear soon in the official hardy repository

http://packages.ubuntu.com/hardy/utils/flamerobin

here is the distro list where flamerobin 0.8.6 is included
Debian http://packages.debian.org/lenny/flamerobin
Gentoo http://gentoo-portage.com/dev-db/flamerobin


..:: FlameRobin ::..:: Firebird ::..

flamerbin mention

one mention about flamerobin and the multithreading thread
..:: FlameRobin ::..:: Firebird ::..

Gnome Files page updated

Gnome Files page is now updated

http://gnomefiles.org/app.php/FlameRobin

..:: FlameRobin ::..:: Firebird ::..

icewalkers page is now updated

with the new release
(it should appear soon the 0.8.6 version )

..:: FlameRobin ::..:: Firebird ::..

sf.net newspage is now updated

https://sourceforge.net/forum/forum.php?forum_id=803985

..:: FlameRobin ::..:: Firebird ::..

Usage Statistics For FlameRobin on sf.net

download and usage stats are growing on sf.net
https://sourceforge.net/project/stats/?group_id=124340&ugn=flamerobin&type=&mode=alltime

..:: FlameRobin ::..:: Firebird ::..

freshmeat page updated

i have updated the freshmeat page
http://freshmeat.net/projects/flamerobin/
i work now to update the r sf.net news , icewalker , gnomefiles

..:: FlameRobin ::..:: Firebird ::..