Firebird SQL

What is Firebird SQL ?

• Firebird is an open source SQL relational database management system that runs on Linux, Microsoft Windows, Mac OS X and a variety of Unix.
• It offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

Main features :

• Full support for stored procedures and triggers.
• Full ACID compliant transactions.
• Referential integrity.
• Support for External Functions (UDFs).
• SQL activity can send asynchronous notification events to clients.
• Third-party tools, including GUI administrative tools and replication tools.

How to install Firebird ?

• Search for firebird in google.

               

• Go to official website and choose the compatible version and click on the download link.

                            

• Double click on the downloaded setup file and accept the license agreement.

                

• Click on next.

                    

• Choose the installation location.

                       

• Select the components that we want to install.

                

• Choose the start menu folder that will create the program shortcuts in that folder.

• We can add additional tasks that should select from these options and click on next.

                            

• Create the password and click on next.

                 

• Now the setup is ready to install, click on install.

                   

• Click on next.

                         

• Installation process is completed now click on finish.

                 

• Search for firebird tool and click on that icon.

               

• The firebird isql tool user interface will look like this from here we can write the queries.

                       

Basic Operations in FirebirdSQL :

• For first time user we have to create the database by specifying the path to create the fdb file that will save the all data using that database, and we have to give username and password to authenticate.

             

• After executing that command we can also check by going to that path whether the file is created or not.

                     

• If we have already created the database then we can connect to that database using connect statement, by giving username and password.

• We can create the table by using create statement and insert the values by insert into tablename.

                               

• We can update the rows by using update statement.

           

    

• We can delete the row by using delete statement.