Re: [firebird-support] Text search ...

[Andrew Lowe a...@wht.com.au [firebird-support]]

On 13/03/19 06:44, Lester Caine les...@lsces.co.uk [firebird-support] wrote:
> I've got a few of sites where I've got a growing number of pdf files 
> which it would be nice to actually index the content. First problem is 
> obviously the different qualities of pdf, and I've had finereader 
> deployed in some cases to provide OCRed copies of the original, with the 
> usual variable success. The question is just what is the best base to be 
> working towards. I'm currently working on the basis that we store the 
> original file, and I create thumbnails of the front page so I'm now 
> looking to striping the raw text. Anybody been there already? Any 
> suggestions for Linux based solutions ...
> 
> The current indexing process is pulling a list of words from the 
> document and building a manual index. It was first working pre-Firebird 
> and has not changed so is there a better was with FB3?
> 

Maybe you might want to have a look at Zotero. It does a lot of stuff
with pdf's, databases etc.

Andrew

[firebird-support] Text search ...

[Lester Caine les...@lsces.co.uk [firebird-support]]

I've got a few of sites where I've got a growing number of pdf files 
which it would be nice to actually index the content. First problem is 
obviously the different qualities of pdf, and I've had finereader 
deployed in some cases to provide OCRed copies of the original, with the 
usual variable success. The question is just what is the best base to be 
working towards. I'm currently working on the basis that we store the 
original file, and I create thumbnails of the front page so I'm now 
looking to striping the raw text. Anybody been there already? Any 
suggestions for Linux based solutions ...

The current indexing process is pulling a list of words from the 
document and building a manual index. It was first working pre-Firebird 
and has not changed so is there a better was with FB3?

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

Re: [firebird-support] Firebird vs. PostgreSQL

[Michal Kurczabinski michk...@gmail.com [firebird-support]]

2019-03-12 16:56 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]
>
> FILTER has been implemented in Firebird 4. See "FILTER Clause for
> Aggregate Functions" in the Firebird 4 beta 1 release notes, or
> http://tracker.firebirdsql.org/browse/CORE-5768
Great!

> Note though that the order you mention is not right, it right order
> would be count(other_col) filter (where other_col > soime_val) over(),
> or filter-clause before window-clause(that is also the order in
> PostgreSQL).
You're right :)

-- 
regards,
Michał Kurczabiński

Re: [firebird-support] Firebird vs. PostgreSQL

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

On 2019-03-12 13:13, Michal Kurczabinski michk...@gmail.com 
[firebird-support] wrote:
> I forgot about very useful feature lile  FILTER on window functions
> select some_col, count(other_col) over() FILTER ( where other_col >
> soime_val)  Maybe in  FB 4.0 it might be implemented

FILTER has been implemented in Firebird 4. See "FILTER Clause for 
Aggregate Functions" in the Firebird 4 beta 1 release notes, or 
http://tracker.firebirdsql.org/browse/CORE-5768

Note though that the order you mention is not right, it right order 
would be count(other_col) filter (where other_col > soime_val) over(), 
or filter-clause before window-clause(that is also the order in 
PostgreSQL).

Mark

Re: [firebird-support] keeping the connection

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

12.03.2019 16:45, wang...@yahoo.com [firebird-support] wrote:
> any idea why it got disconnected

   CISCO router in-between dropped idle TCP connection after configured timeout.


-- 
   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/

[firebird-support] keeping the connection

[wang...@yahoo.com [firebird-support]]

Hi,
 installing a linux firebird 1.5 classic in a new pc, notice that the client in 
windows 7, it got disconnected after a while, but check server:
 

   00:00:00 /opt/firebird/bin/fb_lock_mgr
firebird   477   389  0 10:45 ?00:00:00 fb_inet_server
firebird   478   389  0 10:47 ?00:00:02 fb_inet_server
firebird   532   389  1 11:39 ?00:00:00 fb_inet_server

 

 still there, any idea why it got disconnected, it's a centos 6 32 bits server,
 

 Thanks,

 

Re: AW: Re[2]: [firebird-support] Link system tables to trigger

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,you can do this by:Select * from mon$attachments a where 
a.mon$attachment_id=CURRENT_CONNECTIONRegards,Karol Bieniaszewski
null

Re: [firebird-support] Firebird vs. PostgreSQL

[Michal Kurczabinski michk...@gmail.com [firebird-support]]

I forgot about very useful feature lile  FILTER on window functions
select some_col, count(other_col) over() FILTER ( where other_col >
soime_val)  Maybe in  FB 4.0 it might be implemented


