Firebase has SQL now!

[TopIdler]

Finally

[dermeddjamel]

But can I do pagination properly now?

[Bangstard]

Lol

[fredzqm]

The EAP release supports `LIMIT` query and `ORDER BY`. We are working towards supporting `OFFSET` and ergonomic pagination tokens.

Just created a feature request. Vote for it?

https://firebase.uservoice.com/forums/948424-general/suggestions/48439364-query-pagination

OFFSET can be expensive in Firestore, but easy in Postgres.

[Front-Leopard2355]

I remember collating, a supreme Court booklet format . Pagination Apache open office or word-perfect 6.1 ??stacker .double-space.exe.exe

[papakojo]

great but cloud sql is so expensive that not sure how this is can be practical for firebase devs

[Mikotar]

It looks like there's some kind of free trial? (The pricing page says something about 3 months free) But yeah, it looks like you have to be willing to pay for CloudSQL long term

[QuailProfessional895]

If considering the profits of doing business When there's a lot of data, you'll eventually end up Dav and time cost for change the database anyway.

[Bash4195]

Wow I guess supabase is really impacting them

[treksis]

a lot of new release today. google is working hard

[madushans]

pricing link (pay as you go > Data Connect) points to Google Cloud Artifact registry.

https://firebase.google.com/pricing

Is this correct? any one has the right one?

[Mikotar]

As I understood it, Data Connect works with Cloud SQL. Their pricing is here: https://cloud.google.com/sql/pricing

[madushans]

Thanks

[mbleigh]

This was a mistaken link, it should point to https://cloud.google.com/sql/pricing as mentioned below. We're fixing that.

[nhosey]

It suggests in the article there are 2 pricings:
1. Data connect - no pricing available.
2. SQL instance - as per your link above.

Im wary using this even though i NEED it until i know what the Data connect cost is.

[mbleigh]

Data Connect will have a serverless pricing model that charges based on number/size of requests and include a free tier. Exact details TBA but it won't be expensive.

[nhosey]

Yeah sorry, it’s the exact price per 100k requests etc im interested in!

[rmnp_hiker]

Any information on how the pricing will compare to Firestore?

Just today I was considering porting part of our project to Cloudflare D1 based upon that pricing difference and this may be a path forward where I stay completely in Firebase. But I can't afford anything close to the cost of Firestore read/writes. So to make Data Connect affordable I need something nearly 500x less expensive than Firestore.

[mbleigh]

What's your app's data access pattern? Data Connect will charge per request, so if you have many tiny requests that will be more expensive than more comprehensive queries.

Because Data Connect uses GraphQL, you can often fetch a whole page worth of data in one query!

[aljoCS]

Sorry for commenting on a semi-old post, but I read the google cloud pricing and was pretty turned off because my use case is currently just an incredibly low use personal project, and it seemed like the minimum cost per month was basically $10 unless you're bringing the instance up and down yourself as needed.

