[firebird-support] Re: query to return the last entry in detail table for each entry in master table

[talorigo...@yahoo.co.uk [firebird-support]]

Sorry just to add that I want the query to return projectid, assign_date, 
review_date and Progress_note

[firebird-support] query to return the last entry in detail table for each entry in master table

[talorigo...@yahoo.co.uk [firebird-support]]

I have an assignment table (master table) and a review table (detail table).  
The review table holds one or more records for each record in the assignment 
table.  I need a query to return the latest review for each record in the 
assignment table.  Could someone advise me on a query to do this.
 

 The assignment table has the following fields: assignid, assign_date, manager, 
Projectid
 The review table has the following fields: reviewid, assignid, review_date, 
progress_note
 

 Thanks in advance.

Re: [firebird-support] When do I need the FB 3 client libs?

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Saturday, March 5, 2016, 7:54:59 AM, galdarius wrote:

> >In Firebird 3, compression is OFF by default. You can enable it 
> in firebird.conf (parameter WireCompression = true). 
> ~Carlos H. Cantú.

> The main question is what about the password and how do it.

You hijacked someone else's thread, which was about wire compression,
not passwords.

>  Seems that nobody knows and no information on release notes.

Not true.  Full instructions are in Chapter 12.  You are looking at a
completely new authentication system in Firebird 3.

>  Can you  please solve this two simple questions?

> 1- Encrypted database can be delivered with my application without
> any  configuration? (same question for personal user and password,
> different  from SYSDBA/masterkey) Just install, easy as older versions?

Easy, but different.  You need to get your head around the new method.
>  
> 2- How to encrypt on FB3? (i know that we need to build our own encryption, 
> but how?)

One method of password encryption is enabled by default in Fb 3. That
one is simple - read the notes in Ch. 12 for instructions to get
started with it.

Database encryption requires writing plug-ins, either from scratch or to
interface with an existing DATA encryption scheme.  Fb 3 does not come with
any ready-made scheme - just the sockets for the plug-ins. It is over
to third-party developers to develop and market such things.  It is
NOT a "simple question" at all.

I know that Dmitry Sibiryakov is actively working on an
encryption/decryption scheme.  I have not heard of any others, so far.

HB

Re: [firebird-support] When do I need the FB 3 client libs?

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

Re: [firebird-support] When do I need the FB 3 client libs?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.03.2016 19:54, galdari...@yahoo.com.br [firebird-support] wrote:
> 1- Encrypted database can be delivered with my application without any 
> configuration?
> (same question for personal user and password, different from 
> SYSDBA/masterkey) Just
> install, easy as older versions?
>
> 2- How to encrypt on FB3? (i know that we need to build our own encryption, 
> but how?)

   IBPhoenix offers AES encryption plugin.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] When do I need the FB 3 client libs?

[galdari...@yahoo.com.br [firebird-support]]

>In Firebird 3, compression is OFF by default. You can enable it
 in firebird.conf (parameter WireCompression = true).
~Carlos H. Cantú.

The main question is what about the password and how do it. Seems that nobody 
knows and no information on release notes. Can you please solve this two simple 
questions?

1- Encrypted database can be delivered with my application without any 
configuration? (same question for personal user and password, different from 
SYSDBA/masterkey) Just install, easy as older versions?
 
 2- How to encrypt on FB3? (i know that we need to build our own encryption, 
but how?)

[]'s.

PS: Years ago you explain me what "[]'s" means on portuguese mail group. =P

Re: [firebird-support] When do I need the FB 3 client libs?

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Thank you Carlos.

Re: [firebird-support] When do I need the FB 3 client libs?

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

In Firebird 3, compression is OFF by default. You can enable it
in firebird.conf (parameter WireCompression = true).

Carlos
www.firebirdnews.org - www.FireBase.com.br

K> Thank you Mark.

>> 3. Compression

K> Is compression default on or do I have to edit a config parameter?

