Compiling Flamerobin with QT (wxWidgets qt port) experimental

There is a port for wxwidgets on qt (work in progress and still with many gaps)

So this is only proof of concept.

git clone https://github.com/wxWidgets/wxWidgets.git
cd wxWidgets

mkdir bldqt5
cd bldqt5
../configure --with-qt --enable-debug --enable-compat28 --prefix=/opt/wxqt



then with flamerobin clone git 


./configure --with-wx-config=/wxgt/wx-config --enable-debug --prefix=/opt/flamerobin

make 

it compiles fine :)

you will have an error and you need to add the qt libs when linking 

-lQt5Gui -lQt5Core

Flamerobin starts after a few errors and after that you can see and click the tree with databases and metadata and get the properties.

What doesn't work : db query and grid , you will get a crash

ps: tested on ubuntu 14.04 with qt5

What is next ? Android ;)

Installing #wxwidgets 3.0.x under #gentoo , default is 2.8

If you install wxwidgets with emerge wxGTK on gentoo default is 2.8

emerge -p =x11-libs/wxGTK-3.0.2.0

add /etc/portage/package.accept_keywords

# required by =x11-libs/wxGTK-3.0.2.0 (argument)
=x11-libs/wxGTK-3.0.1.1 ~amd64

emerge -1 =x11-libs/wxGTK-3.0.2.0

# eselect wxwidgets list                                                                                                             

Available wxWidgets profiles:

  [1]   gtk2-unicode-3.0 *

  [2]   gtk2-unicode-release-2.8

# eselect wxwidgets set 1

then continue with flamerobin compiling from source 

./configure

make install

Compiling Flamerobin with wxWidgets 3.0.x

wxWidgets 3.0.2 final is released


This is guide compiling the flamerobin version from git with wxwidgets 3.0.2 final on ubuntu 14.04/debian sid

install flamerobin dependencies

sudo apt-get build-dep flamerobin


Download source code for wxwidgets 3.0.x




tar -jxvf wxWidgets-3.0.2.tar.bz2

cd wxWidgets-3.0.2

./configure --enable-debug --enable-unicode --prefix=/opt/wxwidgets

make -j4

sudo make install


create this file /etc/ld.so.conf.d/wx3.conf


with this line /opt/wxwidgets/lib/


and run sudo ldconfig







clone flamerobin from git




./configure --with-wx-config=/opt/wxwidgets/bin/wx-config --enable-debug --prefix=/opt/flamerobin




make

make install



sudo ldconfig


/opt/flamerobin/bin/flamerobin &

Building Flamerobin for static release

To build flamerobin for static release we use wxWidgets 3.0.2 like in previous post but with the following configure option for wxWidgets

./configure --prefix=/opt/wxwidgets --disable-debug --disable-shared --enable-unicode \
--with-libjpeg=builtin --with-libtiff=builtin --with-expat=builtin \
--with-libpng=builtin --with-zlib=builtin

We build with buildin libraries for jpeg,png,tiff,zlib,expat

make -j4
make install

Download boost
http://downloads.sourceforge.net/boost/boost_1_55_0.tar.bz2
Install Boost by running the following commands:

./bootstrap.sh --prefix=/opt/boost &&
./b2 stage threading=multi link=static

Now, as the root user:

./b2 install threading=multi link=static

after that we build the flamerobin from git with debug enabled

mkdir debug
cd debug
../configure --with-wx-config=/opt/wxwidgets/bin/wx-config --with-boost=/opt/boost --enable-debug

and the following commands for a build in release configuration

mkdir release
cd release
../configure --with-wx-config=/opt/wxwidgets/bin/wx-config --with-boost=/opt/boost --disable-debug

I have used the --prefix=/opt/flamerobin and then created the tar.xz

cd /
strip /opt/flamerobin/bin/flamerobin
tar -cJvf ~/Desktop/flamerobin-0.9.3-ff8df8e-x86_64.tar.xz ./opt/flamerobin

Flamerobin Failure building with g++ 4.9 and wxwidgets3.0