2018-11-10 9:47 GMT+01:00, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] :
> On 9-11-2018 22:51, Michal Kurczabinski michk...@gmail.com
> [firebird-support] wrote:
>> First thought:
>>
>> range/rows  between unbounded preceding and unbounded following /
>> current row, etc..
>
> Will be added in Firebird 4 (already present in the Firebird 4 Alpha 1).
>
>> own aggregate functions in conjunction with window functions,
>
> There was a discussion about it on firebird-devel back in
> September/October, but I don't think there was anything conclusive yet.
>
>> list(column) over ...
>
> list does work as a window function, just not with an order by clause
> (that produces: feature is not supported, LIST is not supported in
> ordered windows); I'm not sure why it isn't supported for ordered
> windows though.
>
> Mark
>
> --
> Mark Rotteveel
>


-- 
pozdrawiam / regards,
Michał Kurczabiński

AW: Re[2]: [firebird-support] Link system tables to trigger

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

Hello,

 

I thought similar, would call a stored procedure in my application and set the 
current user. 

 

But there was a little bit hope, that I can get it by using monitor tables, the 
attachment-table includes all informations and perhaps there is a reference to 
the statements or transactions..

 

 

Von: firebird-support@yahoogroups.com  
Gesendet: Dienstag, 12. März 2019 11:26
An: firebird-support@yahoogroups.com
Betreff: Re[2]: [firebird-support] Link system tables to trigger

 

  

Olaf

 

If you use same firebird user for all application users, I assume that you have 
some list of users within your database.

Then you can set a variable for connection named i.e. my_current_user, fill it 
from the application and then use it in i.e triggers in the same manner that 
you would use current_user.

 

HTH

Marcin

 

-- Wiadomość oryginalna --

Od: "Svein Erling Tysvær setys...@gmail.com   
[firebird-support]" mailto:firebird-support@yahoogroups.com> >

Do: firebird-support@yahoogroups.com  

Data: 12.03.2019 11:15:54

Temat: Re: [firebird-support] Link system tables to trigger

 

O, I see, Olaf, you want to get the Windows user (or similar) and not the 
Firebird user (since all use the same Firebird user through ODBC). I have no 
clue whether that is possible to do in a trigger or not, but there's hopefully 
someone else on this list that knows the answer.

 

Sorry,

Set

 

Den tir. 12. mar. 2019 kl. 10:48 skrev 'Check_Mail' check_m...@satron..de 
  [firebird-support] 
mailto:firebird-support@yahoogroups.com> >:

 

Hello Set,

 

all users connecting over odbc with the same user, so I cannot separate the 
user, which changed the record. It is possible to get it over the 
transactions-table?

 

Von: firebird-support@yahoogroups.com  
 mailto:firebird-support@yahoogroups.com> > 
Gesendet: Dienstag, 12. März 2019 09:52
An: firebird-support@yahoogroups.com  
Betreff: Re: [firebird-support] Link system tables to trigger

 

  

