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