# Is "SQL from the frontend" viable?

DevFeed: [Is "SQL from the frontend" viable?](<https://devfeed.tech/articles/is-sql-from-the-frontend-viable-5799.md>)

Original publisher: [Read original article](<https://neon.com/blog/sql-frontend>)

Author: David Gomes

Published: 2024-11-07T18:21:35Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Front end](<https://devfeed.tech/topics/frontend.md>), [Security](<https://devfeed.tech/topics/security.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Back end](<https://devfeed.tech/topics/backend.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [client](<https://devfeed.tech/topics/client.md>), [Development](<https://devfeed.tech/topics/development.md>), [Firebase](<https://devfeed.tech/topics/firebase.md>)

Tags: [backend](<https://devfeed.tech/tags/backend.md>), [database](<https://devfeed.tech/tags/database.md>), [development](<https://devfeed.tech/tags/development.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [firebase](<https://devfeed.tech/tags/firebase.md>), [frontend](<https://devfeed.tech/tags/frontend.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [security](<https://devfeed.tech/tags/security.md>), [sql](<https://devfeed.tech/tags/sql.md>), [time](<https://devfeed.tech/tags/time.md>)

## AI overview

This article examines whether "SQL from the frontend" is viable. It describes the high development velocity of direct client-to-data access, especially for prototypes, while emphasizing unresolved security and scalability challenges. It discusses backend abstractions, sensitive business logic and credentials, database-level authorization, Firebase and PostgREST, and possible safeguards such as query allow-listing.

## Source excerpt

I've worked on apps with a "SQL from the client" architecture and the development velocity was simply superb. At the same time, it comes with a lot of challenges in terms of security and scalability. So, what's the deal? Is it viable or not? The tl;dr is that the technology is pe...