K> Regards
K> Martin

Re: [firebird-support] When do I need the FB 3 client libs?

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Thank you Mark.

> 3. Compression

Is compression default on or do I have to edit a config parameter?

Regards
Martin

Re: [firebird-support] When do I need the FB 3 client libs?

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2016-03-04 12:45, Köditz, Martin martin.koed...@it-syn.de 
[firebird-support] wrote:
> Hi,
>
> I wonder when to use the new client libs. For getting more concrete: 
> I
> run a web server with apache using the FB 2.5 client libs to access
> the FB 3.0 RC 2 server. Is that constellation OK or are there 
> benefits
> by using the 3.0 client libs? Same for access via Flamerobin.

You should use the Firebird 3 client if you want all improvements in 
the wire protocol like:

1. New, more secure authentication (SRP) that allows passwords longer 
than 8 characters (note: users for the legacy authentication are 
separate identities from the users for the new authentication model!)
2. Encryption
3. Compression
4. Performance improvements in the wire protocol v13 (2.5.5 client 
library supports protocol v12 or lower)

Other than that everything should work.

Mark

[firebird-support] When do I need the FB 3 client libs?

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Hi,

I wonder when to use the new client libs. For getting more concrete: I run a 
web server with apache using the FB 2.5 client libs to access the FB 3.0 RC 2 
server. Is that constellation OK or are there benefits by using the 3.0 client 
libs? Same for access via Flamerobin.

Regards
Martin

AW: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

['Checkmail' check_m...@satron.de [firebird-support]]

Ann, another question.

 

If I must go back tot he 5.5 version of firebird, how can I gbak the new 
backup-file to the old version?

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Gesendet: Donnerstag, 3. März 2016 17:53
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 
ss

 

  

On Thu, Mar 3, 2016 at 11:16 AM, 'Checkmail' check_m...@satron.de 
  [firebird-support] 
mailto:firebird-support@yahoogroups.com> > 
wrote:

 

 

I’ve postet my problems with the new odbc driver and firebird 2.5 cs, the slow 
queries and all other issus. Now I have installed the firebird 3.0 rc2, the 
performance is great, superservers takes all cpu-cores and the problems now 
banned. I have not changed anything, is this a result of the superserver or the 
version 3 of firebird?

 

Both.  Firebird V3 introduces parallel execution of queries in SuperServer.  
SuperServer was always multi-threaded but only one thread could run at any one 
time even on a multi-processor server.  The benefit of threading in earlier 
versions was that queries could be interleaved, so a long report didn't block 
all other requests.  With V3, thread do run in parallel taking advantage of all 
the processing power of a multi-core machine.

 

Glad things are working better for you!

 

Good luck,

 

Ann 

 

AW: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 ss

['Checkmail' check_m...@satron.de [firebird-support]]

Thank you, Ann :)

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Gesendet: Donnerstag, 3. März 2016 17:53
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2 
ss

 

  

On Thu, Mar 3, 2016 at 11:16 AM, 'Checkmail' check_m...@satron.de 
  [firebird-support] 
mailto:firebird-support@yahoogroups.com> > 
wrote:

 

 

I’ve postet my problems with the new odbc driver and firebird 2.5 cs, the slow 
queries and all other issus. Now I have installed the firebird 3.0 rc2, the 
performance is great, superservers takes all cpu-cores and the problems now 
banned. I have not changed anything, is this a result of the superserver or the 
version 3 of firebird?

 

Both.  Firebird V3 introduces parallel execution of queries in SuperServer.  
SuperServer was always multi-threaded but only one thread could run at any one 
time even on a multi-processor server.  The benefit of threading in earlier 
versions was that queries could be interleaved, so a long report didn't block 
all other requests.  With V3, thread do run in parallel taking advantage of all 
the processing power of a multi-core machine.

 

Glad things are working better for you!

 

Good luck,

 

Ann