Monday, December 04, 2006

So what are we going to get? It is hard to exactly predict, but some things seem certain. Feisty will certainly lead the way with new desktop technologies, including 3d effects and windows that wobble. [ED: now flamerobin is included by default and can be installed by doing:sudo apt-get install flamerobin in linux console]

Monday, November 06, 2006

I recently committed an ebuild for FlameRobin 0.7.5 into Gentoo'sportage repository. Should sync to mirrors in a few hours and users canthenemerge flamerobin on Gentoo

I have had an ebuild for FlameRobin since 0.4.8. I posted to the listlong ago about it I believe. I became a dev a few months back, and notsure why I did not think to commit it sooner.

The ebuild is masked/keyworded unstable/experimental. Although it's beenstable for me on both x86, and amd64 for some time. In 30 days or so,baring any bug reports. I will file stabilization requests with the archteams.

Thanks for all the hard work on a great tool. Hopefully this will helpto increase the user base a bit, so your work can be appreciated by evenmore.

Thursday, November 02, 2006

After unpacking, follow the HOWTO.txt for a short step-by-step explanation.

Using stuff from FR, I made a minimal program structure (bakefile,makefiles, etc.) that enables anyone to have a quick start when creatingnew applications with IBPP and wxWidgets. The program allows you to typethe project name, and it does search&replace on all files, giving you anempty project where you can easily add new .cpp and .h files to thebakefile.

Friday, October 27, 2006

I'd like to know who (if any) of you plans to go to this year'sconference. Nando? Michael? Marius maybe? Olivier? I know Olivier'spaper was not accepted unfortunately. I know that Fikret is going to bethere.

As for my talks, none of them is about FlameRobin directly, but bothwill touch it. Esp. the session about cross platform development withwxWidgets and IBPP:

Using stuff from FR, I made a minimal program structure (bakefile,makefiles, etc.) that enables anyone to have a quick start when creatingnew applications with IBPP and wxWidgets. The program allows you to typethe project name, and it does search&replace on all files, giving you anempty project where you can easily add new .cpp and .h files to thebakefile.

I plan to add this as a module to flamerobin svn tree. It would becalled "template" or something like that. I hope you guys agree with this?

Once online, I'd appreciate if someone would find the time to test ifthis "minimal sample" work with MSVC and work on MacOSX, as I don't haveaccess to them.

As a result, anyone who wants to start a new project with wxWidgets andIBPP (i.e. developing cross-platform GUI app. for Firebird) would havean easy start.

Wednesday, October 25, 2006

[when firebird will be ready on all other architectures we will have an flamerobin build on them too , my dream is flamerobin+firebird on nokia770]

An empty cell means that there is no buildd information for that package version on that arch; this is normally because the package is arch:all or the arch has been told to ignore the package by the buildd admins. The number after a "Needs build" is the position in the queue.

its a simple tarball; when untarred, `pwd`/flamerobin/flamerobinshould just work. it was compiled on solaris 5.10 i86pc, and (if ididn't screw it up), needs "only" the following packages from thesolaris media (ie. no thirdparty dependencies):

(i sorta think anything more than core solaris includes these, atleast most of them).

tarball includes a copy of wx 2.6 and fbclient.so from firebird2.0rc4, all stripped.

basically, after i gave up on using the workshop compiler, it waspretty straightforward with gcc (the one bundled with s10);technically, wx and flamerobin itself (apart from a few trivialissues) didn't have much problem with workshop, but i horribly failedat compiling firebird with suncc, and did so many times (as an addedbonus, it seems that linking g++- and CC-compiled objects together isthe perfect recipe for disaster). the problem with that is that aslong as i can't compile firebird with workshop, there isn't any point(or even way) to do this to flamerobin. does anyone have goodconnections at firebird dev? :>

issues prevail, though; for example, asking for database propertiesimmediately crashes flamerobin. is anyone interested in looking at it?my c++-debugging skills are next to non-existent. also, if anyonewants the debug binaries, i'm happy to tar 'em up.

Friday, September 08, 2006

"there isn't much else to say about it, apart from "don't get tooexcited". it literally needs an iron lung, and even then it crasheson every second click.

getting that far wasn't particularly hard, though. you need to compilea wx (for the blastwave package does not include wx-contrib, but i'llget in touch with the maintainer once i get back from my optometristin the afternoon), and you need to install a firebird package whichcan be gotten from ibphoenix.com; except that don't install it for itstinks, its ugly, and it won't work properly anyway. it was enough toget fbclient.so, though.

well, after all that said, it's still in a much better shape than ihoped. to be continued, but hold your breath do not."

Wednesday, September 06, 2006

Source and binary packages for Windows (setup.exe and .zip) and Linux (gtk1 and gtk2 variants) are available for download. MacOSX and Debian/Ubuntu ones should follow soon (and probably FreeBSD one too). We are also looking for someone to try if things work on Solaris too.

New features - System tables now are available in main tree view - Compatibility with Firebird 2.0 - SQL editor: Autocompletion of column/parameter names and old/new aliases in triggers

