Re: [firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?

2018-11-09 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
All the free firebird management tools are falling by the wayside. Flamerobin can not handle the new datatypes, does not show database triggers, crashes with UTF8 in many areas etc. FenixSQL is dead FirebirdWebAdmin is based on the no longer supported php5 the list goes on. Dbeaver is generic and

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
Hi Alexey, Just my 2cents from someone who has not had time to review the code and could not find a breakdown of the firebird code structure in a very cursory search. > (1) Schema support as per oracle not microsoft (although you can simulate MS style schema with a proper implementation) >

Re: [firebird-support] Firebird vs. PostgreSQL

2018-11-07 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
Hi Alexey, Where do you see the list of features that are destined to be in 5? I have been a supporter of firebird for years but there are several things that hold it back (1) Schema support as per oracle not microsoft (although you can simulate MS style schema with a proper implementation) (2)

Re: [firebird-support] force disconnect and replace db in use

2018-10-01 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
Different versions of firebird, give you different options. Some versions you just give it a forced or timed shutdown command via the api or command line tools, others you can view the monitor tables and see what various connections are doing and you can delete connections as needed.. You can even

Re: [firebird-support] force disconnect and replace db in use

2018-10-01 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
What version of firebird? On Mon, 1 Oct 2018 at 13:52, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > > > hi, > > is there any programming api to force firebird connections and pools to > disconnect . > > i have a database that run on a shared web hosting in embedded mode . >

Re: [firebird-support] Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files

2018-08-07 Thread Dalton Calford dalton.calf...@gmail.com [firebird-support]
Hi James, I have a couple of questions about your configuration before I give any suggestions. You specify you are wanting to get rid of sort files. Sort files are a tool the engine uses to hold information before sending them to the user. Depending upon your queries, sort files are required