There is a serious bug on building Flamerobin on Debian with g++ 4.9 and wxwidgets 3.0

We found some workarounds commited to git, thanks to Michael

Update
Also gcc 4.9.x is now fixed in debian and other distros that are using it

New Flamerobin snapshot uploaded to Debian unstable

New Flamerobin snapshot uploaded to Debian unstable with the following changes 

  * use xz compression for snapshot source tarball
  * New upstream snapshot
     add support for more Firebird 3.0 reserved keywords
     ask before deleting unsaved changes to SQL files
  * switch to WxWidgets 3.0 (Closes: #742092)
    Thanks to Olly Betts for the patch and the testing

pkgstripfiles over flamerobin (nice that png files are smaller)

from html-templates
opt-png *.png
compute.png: 367 vs. 229
drop.png: 778 vs. 744
ok2.png: 457 vs. 306
ok.png: 315 vs. 229
redx.png: 493 vs. 385
view.png: 526 vs. 442

res dir 

flamerobin.png: 1931 vs. 1810

fricon128.png: 7103 vs. 6174

Here is another log from ubuntu

https://gist.github.com/mariuz/7705365

 

Four byte UTF-8 is handled correctly by Firebird and Flamerobin

You can create a new db with utf-8 charset as default
and then you can insert
Unicode codepoint U+1F638 GRINNING CAT FACE WITH SMILING EYES, aka 😸 -- a perfectly valid Emoji character

Works with no problems to insert and to select from it , compared to mysql for example 😸 where is rejected

Compiling Flamerobin with wxWidgets 3.0 final

wxWidgets 3.0 final is released

This is guide compiling the flamerobin version from git with wxwidgets 3.0 final  on ubuntu 13.10


download wxwidgets 3.0

./configure  --enable-debug --enable-unicode --prefix=/opt/wxwidgets
make -j4
make install


clone flamerobin from git

./configure --with-wx-config=/opt/wxwidgets/bin/wx-config --enable-debug --prefix=/opt/flamerobin

make
make install


sudo ldconfig 

/opt/flamerobin/bin/flamerobin &

New Flamerobin snapshot build for Mac osx

I have now also uploaded a new snapshot build for Mac OS. It's also
built against Boost libraries version 1.54.

The updated boost.m4 file necessitated a bump of the minimum
deployment target to 10.5 (although I don't think that anyone will
even notice these days).

It's still a 32 bit only universal build for PPC and x86. Unless I buy a new Mac this won't change as my 10.5.8 Mac isn't updatable to a more recent OS AFAICS.

If anyone feels like taking over the Mac OS side of FlameRobin and
looking into 64 bit Cocoa builds against wxWidgets 3.0 I'll gladly step aside...

Thanks
--

Michael Hieke

New flamerobin snapshot 0.9.x git hash 5ece15b

new snapshots (git hash 5ece15b) for Windows 32 and 64 bit uploaded to
SourceForge.net.

The 32 bit build does no longer contain a version for Windows 9X
versions, only the Unicode build is included.  The Inno Setup created
installer should not allow the installation on Win 9X but I haven’t
tested this.

All builds use Boost libraries version 1.54, for the necessary changes
to be able to compile it with MSVC++ 7.1 see

https://svn.boost.org/trac/boost/ticket/8027

Testing and reporting on your findings would be great.

Thanks–
Michael Hieke

Compiling flamerobin with wxwidgets 3.0

This is guide compiling the flamerobin version from git with wxwidgets 3.0 on ubuntu 13.10


download wxwidgets 3.0


./configure  --enable-debug --enable-unicode --prefix=/opt/wxwidgets
make -j4
make install


clone flamerobin from git

./configure --with-wx-config=/opt/wxwidgets/bin/wx-config --enable-debug --prefix=/opt/flamerobin

make
then make install


First issue Fixed : I needed to add
-lwx_gtk2u_aui-2.9 -lwx_gtk2u_stc-2.9 to the compile/linking line (i need to change the bkl file like is done for windows with 29 system libs added)
Second issue Fixed:
I investigate this error now when i fetch data from a table in the grid

/opt/wxwidgets/include/wx-2.9/wx/strvararg.h(452): assert "(argtype & (wxFormatStringSpecifier::value)) == argtype" failed in wxArgNormalizer(): format specifier doesn't match argument type

Update:
Solved by a small modification (long type format was needed)

Flamerobin added support for aarch64 in fedora 19 and rawhide

We noticed that ARM64 support was not added to the configure script in Fedora Linux so now Flamerobin in Git adds support for the new arhitecture aarch64
it should work on other Linux distros like Debian after we get an icu,wx port package too

Flamerobin download stats until today

These are  download stats from sourceforge , they don't include the Linux repositories download stats (Ubuntu/Debian/Fedora ...)

http://sourceforge.net/projects/flamerobin/files/stats/timeline?dates=2004-11-17+to+2013-01-30

You can check the popularity contest from Debian

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

Firebird SQL 2.5.2 + Flamerobin + FBConfig distribution

Zaher Dirkey's Firebird SQL 2.5.2 distribution setup is released, please download it and test. It includes FlameRobin and FBConfig tools.

New flamerobin snapshots flamerobin-0.9.3.1186200

New Flamerobin snapshots flamerobin-0.9.3.1186200 for Windows are available .

You can check Git log for code changes

Enjoy, and please be sure to report any bugs, regressions or suggestions on flamerobin-devel list or in the new bug tracker


On Ubuntu/Debian you can follow the Buiding guide from git to obtain the latest snapshot source

FlameRobin project page upgraded to new SourceForge software

Hi all,

the project page has been upgraded to the new SF.net software.  The bad
part is that the URL of the git repository has changed again, hopefully
for the last time, so you will have to clone the repository again.  But
as Damyan pointed out, better to do this sooner rather than later, and
FlameRobin would have been upgraded to the new software anyway.

The good part is that the new software has some new features, most
prominently IMO voting on bugs and feature requests (which I have
already enabled).

<--
Michael Hieke

Mariuz ->

Nice Git Now it works over http
git clone http://git.code.sf.net/p/flamerobin/flamerobin-git


ps: it looks a lot like github :)

