Introducing FBSQL: Frontend Backend SQL Server | Hacker Noon

Author profile picture

@fbsqlFBSQL

FBSQL – Frontend Backend SQL Work (secure) with your backend database within HTML

Work (secure) with your backend database within HTML

What is FBSQL?

FBSQL is a server that transparently yet secure connects your frontend to the remote databases.

Is it really two-tier architecture?

Well, yes and no. Look at the FBSQL as two-tier architecture with third tier under the hood.

Which databases are supported?

FBSQL supports any JDBC compliant databases like SQLite, MySQL, PostgreSQL, Oracle, Microsoft SQL Server, IBM Db2 etc. All you need is JDBC driver for your database.

What about security?

FBSQL security is based on the principle of least privilege (POLP). By default, FBSQL does not accept incoming connections. It also rejects all SQL statements that were not declared explicitly. Pre-execution triggers can be used to verify and modify input parameters before execution or completely reject execution by custom conditions. Users must implement their own authentication and authorization mechanism.

What about performance?

FBSQL was designed with performance in mind and supports out of the box connection pooling, results prefetching, ETag-optimized communication and response compression.

FBSQL is open source project under the MIT License.

Author profile picture

Read my stories

FBSQL – Frontend Backend SQL Work (secure) with your backend database within HTML

Tags

The Noonification banner

Subscribe to get your daily round-up of top tech stories!

read original article here