flamerobin 0.9.0 accepted in ubuntu jaunty

Here is the package and here is the message

Thank you all for finishing this sync request

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

FlameRobin user interface: SDI or tab-based?

I have started again to work on the FlameRobin redesign, with multithreaded database access. Since FR 0.9.0 is using the wxAUI library for tabbed property pages I decided to use wxAUI for all of FR:



Ideally it will be possible to open sql editor windows and property windows either in tabs or in their own parent frames. A new poll is up so we get an idea whether the current FlameRobin UI is liked (or not so much) among the FR user base.

Flamerobin + Firebird 2.1.1 on Windows7

I have tested the firebird 2.1.1 classic and flamerobin 0.9 on an Windows7 system

The setup went this way Next Next Next without issues :
1.installed firebird 2.1.1 win32 kit and I choose classic (dual core system)
2.installed flamerobin 0.9 from download area (setup version)

here are the screen shots





Also i downloaded gimp and it installed Romanian version
and is quite difficult in native language :)


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

flamerobin 0.9 close to be included in jaunty jackalope

Seem to be an minor bug fixed for the sync request and I hope that flamerobin will be included in ubuntu jaunty jackalope


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

flamerobin builds with gcc 4.4

Thanks to debian testers and developers for fixing this bug 



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

4 different authentication methods in db registration dialog

Michael Hieke
committed code to support 4 different authentication methods in
the database registration dialog:

 - Use saved user name and password
 - Use saved user name and encrypted password
 - Use saved user name, but always ask for password
 - Use trusted user authentication

The method is selected via a choice control.  For the last two the
password entry field is disabled, for the last one both the user name
and the password entry fields are disabled.

Empty password is supported now for the first method.  Unfortunately our
user management does not allow for empty passwords.  Supporting the
creation of users without password is easy (remove two lines from IBPP),
but deleting the password of an existing user is impossible ATM.  This
needs more work anyway.

I had to modify our internal copy of IBPP slightly, will add patches for
that to SF tracker.

Testing and comments very welcome.

please download an 0.9.x snapshot
..:: FlameRobin ::..:: Firebird ::..

Bundling FirebirdConfig with FlameRobin

after seeing the Firebird Config tool:

http://sourceforge.net/projects/firebirdconfig/
http://jhonny.clubdelphi.com/?page_id=71

I thought how nice would be to have something like that with
FlameRobin. And now I was contacted by FirebirdConfig author, Jhonny
Suarez, about having it as a plugin for FlameRobin.

I know we haven't done any preparation for 'plugins' but maybe we
could simply hook it up to some menu item in Server menu and invoke
the FirebirdConfig executable from there, with some parameters. Or
maybe we should work on some generic plugin architecture first to
allow others to create useful plugins as well.

Only obstacles I see so far:

- it's (currently) Windows only, so an #ifdef would have to take care of that
- license is MPL, which is not compatible. It would be good that
FirebirdConfig is released under MIT license (Expat license) or a
similar one, so we don't have to include two licenses in installer.

P.S. Jhonny is reading this list, so we can discuss the details and
you can ask any question to which he can reply.

--
Milan Babuskov

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

flamerobin 0.9.0 for debian is uploaded

Is now uploaded to sid but can be recompiled on other versions


http://packages.debian.org/sid/flamerobin

http://packages.qa.debian.org/f/flamerobin.html




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

Flamerobin 0.9.0 ready to install on Ubuntu (Hardy/Intrepid)

All you need is to add my repository
https://edge.launchpad.net/~mapopa/+archive

for example on hardy

add in

sudo gedit /etc/apt/sources.liet

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

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

sudo apt-get update

sudo apt-get install flamerobin
or if is already installed 0.8.x on the system
sudo apt-get upgrade



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

FlameRobin 0.9.0 released

A new release is out. It brings new features like Firebird 2.1 support, tabbed browsing, etc. Windows, Linux and Mac OS X binaries and source code package are available for download. Here are the details.

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

