6 ms·
[Firebase founder] The thing I'm excited about w/Instant is the quad-fecta of offline + real-time + relational queries + open source. The amount of requests we
by jamest 2y ago
[Firebase founder] The thing I'm excited about w/Instant is the quad-fecta of offline + real-time + relational queries + open source. The amount of requests we had for relational queries was off-the-charts (and is a hard engineering problem), and, while the Firebase clients are OSS, I failed to open source a reference backend (a longer story).
Good luck, Joe, Stopa and team!
- buggy6257 2y agoThis is an aside but “trifecta but with four” actually has an awesome name: “Superfecta”!
- djeastm 2y agoTetrafecta would be cooler
- aitchnyu 2y agoCursory googling says tetra is Greek and perfect is Latin, so its a bastard word like erogenous or television.
- ignoramous 2y ago> bastard word like ... television. From where I am, it is simply telly, because why not bastardise it some more while we are at it.
- tzot 2y agoSide point: television is a bastard word, but erogenous is not Greek eros + Latin genus; it's all greek (ἐρωτογενής — it would be erotogenous in English since the root of the word eros is erot- , but the extra syllable was dropped; another example of differentiated transliteration is φωτογενής which became photogenic instead of photogenous).
- yard2010 2y agoI have just written an essay about the word water in the sibling post comments. One thing I discovered in the process is that the word water comes to english all the way from Proto Indo European. The word hydro, however, comes from ancient greek, which comes from the same PIE word for water.
- SOLAR_FIELDS 2y agoI would probably avoid naming Firebase alternatives with a prefix like “Super” at this time.
- hyperbrainer 2y agoI am dumb. Why? Was there some failed/controversial thing?
- alabhyajindal 2y agoProbably because of Supabase, I think.
- yard2010 2y ago"Supafecta"
- wccrawford 2y agohttps://en.wikipedia.org/wiki/Superfecta https://en.wikipedia.org/wiki/Superfecta Sounds like someone made up the name to just sound better than trifecta. It's marketing speak. Also, as the link says, it has been used to mean more than four. And other languages use their own equivalent of "quadfecta" instead. Plus, I knew exactly what "quadfecta" meant, but would have no idea about "superfecta".
- nezaj 2y agoThank you James!
- ashconnor 2y agoI always assumed that an architectural decision had prevented relational queries in Firebase. It was jarring to find out that indexes are required for every combination of filters your app applies, but then you quickly realize that Firebase solves a particular problem and you're attempted to shoehorn into a problem-space better solved by something like Supabase. It's not too dissimilar to DynamoDB vs RDB.
- randomdata 2y ago> I always assumed that an architectural decision had prevented relational queries in Firebase. Seems the biggest problem is that Firebase doesn't have relations. How can you query that which does not exist? I'm guessing what they really want is SQL? Once upon a time when I was stuck on a Firebase project I built a SQL (subset) engine for Firebase to gain that myself, so I expect that is it.
- unsupp0rted 2y agoBuilding a logistics app, I wish I could query in Firebase for items that don’t have a “shipped” field. But I can’t.
- randomdata 2y agoTechnically you can: Scan all of the documents. A "relational query language" would have to do the same thing.
- unsupp0rted 2y agoThat wouldn’t be querying though, right? Grabbing all the docs in the db into my controller and filtering down that array is what Firebase makes me do instead of writing queries.
- randomdata 2y ago> That wouldn’t be querying though, right? Why not? You're asking a question, of sorts, and getting an answer from the result. That's the literal definition of querying. > Grabbing all the docs in the db into my controller and filtering down that array is what Firebase makes me do instead of writing queries. A query language is just an abstraction. One you can have in your code. At some point you still need to "grab all the docs into a controller and filter them down", though. You could push that step into the Firebase service, but it would still have to do the same thing you're doing. There is no magic. Better would be to provide something indexable so that you don't have to go through all the docs, but you can't index that which does not exist.
- 999900000999 2y agoThanks for creating Firebase! It's really the definition of an managed database/datastore. Do you see InstantDB as a drop in replacement ? To be honest I don't want to have to worry about my backend. I want a place to effectively drop JSON docs and retract them later. This is more than enough for a hobbyist project, though I imagine at scale things get might not work as well.
- warden_2003 2y agoIf you only need simple dropping and collecting back, maybe you should consider about AWS S3 or Supabase storage.
- 999900000999 2y agoOhh, I still need a database, I just need the JSON doc format.
- deleted 2y ago[deleted]
- ElFitz 2y agoOr a key-value store, if the size is limited and speed is essential.
- stopachka 2y agoFor what it's worth, we designed Instant with this in mind. Schema is optional, and you can save JSON data into a column if you like. If you wanted to store documents, you could write: ``` useQuery({docs: {}}) // get documents transact(tx.docs[docId].update({someKey: someValue}); // update keys in a doc transact(tx.docs[docId].delete()) // delete the doc ```
- 999900000999 2y agoThanks for the response. 2 questions. How hard is it to swap our firebase for instant? I've had an amazing time with firebase, but I sorta want to switch to using a completely local solution. I have a small lyric video generator, and while I don't care about my own songs potentially leaking, I would never want to take responsibility for something else's data. I basically use firebase for the lyrics afterwards I transcribe them . Second, do you offer your own auth or just integrate with other solutions.
- bobbywilson0 2y agoIf we only had doSQL() for everything.
- 650REDHAIR 2y agoWas pretty neat to see your investment/involvement! Made me feel quite old that Firebase is no longer "modern" though...
- Ozzie_osman 2y agoAwesome to see this launch and to see James Tamplin backing this project.
- robertlagrant 2y agoYou probably heard this a million times but I still remember trying that simple firebase demo of draw in one box; see the results in another and being amazed. That was one of my pushes out of boring enterprise software death by configuration and into software creation based on modern OSS products.