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

firebird 2.1 rc2+flamerobin for ubuntu hardy/gutsy are ready

Here is the guide to install firebird2.1 and flamerobin on ubuntu hardy/gutsy



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

Notes about multithreading and download link

you can follow this thread about the multithreading and at the end there is an download link

for windows only for the moment
http://www.flamerobin.org/mghie/flamerobin-boosted.zip


run the included executable. It should load your current
fr_databases.conf file and show the databases in a tree.
Double-clicking a database node initiates the connection in a worker
thread. Please note that you can try to connect to a database on an
unavailable server, and continue to work with the program. Current FR
would freeze until the timeout.

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

Notes about multithreading

I have created a new branch in SVN with the code that I have currently
written for a multi-threaded FlameRobin, using Boost libraries.

If you are interested you can check it out from

<https://flamerobin.svn.sourceforge.net/svnroot/flamerobin/branches/fr-with-boost>

I have built it using MSVC++ on Windows, and using gcc on Ubuntu. Boost
libraries need to be installed on the machine, that can be done using
apt-get on Ubuntu, and by manually installing the latest libraries
installer from www.boost.org on Windows. On Windows the environment
variable BOOST_ROOT needs to be defined.

The code doesn't do a whole lot currently: It loads the
fr_databases.conf file and shows the databases in a tree view.
Double-click or [Return] on a database node connects / disconnects a
database. Connected databases show the lists of system tables and user
tables. These lists are populated on-demand, when the collection nodes
are to be expanded. All access to the database (API calls) is performed
in a background thread.

The most interesting (as in different from current FlameRobin sources)
code can be found in src/hierarchy (DBH uses Boost smart pointers) and
in src/engine (multi-threaded API calls).

Tests of the code and comments are very welcome.

Thanks

--
Michael Hieke


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

flamerobin 0.8.6 included in gentoo

here is the changelog for the package

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

Accepted 0.8.6-1 in debian unstable

flamerobin 0.8.6 is available in unstable and can be installed /compiled in any debian version

here is the message from the debian package page

[2008-03-18] Accepted 0.8.6-1 in unstable (low) (Damyan Ivanov)

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

flamerobin - 0.8.6 package for ubuntu hardy/gutsy is ready

flamerobin - 0.8.6 added to ubuntu hardy/gutsy repository and uploaded

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


If you want to use it with firebird 2.1 in hardy or have gutsy installed then you will need to use this repository

https://launchpad.net/~mapopa/+archive

you can install flamerobin 0.8.6 final + firebird2.1 in ubuntu 8.04 by adding these lines in the /etc/apt/sources.list

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

$sudo apt-get update

$ sudo apt-get install flamerobin

$flamerobin

and now check the about box , make an screenshot and put it on flickr or

make an video and upload it to youtube

for gutsy you need to use these lines in /etc/apt/sources.list

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

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

FlameRobin 0.8.6 is out

This is mostly a bug-fix release, probably a first ’stable’ 0.8
version without major bugs. Windows, Linux and Mac OS X binaries and
source code package are available for download. I recommend all Linux
distribution packagers to upgrade (especially if you still use 0.8.3
or lower). Here’s the changelog since 0.8.3:

New features
- DataGrid: BLOB data is now (optionally) shown in cells. Read-only for now.
- DataGrid: A basic ORDER BY clause building when column header is
double-clicked
- Support for LIST function in Firebird 2.1
- Support for MON tables in Firebird 2.1 (Read-only for now.)

