mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
216 stars 67 forks source link

Built? #38

Closed pgiacomo69 closed 4 years ago

pgiacomo69 commented 4 years ago

Is it possible to get a built version for Windows? Why aren't any new release? Thanks

Wolf-SO commented 4 years ago

go to https://flamerobin.sourceforge.io/ there you'll find links to binaries. The binaries are still provided on sourceforge ...

luronumen commented 4 years ago

People are stopping using FlameRobin because: 1- The project has been stopped for years without any updates to the latest versions of Firebird 3 and 4 2- The last functional version of the installation file for windows (flamerobin-0.9.3.5ece15b-setup.exe) is almost 7 years old since its launch

It is very sad to see that one of the best Firebird Admins is becoming increasingly difficult to use in newer versions of Firebird (3 and 4)

krilbe commented 4 years ago

Yes, it's a pity.

At the same time I can see that it has some basic architectural flaws that would require substantial work to fix, notably the fundamental "hourglass" approach: executing DB operations in the main GUI thread. They should of course be executed in the background. I brought this up at some point but got a reply along the lines of too much work.

Regards, Kjell

Den 2020-05-02 kl. 21:33, skrev Luciano Mendes:

People are stopping using FlameRobin because: 1- The project has been stopped for years without any updates to the latest versions of Firebird 3 and 4 2- The last functional version of the installation file for windows (flamerobin-0.9.3.5ece15b-setup.exe) is almost 7 years old since its launch

It is very sad to see that one of the best Firebird Admins is becoming increasingly difficult to use in newer versions of Firebird (3 and 4)

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/mariuz/flamerobin/issues/38#issuecomment-623002908, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABDFXLCZHDM7RVFCGX67JHLRPRYRNANCNFSM4LXLIE3Q.

PizzaProgram commented 4 years ago

A bigger problem is:

For example: if you generate an SQL > it should auto use "" chars, but only if needed: delete from "SomeTable" where ("My_ID" = 1) and (UPPERFIELD = 2);

Also it would be great to be able to:

  1. set split view as default
  2. click on BROWSE at table's properties page etc...
arvanus commented 4 years ago

@PizzaProgram How are you? So, I'm working on this problem of MixedUpperLowerCaseChars, have you noticed if are ther more places where its displaying wrong? I'm looking at "Generate code" only.

arvanus commented 4 years ago

@pgiacomo69 "for now" you can download a preview at my own fork, @mariuz invited me to join this project, but there are some steps I think that I need to follow before publishing a release so I won't do it right now. Take a loot there, and warn me if you found any problem

arvanus commented 4 years ago

Hi, please test the latest snapshot available and let me know if it's working https://github.com/mariuz/flamerobin/releases/tag/0.9.3.2

luronumen commented 4 years ago

Thank you very much for this update Arvanus!

I have 2 suggestions for fixing in the next build:

1- Remove the System Domains (SEC$KEY, SEC$NAME_PART, SEC$USER_NAME amd (SEC$VALUE) form the domain node (See SystemDomains.PNG attached); 2- Separate the triggers in 2 nodes: "Triggers" for table triggers and "Database Triggers" for the database triggers;

Best Regards, Luciano

Em seg., 10 de ago. de 2020 às 16:37, arvanus notifications@github.com escreveu:

Hi, please test the latest snapshot available and let me know if it's working https://github.com/mariuz/flamerobin/releases/tag/0.9.3.2

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mariuz/flamerobin/issues/38#issuecomment-671548126, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5F4CVVA5WD3FSUHKXG4KLSABD53ANCNFSM4LXLIE3Q .

arvanus commented 4 years ago

Sorry, no print attached Please, open 2 issues with your suggestions, so we can discuss them there

luronumen commented 4 years ago

Hi Arvanus!

I just open the 2 issues as you requested:

Remove the System Domains from the domain node #47 https://github.com/mariuz/flamerobin/issues/47

Separate the triggers in 2 nodes: "Triggers" and "Database Triggers" #48 https://github.com/mariuz/flamerobin/issues/48

Thank you very much for your work for making this tool very useful again!

Best Regards, Luciano

Em seg., 10 de ago. de 2020 às 17:09, arvanus notifications@github.com escreveu:

Sorry, no print attached Please, open 2 issues with your suggestions, so we can discuss them there

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mariuz/flamerobin/issues/38#issuecomment-671563114, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5F4CUTZPT6KHZNEM6NXKLSABHXJANCNFSM4LXLIE3Q .

arvanus commented 4 years ago

OK, thanks I think that some more changes could be done like: Renaming "Functions" to UDF And creating "Internal Functions" for Fb3 internal functions like IBExpert, what you think?

luronumen commented 4 years ago

Hi arvans,

Sure! You can follow RedExpert screenshot that I attached in this issue: https://github.com/mariuz/flamerobin/issues/47

Note that Firebird 3 now supports:

I do not have expertise with C++ development but I can help you a lot testing the FlamRobin once that I have 15 years expertise in software testing and Firebird Database Administrator :)

