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 ::..