Enhancements and Bug fixes
- DataGrid: FR no longer crashes when transaction has ended
(commit/rollback) and grid edit control is active
- DataGrid: Complete string is now shown for editing and copying multiline text
- DataGrid: Copy command now copies a single cell if nothing is selected
- DataGrid: Fixed mixup between BLOB ID and data it contains
- DataGrid: Fixed bug when editing or deleting in grid causes exceptions.
- DataGrid: Successfully deleted rows are deselected, so user can
easily see what is done.
- DDL extraction for GRANTs now only quotes names when needed
- DDL extraction for defaults does not use double quotes anymore.
- Database property page now shows minor ODS version when it is not zero
- Hovering over icons in privileges window, now really shows the grantor
- Improved parsing of SELECT statements
- Support for INSERT..RETURNING and EXECUTE STATEMENT that return a
single record
- Fixed messagebox flood when Execute Procedure called and it doesn’t
return anything
- Print preview and SaveToHtmlFile works again for manual and changelog
- Extracting invalid DDL (missing domain data in system tables) does
not crash FR anymore
- Silent installation (on Windows) does not show changelog window anymore
- Autogenerated domains (system domains) do not show up in the tree anymore
- Added ALTER DOMAIN action for domains
- Tree now shows NOT NULL for columns that inherit NOT NULL from domain
- Fixed parsing bug when non-reserved keyword is used as identifier
- Fixed autocomplete for selectable procedure alias when procedure
call contains parameters (in PSQL)

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

Gtk2 snapshot will become final 0.8.6 release

You'll be glad to know that I just built and uploaded 0.8.5.1645 Gtk2
package - which will probably become the official 0.8.6 release in the
next few days.

http://sourceforge.net/project/showfiles.php?group_id=124340&package_id=251789

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

Changes in FlameRobin 0.8.6 ALPHA

From the svn changelog

New features

- DataGrid: BLOB data is now (optionally) shown in cells. Read-only for now.
- DataGrid: A basic ORDER BY clause building when column header is double-clicked
- Support for LIST function in Firebird 2.1
- Support for MON tables in Firebird 2.1 (Read-only for now.)


Enhancements and Bug fixes

- DataGrid: FR no longer crashes when transaction has ended (commit/rollback) and grid edit control is active
- DataGrid: Complete string is now shown for editing and copying multiline text
- DataGrid: Copy command now copies a single cell if nothing is selected
- DataGrid: Fixed mixup between BLOB ID and data it contains
- DataGrid: Fixed bug when editing or deleting in grid causes exceptions.
- DataGrid: Successfully deleted rows are deselected, so user can easily see what is done.
- DDL extraction for GRANTs now only quotes names when needed
- DDL extraction for defaults does not use double quotes anymore.
- Hovering over icons in privileges window, now really shows the grantor
- Improved parsing of SELECT statements
- Support for INSERT..RETURNING and EXECUTE STATEMENT that return a single record
- Fixed messagebox flood when Execute Procedure called and it doesn't return anything
- Print preview and SaveToHtmlFile works again for manual and changelog
- Extracting invalid DDL (missing domain data in system tables) does not crash FR anymore
- Silent instalation (on Windows) does not show changelog window anymore
- Autogenerated domains (system domains) do not show up in the tree anymore
- Added ALTER DOMAIN action for domains
- Tree now shows NOT NULL for columns that inherit NOT NULL from domain
- Fixed parsing bug when non-reserved keyword is used as identifier.
- Fixed autocomplete for selectable procedure alias when procedure call contains parameters (in PSQL)

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

flamerobin 0.8.5 snapshot for ubuntu 8.04 hardy heron is ready

you can install flamerobin 0.8.5 snapshot into ubuntu 8.04 by adding these lines in the /etc/apt/sources.list

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

$sudo apt-get update

$ sudo apt-get install flamerobin

$flamerobin

and now check the about box , make an screenshot and put it on flickr or

make an video and upload it to youtube

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

flamerobin 0.8.5 snapshot ready in the debian repository

you can test it in debian unstable (amd64 and i386)
http://packages.debian.org/sid/flamerobin

Other binary snapshots for 0.8.5 are here
(you can tests on other operating systems)


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

New Firebird Silver Sponsor from South Africa

And some nice words about flamerobin :) (kudos to the flamerobin team)

From Firebird Foundation blog via firebirdnews.org:

QuickEasy Software, from Cape Town, today became a Silver sponsor, with CEO Heinrich van der Vyver stating “…recently converted our software from IB6 to run on Firebird 2.0.3 and I’m very pleased with the result, also with the backend utility Flamerobin.”

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