Isn't current_user 
(https://firebirdsql.org/refdocs/langrefupd21-current_user.html) sufficient?

 

Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_m...@satron.de 
  [firebird-support] 
mailto:firebird-support@yahoogroups.com> >:

 

Hello,

I would like to log some changes in tables, in germany we must save this for 
dsgvo (customer data).

 

Now, I can do this with trigger, but can I link this changing with the system 
tables, that I could get the user? The mon$attachment shows me all active 
attachments with the user and the ip of the client. Can I link this with the 
changing?

 

Thank you.

 

Best regards

 

Olaf

 

 

 

Re[2]: [firebird-support] Link system tables to trigger

['Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support]]

Olaf

If you use same firebird user for all application users, I assume that 
you have some list of users within your database.
Then you can set a variable for connection named i.e. my_current_user, 
fill it from the application and then use it in i.e triggers in the same 
manner that you would use current_user.


HTH
Marcin

-- Wiadomość oryginalna --
Od: "Svein Erling Tysvær setys...@gmail.com [firebird-support]" 


Do: firebird-support@yahoogroups.com
Data: 12.03.2019 11:15:54
Temat: Re: [firebird-support] Link system tables to trigger




O, I see, Olaf, you want to get the Windows user (or similar) and not 
the Firebird user (since all use the same Firebird user through ODBC). 
I have no clue whether that is possible to do in a trigger or not, but 
there's hopefully someone else on this list that knows the answer.


Sorry,
Set

Den tir. 12. mar. 2019 kl. 10:48 skrev 'Check_Mail' 
check_m...@satron.de [firebird-support] 
:



Hello Set,



all users connecting over odbc with the same user, so I cannot 
separate the user, which changed the record. It is possible to get it 
over the transactions-table?




Von:firebird-support@yahoogroups.com 


Gesendet: Dienstag, 12. März 2019 09:52
An:firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Link system tables to trigger





Isn't current_user 
(https://firebirdsql.org/refdocs/langrefupd21-current_user.html) 
sufficient?




Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' 
check_m...@satron.de [firebird-support] 
:





Hello,

I would like to log some changes in tables, in germany we must save 
this for dsgvo (customer data).




Now, I can do this with trigger, but can I link this changing with 
the system tables, that I could get the user? The mon$attachment 
shows me all active attachments with the user and the ip of the 
client. Can I link this with the changing?




Thank you.



Best regards



Olaf

Re: [firebird-support] Link system tables to trigger

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

O, I see, Olaf, you want to get the Windows user (or similar) and not the
Firebird user (since all use the same Firebird user through ODBC). I have
no clue whether that is possible to do in a trigger or not, but there's
hopefully someone else on this list that knows the answer.

Sorry,
Set

Den tir. 12. mar. 2019 kl. 10:48 skrev 'Check_Mail' check_m...@satron.de
[firebird-support] :

>
>
> Hello Set,
>
>
>
> all users connecting over odbc with the same user, so I cannot separate
> the user, which changed the record. It is possible to get it over the
> transactions-table?
>
>
>
> *Von:* firebird-support@yahoogroups.com 
>
> *Gesendet:* Dienstag, 12. März 2019 09:52
> *An:* firebird-support@yahoogroups.com
> *Betreff:* Re: [firebird-support] Link system tables to trigger
>
>
>
>
>
> Isn't current_user (
> https://firebirdsql.org/refdocs/langrefupd21-current_user.html)
> sufficient?
>
>
>
> Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_m...@satron.de
> [firebird-support] :
>
>
>
> Hello,
>
> I would like to log some changes in tables, in germany we must save this
> for dsgvo (customer data).
>
>
>
> Now, I can do this with trigger, but can I link this changing with the
> system tables, that I could get the user? The mon$attachment shows me all
> active attachments with the user and the ip of the client. Can I link this
> with the changing?
>
>
>
> Thank you.
>
>
>
> Best regards
>
>
>
> Olaf
>
>
>
>
>
>
>
> 
>

AW: [firebird-support] Link system tables to trigger

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

Hello Set,

 

all users connecting over odbc with the same user, so I cannot separate the 
user, which changed the record. It is possible to get it over the 
transactions-table?

 

Von: firebird-support@yahoogroups.com  
Gesendet: Dienstag, 12. März 2019 09:52
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Link system tables to trigger

 

  

Isn't current_user 
(https://firebirdsql.org/refdocs/langrefupd21-current_user.html) sufficient?

 

Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_m...@satron.de 
  [firebird-support] 
mailto:firebird-support@yahoogroups.com> >:

 

Hello,

I would like to log some changes in tables, in germany we must save this for 
dsgvo (customer data).

 

Now, I can do this with trigger, but can I link this changing with the system 
tables, that I could get the user? The mon$attachment shows me all active 
attachments with the user and the ip of the client. Can I link this with the 
changing?

 

Thank you.

 

Best regards

 

Olaf

 

 

Re: [firebird-support] Link system tables to trigger

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

Isn't current_user (
https://firebirdsql.org/refdocs/langrefupd21-current_user.html) sufficient?

Den tir. 12. mar. 2019 kl. 09:20 skrev 'Check_Mail' check_m...@satron.de
[firebird-support] :

>
>
> Hello,
>
> I would like to log some changes in tables, in germany we must save this
> for dsgvo (customer data).
>
>
>
> Now, I can do this with trigger, but can I link this changing with the
> system tables, that I could get the user? The mon$attachment shows me all
> active attachments with the user and the ip of the client. Can I link this
> with the changing?
>
>
>
> Thank you.
>
>
>
> Best regards
>
>
>
> Olaf
>
>
>
>
> 

[firebird-support] Link system tables to trigger

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

Hello,

I would like to log some changes in tables, in germany we must save this for
dsgvo (customer data).

 

Now, I can do this with trigger, but can I link this changing with the
system tables, that I could get the user? The mon$attachment shows me all
active attachments with the user and the ip of the client. Can I link this
with the changing?

 

Thank you.

 

Best regards

 

Olaf