paint-brush
Introducing FBSQL: Frontend Backend SQL Serverby@fbsql
552 reads
552 reads

Introducing FBSQL: Frontend Backend SQL Server

by FBSQLOctober 18th, 2020
Read on Terminal Reader
Read this story w/o Javascript
tldt arrow

Too Long; Didn't Read

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.

Companies Mentioned

Mention Thumbnail
Mention Thumbnail
featured image - Introducing FBSQL: Frontend Backend SQL Server
FBSQL HackerNoon profile picture

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.