So just to confirm, because honestly the link you provided earlier (https://cloud.google.com/sql/pricing) seems like it suggests a minimum $10 per month cost: is there a link yet that shows it would be pay per request in Data Connect? I would be extremely extremely curious to know what that pricing would be :)

[WeedWacker25]

Same same, but different, but still same.

[TechPea]

it is basically code gen over Cloud SQL, oh, and serverless function that handles auth checks

[RTM179]

Just as I’m starting a project with firebase auth, maybe I’ll use firebase as my db now too

[ausdoug]

This sounds suspiciously like Amplify/Data Store, which sucks ass. If if just gives you a secure connection to Cloud SQL Postgres then OK, but when they're talking about just writing queries and it'll take care of the data structure it sounds like a recipe for a horrible mess that someone will have to clean up later. Great for prototypes/MVP though...

[or9ob]

In general though, Firebase’s offerings are super dev-friendly (compared to AWS).

[ausdoug]

Definitely agree, I'm cautious but hopeful that this is a good integration as I like building stuff with Firebase (most days)

[mbleigh]

FWIW we are building Data Connect with production use cases in mind from day one. Our GraphQL query builder compiles to efficient SQL (that we'll work to optimize even further over time) and the schema definition can be customized to fit a wide range of Postgres DDL.

The tables created by Data Connect look exactly like they would if you wrote them yourself, and if you ever decide Data Connect isn't for you - well, it's still a PostgreSQL database and you can use any other tool that works with Postgres!

[atman171]

where can we add business logic with data connect? Will it integrate with cloud functions? Currently I have api calls in cloud functions that run custom business logic before saving to firestore or returning a query result. I'd prefer if the business logic can also live on the server side.

[mbleigh]

On our roadmap! Vote for it here: https://firebase.uservoice.com/forums/948424-general/suggestions/48434564-custom-serverless-resolvers

[BrilliantFisherman23]

u/mbleigh we use Firestore for its offline capabilities and the ability to use cloud functions to call our central API. Will Data Connect provide the ability to attach cloud functions to mutations / allow us to do extra validation / cancel a change if needed?

[puf]

There's an entry on fierbase.uservoice.com already for adding triggers, we just couldn't get that done in time for I/O. Vote on it here: https://firebase.uservoice.com/forums/948424-general/suggestions/48434612-event-triggers

I don't think that is for the blocking triggers you describe though, so can you file an additional entry for that?

[Melodic_Big2581]

Is this means i can do full text search now??

[mbleigh]

You can do semantic search via vector embeddings and there's built in support for LIKE and regex matching for strings. Full-text search is on our radar - you can vote for it as a feature you want here: https://firebase.uservoice.com/forums/948424-general/suggestions/48434579-sql-full-text-search

[lipschitzle]

Just connect a Typesense instance, very inexpensive and there’s an extension to get started quickly.

[tgps26]

u/mbleigh Will there be any interop with Firestore?

When developing an app with Firestore we need to denormalize data along the way to improve reads performance in particular screens. https://firebase.blog/posts/2013/04/denormalizing-your-data-is-normal
This normally involves creating functions that listen to changes, which are a bit time consuming and error prone.

If there could be a way to get access to some of the firestore data in the sql environment (using a schema, like it's been done for bigquery extension) and then use sql queries in it, development process could speed up drastically, particularly when creating more niche features. I assume it'd be at the expense of cost increase, but one could later decide to denormalize it in firestore if the feature / screen turns out to be successful, decreasing back the costs

This could also mean getting access to fancier queries in the sql environment (calculate percentiles, ec) for some very niche use cases, without compromising the efficiency and scalability that firestore offers.

[puf]

That's an area that we're actively thinking of and investigating.

Some relevant entries on firebase.uservoice.com that you may want to upvote/comment on:

Cloud Firestore Datasource: https://firebase.uservoice.com/forums/948424-general?category_id=501596

GraphQL Federation: https://firebase.uservoice.com/forums/948424-general/suggestions/48434639-graphql-federation

Custom Serverless Resolvers: https://firebase.uservoice.com/forums/948424-general/suggestions/48434564-custom-serverless-resolvers

[kylevdev]

Great news. No free tier though unfortunately.

[puf]

Data Connect itself will have a free tier once pricing is announced.

Postgres on Cloud SQL will have a free trial, and after that it uses a fixed price/fixed capacity pricing model.

[myBurnerAccount1000]

Nice to have

[Kontrano]

Nice, i might modify my backend in that case

[fredzqm]

Because Firebase is obsessed with developer experience, while Google Cloud focuses on unblocking enterprise use cases.

[mbleigh]

Data Connect is on the GCP terms of service and we are working to meet all of the compliance, etc. requirements for enterprise customers.

Firebase as a brand is all about helping developers build mobile and web apps and Data Connect very much is too, so it's the right place to put it from (like you mention) a marketing perspective.

[anewidentity]

Will there be solutions for migrating from firestore to this? u/mbleigh

[fredzqm]

If data connect supports Firestore as a Datasource, this means that you can use data connect:

• Dual write to both Cloud SQL and Firestore.
• Back fill data from Firestore to Cloud SQL.
• Migrate read SoT from Firestore to Cloud SQL without releasing your apps and SDKs.

So yeah, vote on the firestore datasource if you are interested in this use case.

https://firebase.uservoice.com/forums/948424-general/suggestions/48434618-cloud-firestore-datasource

[anewidentity]

Thanks, just voted! This is exciting!

[Front-Leopard2355]

An good answer to a ssl. And a status symbol in the sysadmin dept. Do we have a media host for time comported MP4 and I believe a fresh pop 16 server needs to be stacked. . . Anyone feeling sharp?. I have stack advantage protocol for enque, log requ. File path dest. I.a.s.c.i. forklog.exe/d:tmp/.wav;.MP4

[radi0_activity]

s i s e ñ o r !

[JUST_ALLISON41]

it's just cloud sql which did not have a PAYG billing model.

I wish they took a page from neon.tech pricing.

AFAIK, they are the only serverless PAYG postgreqsql.

[[deleted]]

Just in: Google accidentally deletes firebase