Flamerobin switch from SVN to Git is complete

Git repository is up and can be accessed as documented on SourceForge git page


Commands "git branch -l" and "git tag -l" show what they should, so it
probably went pretty good, but please check things out (git log , gitk ..)

We are sure things are in order and the Subversion repository 
is now disabled

I have updated the Buiding guide from git

http://flamerobin.org/dokuwiki/wiki/howtobuildonubuntudebian

New FlameRobin snapshots 0.9.3.2246.* builds

Flamerobin 0.9.3 revision 2246 binary snapshots for Windows are available .
The new snapshot is with two changes:

1.Yet another attempt to properly treat nullability of procedure parameters (there are differences between Firebird versions, for nullable parameters rdb$null_flag need not be null, it may be 0) 

see SF.net tracker item #3565746 

Full diff is here and here 

2.And Show "Not Null" and "Default" columns for parameters in procedure Property pages 

(needs better formatting, ideally column widths in Input and Output parameter tables would be equal)

Full diff is here

Enjoy, and please be sure to report any bugs, regressions or suggestions on flamerobin-devel list.

Snapshot was created before SVN to Git migration

Fun fact: We migrated over the years from CVS -> SVN -> Git

New FlameRobin snapshots 0.9.3.2243.* builds

Flamerobin 0.9.3 revision 2243 binary snapshots for Windows are available .
The new snapshot uses a thread to establish the database connection. That means that the progress dialog can be moved and cancelled, and the progress bar is updated in indeterminate mode. To see it in action it’s best to try to connect to a database on a server which is not available or which doesn’t exist, which so far blocks FlameRobin completely until the connection call times out
Enjoy, and please be sure to report any bugs, regressions or suggestions on flamerobin-devel list.

Windows8 and flamerobin

