Introducing FBSQL: Frontend Backend SQL Server

Written by fbsql | Published 2020/10/18
Tech Story Tags: frontend-backend | sql | open-source | github | javascript | java | html | web-development

TLDR FBSQL is a server that transparently yet secure connects your frontend to the remote databases. Work (secure) with your backend database within HTML within HTML. Supports any JDBC compliant databases like SQLite, Postgres, Oracle, Microsoft SQL Server, IBM Db2 etc. All you need is JDBC driver for your database. FBSQ security is based on the principle of least privilege (POLP) Users must implement their own authentication and authorization mechanism. It also rejects all SQL statements that were not declared explicitly.via the TL;DR App

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.

Written by fbsql | FBSQL - Frontend Backend SQL Work (secure) with your backend database within HTML
Published by HackerNoon on 2020/10/18