New URL for bug tracker

To make things easier for users (and us, developers), I created a new URL for bug tracker:

http://www.flamerobin.org/bugs.php

It merely redirects browser to the real bug-tracker URL at sourceforge.net.

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

database course continues

"Well today I learned a bunch of useful information regarding the use of FlameRobin"

http://wsu-cs385.blogspot.com/2008/09/flamerobin_11.html

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

flamerobin 0.8.7 for ubuntu is ready

Can be installed from my ppa and works quite nice

here is one screenshot with flamerobin running in an mini virtual machine (kvm/qemu)




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

using flamerobin blog

http://wsu-cs385.blogspot.com/2008/09/flamerobin-db-admin.html
http://wsu-cs385.blogspot.com/2008/09/firebird-and-flamerobin.html

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

New snapshot in debian experimental

New 0.8.7 snapshot from svn is now in debian experimenatal

http://packages.debian.org/experimental/flamerobin

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

creating an flamerobin/firebird livecd with ubuntu hardy heron

I used this guide for starting point
https://help.ubuntu.com/community/LiveCDCustomization
Download xubuntu-8.04.1-desktop-i386.iso from http://www.xubuntu.org/get
in my case my nearest mirror
$wget http://cdimages.ubuntu.com/xubuntu/releases/hardy/release/xubuntu-8.04.1-desktop-i386.iso
$sudo apt-get install squashfs-tools genisoimage qemu kvm
$sudo modprobe squashfs
$mkdir ~/live/
$mv ~/xubuntu-8.04.1-desktop-i386.iso ~/live/
$cd ~/live
$mkdir mnt
$sudo mount -o loop xubuntu-8.04.1-desktop-i386.iso mnt
$mkdir extract-cd
$rsync --exclude=/casper/filesystem.squashfs -a mnt/ extract-cd
$mkdir squashfs
$sudo mount -t squashfs -o loop mnt/casper/filesystem.squashfs squashfs
$mkdir edit
$sudo cp -a squashfs/* edit/
$sudo cp /etc/resolv.conf edit/etc/
$sudo cp /etc/hosts edit/etc/
$sudo mount --bind /dev/ edit/dev
$sudo chroot edit
$mount -t proc none /proc
$mount -t sysfs none /sys
$export HOME=/root
$export LC_ALL=C

in the Customization part (after you do sudo chroot edit)
I decomented the two lines in /etc/apt/sources.list  sudo vi /etc/apt/sources.list
deb http://archive.ubuntu.com/ubuntu hardy universe
deb-src http://archive.ubuntu.com/ubuntu hardy universe
and added firebird repository
pico /etc/apt/sources.list.d/firebird.list

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

Follow this guide to install firebird
https://help.ubuntu.com/community/Firebird2.1

$apt-get update
$apt-get install flamerobin firebird2.1-super ibwebadmin

Please enter new password for SYSDBA user:masterkey
$apt-get clean
$rm -rf /tmp/*
$rm /etc/resolv.conf
$umount /proc
$umount /sys
$exit
$sudo umount edit/dev

Regenerate manifest 

$chmod +w extract-cd/casper/filesystem.manifest
$sudo chroot edit dpkg-query -W --showformat='${Package} ${Version}\n' > extract-cd/casper/filesystem.manifest
$sudo cp extract-cd/casper/filesystem.manifest extract-cd/casper/filesystem.manifest-desktop
$sudo sed -ie '/ubiquity/d' extract-cd/casper/filesystem.manifest-desktop

Compress filesystem 

$sudo rm extract-cd/casper/filesystem.squashfs
$sudo mksquashfs edit extract-cd/casper/filesystem.squashfs -nolzma

Remove old md5sum.txt and calculate new md5 sums 

$sudo -s
$rm extract-cd/md5sum.txt
$cd extract-cd && find . -type f -print0 | xargs -0 md5sum > md5sum.txt
$exit

Create Iso 

$cd extract-cd
$sudo mkisofs -D -r -V "$IMAGE_NAME" -cache-inodes -J -l -b isolinux/isolinux.bin -c isolinux/boot.cat -no-emul-boot -boot-load-size 4 -boot-info-table -o ../xubuntu-8.04.1-desktop-i386-flamerobin.iso .

$qemu -cdrom xubuntu-8.04.1-desktop-i386-flamerobin.iso -boot d -m 512
or with kvm
$kvm -cdrom xubuntu-8.04.1-desktop-i386-flamerobin.iso -boot d -m 512

or write the iso xubuntu-8.04.1-desktop-i386-flamerobin.iso on the dvd with k3b or nautilus
after the system boots you can create an database with
the username:sysdba
password:masterkey
and the path
/tmp/flamrobin.fdb


I have tested it by using virtual manager similar to this guide 
only that i used this iso xubuntu-8.04.1-desktop-i386-flamerobin.iso instead of jeos

I will upload the final live cd soon

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

New Win32 setup snapshot

New Win32 setup, Win32 ZIP and source ZIP uploaded to SF.net. Feedback
welcome.
..:: FlameRobin ::..:: Firebird ::..

Changes in FlameRobin 0.8.7 ALPHA

Here is the changelog for FlameRobin 0.8.7 just commited by Milan

New features

- 100% Firebird 2.1 compatible

- Tab-based property pages for database object (like Firefox browser)



- DataGrid: load and save to file options for BLOB data.



- A new improved dialog for inserting new rows.



Enhancements and Bug fixes

- Firebird 2.1: Support for database triggers
- Firebird 2.1: Support for global temporary tables
- Firebird 2.1: Descriptions can be set for generators
- Firebird 2.1: Support for domains as stored procedure parameter types
- Firebird 2.1: Detect when the equals sign (=) is be used instead of DEFAULT
- SQL Editor: Improved autocomplete for table columns
- SQL Editor: fixed problems with scolling of log control
- SQL Editor: removed flicker when executing scripts with COMMITs or AUTODLL ON
- DataGrid: Copy as Update and Insert for single cell does not require cell to be selected anymore
- DLL extraction for GRANTs fixed
- Fixed random crashes when dropping object from its property page
- Implemented missing prompt for dropping of some objects

- GRANT statements moved to end of database DDL script for easier diffs



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

Firebird 2.1.1 and Flamerobin 0.8.6 on Windows 2008 Server

I have created an video with Flamerobin and Firebird 2.1.1

on Windows 2008 Server that runs under an Vmware Instance (Ubuntu Host )

http://video.google.com/videoplay?docid=2523856701166019580&hl=en



or here is the youtube version , still low resolution

http://www.youtube.com/watch?v=_pX30l65CiI



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

Accepted flamerobin 0.8.7 in debian unstable/experimental

Changes:
flamerobin (0.8.7~svn20080714r1718-1) experimental; urgency=low
.
* New upstream SVN snapshot
* Build depend on libwxgtk2.8-dev
* rules: detect SVN snapshots and mangle update-svn-rev.sh accordingly
* fetch-upstream-svn: use gzip -9 -n
* fetch-upstream-svn: use 'set -u'
* add README.source documenting how to generate snapshot upstream
releases
* Claim support for Policy 3.8.0

http://packages.qa.debian.org/f/flamerobin/news/20080715T073203Z.html

ok thanks for thouse with debian unstable

in /etc/apt/sources.list

after these lines

deb http://ftp.us.debian.org/debian/ unstable main
deb-src http://ftp.us.debian.org/debian/ unstable main

Add:

deb http://ftp.us.debian.org/debian/ experimental main
deb-src http://ftp.us.debian.org/debian/ experimental main

Then:

# aptitude update
# aptitude install -t experimental flamerobin

and do some tests


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