Best Regards, Luciano

Em seg., 10 de ago. de 2020 às 17:25, arvanus notifications@github.com escreveu:

OK, thanks I think that some more changes could be done like: Renaming "Functions" to UDF And creating "Internal Functions" for Fb3 internal functions like IBExpert, what you think?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mariuz/flamerobin/issues/38#issuecomment-671572099, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5F4CWONKMHSW2TSEWCJFDSABJUZANCNFSM4LXLIE3Q .

PizzaProgram commented 4 years ago

Thank you very much for the new release. :+1: I'll test the MixedUpperLowerCaseChars soon. But first I have to ask:

2015: flamerobin-0.9.3.5ece15b-setup 2017: flamerobin-0.9.3.c75f861-setup 2020: flamerobin-0.9.3.55883844-setup.exe ... while you "call" it 0.9.3.2

How should we able to distinguish one version from the other?

As a programmer myself let me share my experience:

< OFF > For example: IF a user is calling me on the phone, while I'm not sitting at my PC >>> I can easily identify the "version" from the date, so I can HELP them. ( Because usually it's much easier to remember WHEN a feature has been implemented or a bug fixed. Last week or 2+ years ago )

How many persons are out there who can remember in 5 years from now if "5ece15b" was in 2015 or 2020? ( Sorry, I just can not understand any login on this, why most of the programmers like to make other people's life a pain? )

luronumen commented 4 years ago

I wrote the wrong RedExpert screenshot reference. The correct is from issue https://github.com/mariuz/flamerobin/issues/48

Best Regards, Luciano

Em seg., 10 de ago. de 2020 às 17:39, Luciano Rodrigues Nunes Mendes < luronumen@gmail.com> escreveu:

Hi arvans,

Sure! You can follow RedExpert screenshot that I attached in this issue: https://github.com/mariuz/flamerobin/issues/47

Note that Firebird 3 now supports:

I do not have expertise with C++ development but I can help you a lot testing the FlamRobin once that I have 15 years expertise in software testing and Firebird Database Administrator :)

Best Regards, Luciano

Em seg., 10 de ago. de 2020 às 17:25, arvanus notifications@github.com escreveu:

OK, thanks I think that some more changes could be done like: Renaming "Functions" to UDF And creating "Internal Functions" for Fb3 internal functions like IBExpert, what you think?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mariuz/flamerobin/issues/38#issuecomment-671572099, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB5F4CWONKMHSW2TSEWCJFDSABJUZANCNFSM4LXLIE3Q .

arvanus commented 4 years ago

Hi @PizzaProgram :) so it's my first build for official FR snapshot, I was really thinking about increase or not the path version, in the next snapshot I'll increase it

krilbe commented 4 years ago

Den 2020-08-10 kl. 22:52, skrev arvanus:

Hi @PizzaProgram https://github.com/PizzaProgram :) so it's my first build for official FR snapshot, I was really thinking about increase or not the minor version, in the next snapshot I'll increase it

Why not consider semantic versioning? https://semver.org/

I know it may be better suited for libraries than interactive user apps, but it could give some ideas for version numbering.

The date approach is also a good one.

Regards, Kjell

mariuz commented 4 years ago

0.9.3.+ git hash are snapshots done only for testing purposes , not a final release

arvanus commented 4 years ago

Hi everybody @mariuz I'm thinking to build a new snapshot for testing, I just wanted to talk about this issue #66 before What do you think? If anyone could take a look at that suggested fix, I'd be glad

luronumen commented 4 years ago

Hi @arvanus

When you are generating a new version do not forget to optimize the compilation as much as possible in terms of size, speed, etc (FlameRobin.exe around 3,100 KB).

Best Regards, Luciano

arvanus commented 4 years ago

Hi @luronumen I'm using default "Release Dynamic" build image image I am sincerely not comfortable to change this parameters by myself for some Mb reduction 😢

luronumen commented 4 years ago

Hi @mariuz

How did you manage to optimize the flamerobin-0.9.3.5ece15b-setup.exe executable? Could you please help @arvanus in this task?