A Firebird client is an application, usually written in a high-level language, that provides end-user access to the features and tools of the Firebird database management system and to data stored in databases. The isql interactive SQL utility and the other command-line utilities in your Firebird /bin directory are examples of client applications.
Firebird clients typically reside on remote workstations and connect to a Firebird server running on a host node in a network. Firebird also supports a stand-alone model allowing client applications, the Firebird client library, and the Firebird server to execute on the same physical box.
Client applications need not involve end-users at all. Daemons, scripts, and services can be clients.
Firebird is designed for heterogeneous networks. Clients running under one operating system can access a server on a different operating system platform. A common arrangement is to have Windows 98 or ME and Linux workstations concurrently accessing a departmental server running Windows NT or Windows 2000, or any of several flavors of UNIX or Linux.
In the client/server model, applications never touch the database directly. Any application process converses with the server through the Firebird client library, a copy of which must be installed on each client workstation. The Firebird client library provides the API through which programs make function calls to retrieve, store, and manipulate data and metadata. Generally, other layers are also involved in the interface between the application program and the Firebird client that surface generic or application language–specific mechanisms for populating and calling the API functions.
For Java development, Firebird’s stable of supported drivers includes the JayBird JDBC/JCA-compliant Java driver for flexible, platform-independent application interfacing between many open source and commercial Java development systems and Firebird databases. Open source and third-party interfacing components and drivers are available for many other development platforms, including Borland Delphi, Kylix, and C++Builder, commercial and open source C++ variants, Python, PHP, and DBI::Perl. For .NET development, a Firebird .NET provider is under constant development.
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.