flamerobin 0.8.3 in ubuntu's ppa gutsy repository

I have added i386 and amd64 packages for gutsy (stable version)
You can install flamerobin 0.8.3 this way

add these lines in /etc/apt/sources.list

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

then
$sudo apt-get update
$sudo apt-get install flamerobin
you will have an authentication error (an small bug in ppa)

WARNING: The following packages cannot be authenticated!
flamerobin
Install these packages without verification [y/N]? y

$flamerobin

..:: FlameRobin ::..:: Firebird ::..:: ubuntu ::..:: gutsy ::..

flamerobin 0.8.3 in ubuntu's ppa repository

For the moment i have i386 and amd64 packages for hardy (devel version)
You can install flamerobin 0.8.3 this way

add these lines in /etc/apt/sources.list

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

then
$sudo apt-get update
$sudo apt-get install flamerobin
you will have an authentication error (an small bug in ppa)

WARNING: The following packages cannot be authenticated!
flamerobin
Install these packages without verification [y/N]? y

$flamerobin


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

ppa builds complete

	lpia build of flamerobin 0.8.3-1ubuntu7 in ubuntu hardy RELEASE Build started 25 minutes ago on rhenium (xen-lpia) and finished 17 minutes ago taking eight minutes — see the log
	i386 build of flamerobin 0.8.3-1ubuntu7 in ubuntu hardy RELEASE Build started 27 minutes ago on thallium (xen-i386) and finished 18 minutes ago taking nine minutes — see the log
	amd64 build of flamerobin 0.8.3-1ubuntu7 in ubuntu hardy RELEASE Build started 25 minutes ago on osmium (xen-amd64) and finished 16 minutes ago taking eight minutes — see the log

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

flamerobin 0.8.3 is uploaded to ppa.launchpad.net

First version is for ubuntu hardy amd64, i hope to add soon the other versions (gutsy)
The packages must be approved first then they will be visible here https://launchpad.net/~mapopa/+archive

Here is how it was done folowing this quick ppa howto
I have created an configuration file
$vi ~/.dput.cf
[my-ppa]
fqdn = ppa.launchpad.net
method = ftp
incoming = ~mapopa/ubuntu/
login = anonymous
allow_unsigned_uploads = 0

Then downloaded and extracted flamerobin debian version
$dget -x http://ftp.de.debian.org/debian/pool/main/f/flamerobin/flamerobin_0.8.3-1.dsc

$cd flamerobin-0.8.3

I have installed quilt/dput on my machine
$apt-get install quilt dput
I have modified debian/rules and debian/control to add myself to the maintainers
something like is described in this document
Increased the ubuntu package nr
$dch -i
$debuild -S -sa
$dput my-ppa flamerobin_0.8.3-1ubuntu6_source.changes
Here is the log

Checking Signature on .changes
gpg: Signature made Fri 22 Feb 2008 08:54:52 AM EST using DSA key ID 350F6DE9
gpg: Good signature from "Popa Adrian Marius (Mariuz) "
Good signature on /home/mariuz/work/flamerobin/flamerobin_0.8.3-1ubuntu6_source.changes.
Checking Signature on .dsc
gpg: Signature made Fri 22 Feb 2008 08:54:45 AM EST using DSA key ID 350F6DE9
gpg: Good signature from "Popa Adrian Marius (Mariuz) "
Good signature on /home/mariuz/work/flamerobin/flamerobin_0.8.3-1ubuntu1.dsc.
Uploading to my-ppa (via ftp to ppa.launchpad.net):
Uploading to ubuntu (via ftp to upload.ubuntu.com):
flamerobin_0.8.3-1ubuntu6.dsc: done.
flamerobin_0.8.3.orig.tar.gz: done.
flamerobin_0.8.3-1ubuntu6.diff.gz: done.
flamerobin_0.8.3-1ubuntu6_source.changes: done.
Successfully uploaded packages.
Not running dinstall.




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

building flamerobin from debian git repository

git-clone git://git.debian.org/git/collab-maint/flamerobin.git
cd flamerobin