Sunday, July 30, 2006

[nice feature for google code hosting , if your oss project already exists on the sf.net then they give you an warning about it ]

The project name that you entered conflicts with one that is reserved. [flamerobin in our case]

The most common reason for a project name to be reserved is that it is already being used on another open source project hosting site. Having a different project with the same name could be confusing to user and detrimental to the existing project.Sometimes when two developers think of the same name, it is because they have the same goal in mind. You might want to familiarize yourself with the existing project, and consider whether it would be better to work with them rather than create a potentially similar project of your own.

Wednesday, June 21, 2006

[In case you have connection problems with svn/cvs servers , you can try svk (is working over svn) .

SVK let clkao mirror remote Subversion repositories, create local branches, hack while offline and later resynchronize his changes with the upstream Subversion servers. SVK is the best version control system for getting your work done while you're hiking in the mountains. It just so happens that what makes SVK wonderful when you're soaking in the hot springs makes it an excellent platform for getting your work done halfway around the world, on an airplane, in a cafe or in your office .]

Next we will install flamerobin db admin tool:Go to flamerobin.org -> Download

Choose the lastest released kit flamerobinhttp://prdownloads.sourceforge.net/flamerobin/flamerobin-0.7.1-gtk2.tar.bz2?download

tar -jxvf Desktop/flamerobin-0.7.1-gtk2.tar.bz2rm Desktop/flamerobin-0.7.1-gtk2.tar.bz2sudo apt-get install make libpng3cd flamerobin-0.7.1-gtk2sudo ln -s /usr/lib/libfbclient.so.1.5.1 /usr/lib/libfbclient.so.2./flamerobinregister the same database as we did for ibwebadminDisplay name: employee exampleDatabase path:/var/lib/firebird2/examples/employee.fdbUsername:SYSDBAPassword:masterkeyClick on "SAVE" then double click on the "employee example" in the left tree

You can click on "Tables -> Select * from ..."

3. Using Firebird Database with debian : there are several documentation links on the webfor python http://jclement.ca/docs/firebird_debian/firebird-debian/for php http://php.net/ibasedebian small howto http://www.debianhelp.co.uk/firebird.htm

Monday, April 17, 2006

as privileges and user management stuff is complete, we're done withfeatures for 0.7.0. I'd like to get the list of things that need to befix/polished before the release.

One of the problems is perhaps AdvancedMetadataSearch dialog. We stillhaven't decided what exactly should it look like. Do you guys think thatwe can go with 0.7.0 release with it - as it is now? It is completelyfunctional, just the layout and some other details are probablydifferent than they should be.

Other thing is StatementHistoryFrame. For the time being, I'd like tomake a modal dialog out of it (select SQL statement from history andclose it). I know how I'd do it when deriving from wxDialog, but I'm notsure what happens if we're to derive it from BaseDialog. What happenswith "buttons panel and sizer". Perhaps we should leave search box andsearch/delete buttons at top, and move "Copy to editor" button to bottom- and also add "Close" button to it?

I'd also like to know how does PrivilegesDialog look on other platforms,as I only tested on Linux. I tried on Windows 98 at some point, and itseemed fine, but I'd like to know about WinXP and Mac.

Sunday, April 09, 2006

This is still a work in progress, but you can already look at table and view privileges. The main problem we currently have is that wxHtmlWindow doesn't support TITLE attribute of IMG tag. I wanted to use it to display the grantor (user who granted the privilege) as a tooltip - when you hover the mouse over privilege icon.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Friday, April 07, 2006

- all passwords(PW) are encrypted with master password (MPW)- MPW is not saved in any file, it is only known to the user- PW + MPW => Cipher (cipher is stored in .conf file)- When PW needs to be decrypted, user is prompted for MPW- Cipher + MPW => PW

Defense from "known plain-text" attack:

- If the attacker gets a hold on to .conf file and knows one of the PWs he would be able to compute MPW (Cipher + PW => MPW). In order to prevent this, we use the following scheme:

- we take MPW+username+full_database_path, and use it as a seed for some irreversible random number generator (RNG) like ISAAC.- we use the numbers produced by RNG to encrypt the PW.- since numbers are unique for each username+full_db_path and RNG is not reversible, the attacker cannot get MPW, and he also cannot decrypt any other password.

Monday, April 03, 2006

today I took a look at FlameRobin after a few days away from it, andhere are some things I noticed that are not optimal IMO. Maybe youdon't agree, maybe you agree and want to fix/change some of them, maybeI'll get around to some of them...

Anyway, here goes:

1) All property pages:- The links on top of the pages jump around when one follows them, andthe link for the current page disappears. I much prefer the way e.g.SourceForge handles this, with all links always visible in the sameplace, with the current page as standard text of the same font. Compareenabling/disabling controls to hiding them.

2) Database property page:- The page uses two narrow tables of fixed width, while all other useexpanding tables, stacked vertically. I'd prefer consistency.- Could the database size be given in MB? Even better would be adynamic label (kB/MB/GB)...- We need a database32.xpm file, current icon is the generic FR one.