Seems that flamerobin works on windows8 , i have spotted it on Marcu Cantu's blog

 Yes he does use a classic skin , seems that underneath win8 = win7 with yet another ugly skin (designed for tablets only)

 

 If you are stuck on Windows7/8 there is a nice alternative shell if you want to be productive : multi tasking ... Classic Shell (http://classicshell.sourceforge.net), which has the benefit of being free with source available.

Michael fixed bug tracker item #3565746

Fix for SF.net bug tracker item #3565746: Don't use domain defaults for column or parameter defaults when extracting DDL

flamerobin (0.9.3~svn+2220-1) uploaded to #Debian unstable

Changes:  flamerobin (0.9.3~svn+2220-1) unstable
 
   * New upstream SVN snapshot
     + Enable "Set field to NULL" command for blob fields
     + Enable "Set field to NULL" command for current field if grid has no cells selected
     + Invalidate grid cell attribute cache to properly update text color if field null status has changed
     + Warnings (signed <-> unsigned comparison) fixed
     + Fix for SF.net bug tracker items #3516047 and #2018533: use larger result buffer (65535 instead of 8000) and don't parse past the length of the
     + Don't show Drop and Properties commands for view columns (and fix crash
       in Column::getDropSqlStatement() when called for view columns)
   * Standards-Version: 3.9.3 (no changes needed)

FlameRobin connection thread test on Windows

I have posted a test version of FlameRobin: http://mghie.users.sourceforge.net/flamerobin_win32_test.zip

(a ZIP file containing only the 32 bit executables for Windows in ANSI and Unicode version) that uses a thread to establish the database connection. That
means that the progress dialog can be moved and cancelled, and the progress bar is updated in indeterminate mode. To see it in action it’s
best to try to connect to a database on a server which is not available or which doesn’t exist, which so far blocks FlameRobin completely until
the connection call times out. It would be great if people could test this and write (to flamerobin-devel) whether anything

breaks for them (it didn’t for me, yet). I’m a little of unsure if I should clean this up and commit…

Thanks

–
Michael Hieke

Flamerobin in the Ubuntu Software Center (web link)

Here is the web link in case you want to install it in Ubuntu :)

https://apps.ubuntu.com/cat/applications/flamerobin/

Flamerobin sf.net logo impressions

You can check the sf.net logo impression from the beginning of the project until now http://sourceforge.net/projects/flamerobin/stats/traffic?dates=2004-12-01%20to%202012-04-22
It's interesting to watch the spike from December (last year) 400k visits

Changes in FlameRobin 0.9.4 ALPHA

I have updated the icewalkers page for flamerobin And saw that Milan has updated the changelog for the next release Here are some documented changes

Flamerobin 0.9.3~svn+2216 is now uploaded to ppa for ubuntu oneiric

The package is now in ubuntu oneiric ppa

To install it use

sudo add-apt-repository ppa:mapopa/ppa
sudo apt-get update
sudo apt-get install flamerobin

or if you have already installed


sudo apt-get dist-upgrade

New upstream SVN snapshot in debian (0.9.3~svn+2216-1) and will use larger icon in gnome 3

Here is the changelog 

* New upstream SVN snapshot
 
* Install larger icon to pixmaps/ for nicer gnome3 (at least) experience

Another cool stuff is that Clone registration info is added in the menu (if you inspect the git changelog)

flamerobin_0.9.3~svn+2212 is now in debian sid

The version 0.9.3 - revision 2212 is now in published in debian sid

flamerobin_0.9.3~svn+2212 is now uploaded to ppa for ubuntu oneiric

The package is now in ubuntu oneiric ppa

To install it use

sudo add-apt-repository ppa:mapopa/ppa
sudo apt-get update
sudo apt-get install flamerobin

or if you have already installed


sudo apt-get dist-upgrade

Feedback from users

It completely replaced IBOConsole for me.

IBOConsole has no 64 bit support and can only run in Windows.

FlameRobin on the other hand has 64 bit support and runs in many OSes.

I've been following the progress of this project since 2005 (version 0.2.0).

Back then it looked very nice and very promising but it wasn't "there" yet.

Now, it IS "there". Maybe the developers should change the version to 1.0 to celebrate it

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