Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

2018-05-11 Thread blackfalconsoftw...@outlook.com [firebird-support] 
Thank you, Karol...
 

 I'll take your information and update the article's section on views...
 

 With warm regards,
 Steve

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

2018-05-11 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support] 
One more words:

about views – this is not true that this is redundant to SP.
Views are totally different objects. 
Views can be optimized by Firebird if you join with it with other tables or 
other views 
(with one exception if view contain order by).
Stored procedure work in the different way.
Also you can have trigers on views to make it editable or take different actions
look here:
https://firebirdsql.org/refdocs/langrefupd21-ddl-view.html

Also it is simple then to manage privileges.
Other difference – stored procedures are executed as LATERAL JOIN if you join 
table with procedure.

regards,
Karol Bieniaszewski



From: 'livius' liviusliv...@poczta.onet.pl [firebird-support] 
Sent: Friday, May 11, 2018 5:47 PM
To: firebird-support@yahoogroups.com 
Subject: Re: [firebird-support] Article for experienced developers looking 
learn the Firebird Database

  

Hi,

article is quite good but the title is something like someone should not try to 
read it..

regards,
Karol Bieniaszewski

From: blackfalconsoftw...@outlook.com [firebird-support] 
Sent: Friday, May 11, 2018 4:52 PM
To: firebird-support@yahoogroups.com 
Subject: [firebird-support] Article for experienced developers looking learn 
the Firebird Database

  

For many years I have been tracking the development of the Firebird Database 
Engine and have watched it move from its 1.5 version to its most recent 
release, version 3.0.3.





On a number of occasions I have attempted to work with this database engine..  
And though I have many years of extensive database application development with 
quite a few database engines, Firebird always seem to allude my attempts at 
mastering it.  





>From major to minor "gotchas" from a lack of good introductory documentation 
>regarding the many differences between this database engine and its many 
>contemporaries, which more or less towed a standardized SQL line, even with 
>the many enhancements made to any one engine, Firebird frustrated my efforts 
>to the point on these occasions where I decided the efforts in learning it 
>were simply not justified .





Nonetheless, Firebird still beckoned as mastering it was an accomplishment I 
still wanted to achieve.  As a result, seeing the mostly negative aspects of 
using Microsoft's SQL Server LocalDB for a desktop application I have been 
developing, I decided to "bite the bullet" and somehow find a way to teach 
myself Firebird in order take advantage of its excellent embedded engine also 
known as the Firebird Embedded Server.





The result of this endeavor, which has been very successful so far, is a 
detailed article that attempts to make it much easier for experienced 
professionals to learn Firebird who also, like I, have many years of 
development experience with other database engines.  The article points out the 
many differences when using this engine for scripting within query and action 
screen s in a db-manager or creating database modules with Firebird PSQL that 
can drive even experienced professionals to the point of distraction.  
Hopefully, my experiences will help such professionals who want to master 
Firebird as well a much easier learning experience.





The article can be found at the following link for everyone's review...




https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/




Admittedly, there may be some mistakes in this piece since it was developed 
around my own learning experiences with this database engine. p; As a 
result, if anyone has any comments, corrections, or suggestions please let me 
know at my email address...  blackfalconsoftw...@outlook.com




In addition, if anyone would like a PDF copy of this piece, please let me know 
as well and I will prepare one and send it out...

Re: [firebird-support] Article for experienced developers looking learn the Firebird Database

2018-05-11 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support] 
Hi,

article is quite good but the title is something like someone should not try to 
read it..

regards,
Karol Bieniaszewski

From: blackfalconsoftw...@outlook.com [firebird-support] 
Sent: Friday, May 11, 2018 4:52 PM
To: firebird-support@yahoogroups.com 
Subject: [firebird-support] Article for experienced developers looking learn 
the Firebird Database

  

For many years I have been tracking the development of the Firebird Database 
Engine and have watched it move from its 1.5 version to its most recent 
release, version 3.0.3.





On a number of occasions I have attempted to work with this database engine..  
And though I have many years of extensive database application development with 
quite a few database engines, Firebird always seem to allude my attempts at 
mastering it.  





