Thursday, April 24, 2008

Ubuntu 8.04 released with Firebird+Flamerobin included

Ubuntu Hardy Heron 8.04 is released with firebird2.0 and flamerobin included in their repository

Here is an easy guide for installing firebird2.0 and then follow the flamerobin 0.8.6 guide



..:: ::..:: ::..:: ::..:: ::..

Monday, April 21, 2008

Tabbed browser and wxAUI - build

Milan Babuskov wrote:

> Any chance of making an experimental Windows build, so people who
> don't compile FR can test?

Test builds (Ansi + Unicode) for Windows can be loaded at

<http://www.flamerobin.org/mghie/flamerobin-0.8.7.1684.zip>


Thanks

--
Michael Hieke


..:: ::..:: ::..

Roadmap changes

Some changes in the roadmap wiki with features already done and what is left to be done
Also some rewrite ideas are already implemented

..:: ::..:: ::..

simple way to install flamerobin in ubuntu hardy

flamerobin 0.8.6 is now included in official hardy rapository
and can be installed by an simple

$sudo apt-get install flamerobin
Or click here to install

First question on apt-url install

Another question about apt changes

Downloading the package

Screenshot with flamerobin 0.8.6 after all is finished



..:: ::..:: ::...:: ::..

Tabbed browser and wxAUI

Milan wrote on devel-list

I have committed to SVN the experimental tab-based implementation of
property pages (using wxAUI). I have developed it on Linux, but it
would be nice if others (i.e. you) could test on other platforms to
see how it works. It's a single commit, and if it turns out that it
doesn't work, we can revert it (at least it would be a nice demo for
what I'd like to see in 'new' FR Michael is working on).

What is done:

- added a notebook control to the main frame (when you start FR,
maximize the window)
- notebook control shows tabs of all opened metadata item property pages
- you can also open links in separate "windows" like the "old" FR
using the "open link in a new window" context menu
- browsing around should be complete and bug free
- maybe adding a 'open link in a new tab' would also be a good idea,
as you currently cannot watch both 'triggers' and 'fields' of a table
(for example) in separate tabs (only in a separate window).

- I also added a special "items" tab, that shows children of the
currently selected tree item (in the main tree)
- "items" tab is only a 'demo', it just shows items, you cannot do
anything with them
- also, each part of the address label (home > localhost > ... ) could
be made a clickable link to go back in hierarchy

Here are some screenshots:

Table properties:
http://www.flamerobin.org/aui/table_properties.png

Showing how list control makes browsing a lot of objects easier:
http://www.flamerobin.org/aui/tables_list.png

Simple split view:
http://www.flamerobin.org/aui/split_view.png

Users can easily split the screen however they want:
http://www.flamerobin.org/aui/split_3way.png

How table columns are displayed (useful when field properties page
cannot fit the screen):
http://www.flamerobin.org/aui/table_columns.png


To do all this, I moved all the property-page functionality from
MetadataItemPropertiesFrame to a new class,
MetadataItemPropertiesPanel. Currently, MetadataItemPropertiesFrame
only show a single item, but I guess it could be extended to support
multiple tabs as well.

Before going further I have few doubts, and I'd like others to try it
out and give some input. There seem to be many ways to handle
'tab-based browsing'. We can have the current code, or have ability to
have multiple MainFrame's (i.e. tree+notebook), or we can have a
single main frame (tree-only) and many notebook-frames.

The more 'separation' (i.e. freedom) we have for these elements, it
would be harder to do navigation. Currently it's easy since one tree
maps to one list control.

Also, there seem to exist some wxAUI classes for MDI, so maybe they
would be interesting to play with.

P.S. I know that some of the classes might need to get renamed after
this, for example framemanager doesn't make much sense when it
actually manages panels. If left it as-is as it's a public interface
to other classes, and I'm still not sure about the final shape of the
whole thing.

--
Milan Babuskov


..:: ::..:: ::..

flamerobin used at infovark.com

We’ve been using Firebird as infovark’s SQL database for several months now. It’s an open source fork of Borland’s InterBase SQL server. So far, we’ve been extremely impressed by the database itself. Its companion database administration tool, FlameRobin, is shaping up nicely too. It’s currently in version 0.86, but it handles most of what we need.


..:: ::..:: ::..

Tuesday, April 08, 2008

Saturday, March 29, 2008

flamerbin mention

one mention about flamerobin and the multithreading thread
..:: ::..:: ::..

Thursday, March 27, 2008

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

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



..:: ::..:: ::..

Monday, March 24, 2008

Notes about multithreading and download link

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

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


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

..:: ::..:: ::..

Notes about multithreading

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

If you are interested you can check it out from

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

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

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

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

Tests of the code and comments are very welcome.

Thanks

--
Michael Hieke


..:: ::..:: ::..

flamerobin 0.8.6 included in gentoo

here is the changelog for the package

..:: ::..:: ::..

Wednesday, March 19, 2008

Accepted 0.8.6-1 in debian unstable

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

here is the message from the debian package page

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

..:: ::..:: ::..:: ::..

flamerobin - 0.8.6 package for ubuntu hardy/gutsy is ready

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

flamerobin 0.8.6 is now included in official hardy rapository
and can be installed by an simple

$sudo apt-get install flamerobin
Or click here to install


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

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

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

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

$sudo apt-get update

$ sudo apt-get install flamerobin

$flamerobin

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

make an video and upload it to youtube

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

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

..:: ::..:: ::..:: ::..:: ::..:: ::..

FlameRobin 0.8.6 is out

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

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

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


..:: ::..:: ::..