3) Advanced Metadata Search frame:- The layout needs to be improved. It is too large (minimal size on mysystem 824x347), to wide for the height (a ratio of about 4:3 would beideal), and it is quite confusing. It would also be hard to extend it(adding more criteria, adding AND/OR combination of criteria, ...). Idon't really have a better layout in mind ATM, but I would like it to becloser to the backup/restore frame layout: controls in the upper part,then the action button, then the result list in the lower part.- The "DDL for selected objects" control shouldn't be there at all,IMHO. Double click on the result list would open the property page withthe same information (default action for DBH objects, known behaviourfrom the tree control).

4) SQL Execution frame:- SQL History frame should at least stay on top of parent executionframe, otherwise frame relation is lost when $user switches betweenframes. But I doubt that a frame is actually the right design there.How about a list box left or right of the SQL edit control, with asplitter, keyboard and drag and drop operations instead of buttons,... ?

Saturday, April 01, 2006

Milan Babuskov one of original creators of fbManager which became Flamerobin, just made it publicly known that he now works for MySQL AB.

My project, Flamerobin and Firebird Foundation , have been acquired by MySQL, AB. Aspart of the agreement, I will be working full time for MySQL. I expectto lurk on the flamerobin-devel list from time to time and may contributethe occasional wolf-o-gram, but I will not be taking an active part inFlamerobin development. Although Mariuz will work for MySQL, part time,translating from wolf to English,He will continue to be active in theFirebird/Flamerobin projects.

Ann Harrison gave the idea to buy all the firebird developers with this poston firebird-support

By downloading flamerobin you agree to the following disclaimer:This programme carries no warranties either implied or explicit. Use at your own risk. It was written by me as a personal challenge. It seemed to work when I ran it, but it might not work for you. It might also delete random files, send pornographic pictures to the president, crash you computer or cause space aliens to destroy the planet. Use it at your own risk and remember: if it’s not backed up, it’s not important.

I plan to soon integrate new IBPP into FlameRobin (needed foruser-management stuff). I tested new IBPP with my FBExport tool, andeverything seems to work fine. If anyone has objections to it, please sayso.

I also plan to do a license change for FlameRobin. So, guys, pleaseconfirm that code you contributed can be re-licensed to Expat license (asI see that discussion on the matter has ceased).

Wednesday, March 29, 2006

It allows you to search for objects by type, name, DDL, description and columns/parameters it contains (if it's a table, view or SP). Search can be done in multiple databases, even on different servers.

For objects that are found, you get standard context menu (same as one in main tree), so you can manipulate them easily. When clicked in result list, you can optionally see the DDL for object, and the tree item is also focused. It uses the Observer Pattern, so when objects are dropped, they get removed from search results as well.

Currently only available in Subversion repository, but you might want to check it out.

Monday, March 20, 2006

After reading a post in the Firebird forum at Devshed I immediately put up a small example about writing a trigger (and also upgraded my favourite tool, Flamerobin, to the latest version) , here it goes

Looks like we're ready. I'll start making the Linux packages (gtk1 andgtk2), and I hope that you'll (Nando, Michael) find some time to buildWindows and OSX versions. I don't have any FreeBSDs around now, so we'llskip the FreeBSD version this time.

I suggest we release source package the last, since there might be someplatform-specific changes and it would be good if the source package isbuildable on all platforms.

Monday, March 06, 2006

I've run into a project that looks for bugs in various open source software, including Linux kernel, Firebird and wxWidgets. Everything around FlameRobin ;) Interesting thing, Firebird seems to have three times more bugs per line of code than wxWidgets.

Wednesday, February 15, 2006

Subversion is back again, so I commited the initial version of DDLextraction support.

Extracting DDL for individual objects works, except that it does notextract DDL for privileges (GRANT ... stuff). Extracting DDL for entiredatabase is close to complete, I just need few more things to add.

In the process, I added a propery page for domains. Nothing fancy, justthe CREATE statement.

Tuesday, February 14, 2006

Pabloj ( Moderator of Oracle and MsSQL (a.k.a. SQLServer) forums at Devshed.com) wrote an article comparing firebird and mysql 5.1.x features And he used flamerobin in the process ;) :"Hi, I've decided to make an in depth test of MySQL's new functionalities by porting Firebird's EMPLOYEE.FDB database to MySQL 5.1.5, here is what I found, I hope it will be useful for people porting apps from MySQL to Firebird and vice-versa.First of all, a screenshot (taken from Firebird's excellent Flamerobin admin tool) showing the actual employee.fdb structure.Note the presence of generators, (aka sequences) won't be available in MySQL, I'll mimic them with autoincrement fields."..:: FlameRobin ::..:: Firebird ::..

Thursday, January 12, 2006

Finally, we managed to pull another release. Check it out, as we have some improvements in it.Once you run it, make sure you go through the Preferences dialog and set some of the new options to your liking. Read more here, changelog includedNew ports: debian,gentoo,freebsd and is 64 bit enabled