debuild -i -us -uc -b

ls -lah ../*deb
-rw-r--r-- 1 root root 900K 2008-02-22 12:45 ../flamerobin_0.8.3-1_i386.deb
dpkg -i ../flamerobin_0.8.3-1_i386.deb
..:: FlameRobin ::..:: Firebird ::..

GCC slowness... problem solved

[Ed: Milan solved the speed problem for g++, here is what he wrote on devel-list]
Hi all,

Today I tried building FlameRobin with MSVC Express. It works really
nice and it builds FR from scratch in about 2.5 minutes on this
machine where I tried it (Intel Celeron M 1.4GHz with 256MB RAM). This
in on Windows XP Pro with all anti-virus and similar software turned
off.

Then I tried on Linux (it's a dual boot machine) and GCC took 272
seconds, i.e. 4.5 minutes. Both compilers are using PCH. I got really
frustrated about this in the past, so much that I considered to
install Windows on my machine and do FR development there.

But, I suddenly got the idea that GCC might be losing too much time
optimizing. So, I tried to lover the optimization from level 2 to
level 1. I got slight improvement: 225 seconds. Still too slow. Then I
turned it off, and I got the amazing 130 seconds, i.e. 2:10. This is
quite acceptable to development and I guess I'll only use -O2 when we
build the release versions from now on.

The option can be changed by setting CXXFLAGS environment variable
before you run 'configure' script. Something like this (if your shell
is bash):

$ export CXXFLAGS=
$ ../configure ...
$ make

It looks like GCC isn't that bad after all.

--
Milan Babuskov


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

uploading flamerobin to download.com

One way to spread the word about flamerobin is to upload it to download.com
Here are some of the " benefits " , Linux world is better than the winworld
..:: FlameRobin ::..:: Firebird ::..

building flamerobin package - debian/ubuntu way

Here is how to build flamerobin package from debian repository (sid) experimental
sudo apt-get install libwxgtk2.6-dev quilt
wget http://ftp.de.debian.org/debian/pool/main/f/flamerobin/flamerobin_0.8.3.orig.tar.gz
tar -zxvf flamerobin_0.8.3.orig.tar.gz
wget http://ftp.de.debian.org/debian/pool/main/f/flamerobin/flamerobin_0.8.3-1.diff.gz
gunzip flamerobin_0.8.3-1.diff.gz
cd flamerobin-0.8.3-src/
patch -p1 < ../flamerobin_0.8.3-1.diff
debuild -i
[drink some beer]
ls -lah *.deb
-rw-r--r-- 1 mariuz mariuz 907K 2008-02-02 11:39 flamerobin_0.8.3-1_i386.deb

sudo dpkg -i flamerobin_0.8.3-1_i386.deb

flamerobin

ps: i used an previous firebird guide

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

Flamerobin code used with wxLua

I never used wx's ODBC classes; I'm using SQLite3 (via wxSQLite3) / FireBird (via IBPP) databases. I already have -hand written- Lua bindings of wxSQLite3 and IBPP. In a recent C++ project, I used wxGrid/FireBird (code taken from FlameRobin); I like it. Now I want to test/use them with wxLua.

Re: About wxGrid with database wxPropertyGrid usage

Blogged with Flock

Displaying multiline text and blobs

Milan wrote on the mailing lists :

I have implemented the ability to show blob data in the grid and now the
need to show multiline text has increased. I have some ideas about it,
but I'd like to see as much possible feedback as I believe many users
are using multiline text columns. Here are the ideas of UI to cover
it:

a) show tooltip while mouse hovers over cells
b) show tooltip on some user action (like double-click)
c) have a separate subwindow (split grid or sql editor adding another
column to it) which stays on screen until user closes (hides) it
d) have a separate window/dialog that would only show the data

c) and d) is something I plan for Blobs with tabs for
text/hex/image/etc. representation, so maybe it is the best idea for
text as well? Such dialog could have some options like 'save to file'
and similar.

Please give any comment or your own idea. I might even set up a
website poll if we can't figure out what is the best solution.

Thanks,

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


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