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

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