>From major to minor "gotchas" from a lack of good introductory documentation 
>regarding the many differences between this database engine and its many 
>contemporaries, which more or less towed a standardized SQL line, even with 
>the many enhancements made to any one engine, Firebird frustrated my efforts 
>to the point on these occasions where I decided the efforts in learning it 
>were simply not justified .





Nonetheless, Firebird still beckoned as mastering it was an accomplishment I 
still wanted to achieve.  As a result, seeing the mostly negative aspects of 
using Microsoft's SQL Server LocalDB for a desktop application I have been 
developing, I decided to "bite the bullet" and somehow find a way to teach 
myself Firebird in order take advantage of its excellent embedded engine also 
known as the Firebird Embedded Server.





The result of this endeavor, which has been very successful so far, is a 
detailed article that attempts to make it much easier for experienced 
professionals to learn Firebird who also, like I, have many years of 
development experience with other database engines.  The article points out the 
many differences when using this engine for scripting within query and action 
screen s in a db-manager or creating database modules with Firebird PSQL that 
can drive even experienced professionals to the point of distraction.  
Hopefully, my experiences will help such professionals who want to master 
Firebird as well a much easier learning experience.





The article can be found at the following link for everyone's review...




https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/




Admittedly, there may be some mistakes in this piece since it was developed 
around my own learning experiences with this database engine. p; As a 
result, if anyone has any comments, corrections, or suggestions please let me 
know at my email address...  blackfalconsoftw...@outlook.com




In addition, if anyone would like a PDF copy of this piece, please let me know 
as well and I will prepare one and send it out...

RE: [firebird-support] Article for experienced developers looking learn the Firebird Database

2018-05-11 Thread 'Live.com Email' emendez...@nc.rr.com [firebird-support] 
Thank you. I am always looking for additional Firebird information. 

 

-Edward Mendez

 

From: firebird-support@yahoogroups.com  
Sent: Friday, May 11, 2018 10:53 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Article for experienced developers looking learn 
the Firebird Database

 

  

For many years I have been tracking the development of the Firebird Database 
Engine and have watched it move from its 1.5 version to its most recent 
release, version 3.0.3.

 

On a number of occasions I have attempted to work with this database engine..  
And though I have many years of extensive database application development with 
quite a few database engines, Firebird always seem to allude my attempts at 
mastering it.  

 

>From major to minor "gotchas" from a lack of good introductory documentation 
>regarding the many differences between this database engine and its many 
>contemporaries, which more or less towed a standardized SQL line, even with 
>the many enhancements made to any one engine, Firebird frustrated my efforts 
>to the point on these occasions where I decided the efforts in learning it 
>were simply not justified.

 

Nonetheless, Firebird still beckoned as mastering it was an accomplishment I 
still wanted to achieve.  As a result, seeing the mostly negative aspects of 
using Microsoft's SQL Server LocalDB for a desktop application I have been 
developing, I decided to "bite the bullet" and somehow find a way to teach 
myself Firebird in order take advantage of its excellent embedded engine also 
known as the Firebird Embedded Server.

 

The result of this endeavor, which has been very successful so far, is a 
detailed article that attempts to make it much easier for experienced 
professionals to learn Firebird who also, like I, have many years of 
development experience with other database engines.  The article points out the 
many differences when using this engine for scripting within query and action 
screens in a db-manager or creating database modules with Firebird PSQL that 
can drive even experienced professionals to the point of distraction.  
Hopefully, my experiences will help such professionals who want to master 
Firebird as well a much easier learning experience.

 

The article can be found at the following link for everyone's review...

 

https://blackfalconsoftware.wordpress.com/2018/05/11/the-firebird-database-engine-the-frustrations-of-the-long-distance-database-application-developer/

 

Admittedly, there may be some mistakes in this piece since it was developed 
around my own learning experiences with this database engine.  As a result, if 
anyone has any comments, corrections, or suggestions please let me know at my 
email address...  blackfalconsoftw...@outlook.com 
 

 

In addition, if anyone would like a PDF copy of this piece, please let me know 
as well and I will prepare one and send it out...