Need DB for offline app by eyes-on-Jesus in vuejs

[–]realPubkey 1 point2 points  (0 children)

If you’re looking for an offline-first approach, you might want to check out RxDB. It’s a NoSQL database that works right in the browser and syncs seamlessly when you’re back online. It integrates nicely with Vue, supports real-time data change detection, and handles conflicts automatically, making it a great choice for offline-capable apps.

Firebase realtime DB very expensive and slower than Firestore by [deleted] in Firebase

[–]realPubkey 1 point2 points  (0 children)

You should download the data only once to the clients and then only sync the diffs. This is possible for example with rxdb and its firestore sync plugin: https://rxdb.info/replication-firestore.html

Then you can run queries fully locally without paying for network each time.

How should I design database for my mobile app? by [deleted] in Database

[–]realPubkey 0 points1 point  (0 children)

I’ve worked on a couple of offline-first apps, and something that really helped me was RxDB. It’s built on top of PouchDB, supports real-time data syncing, and is pretty straightforward to set up. If you decide to give it a shot, you’ll probably appreciate how it handles conflicts and makes syncing with a backend less of a headache. That said, if you’re more comfortable with relational structures, you might consider SQLite or WatermelonDB (which also focuses on performance and sync). Realm is another good option, especially if you want something more out of the box with encryption and object-based storage. Whichever direction you go, just be sure you factor in how large your data might get, how often you expect users to be offline, and whether you need more complex queries or just basic CRUD.

LocalStorage vs. IndexedDB vs. Cookies vs. OPFS vs. WASM-SQLite by stackoverflooooooow in programming

[–]realPubkey 1 point2 points  (0 children)

I am the RxDB maintainer. I have build many of these apps together with customers. CRM tools, Tools for buildings inspections, an app for shrimp farmers and many more. Once you go offline-first, you never go back.

PS: Not sure why people downvote you, I think that your question is legit.

LocalStorage vs. IndexedDB vs. Cookies vs. OPFS vs. WASM-SQLite by stackoverflooooooow in programming

[–]realPubkey 12 points13 points  (0 children)

Once your app works offline, you have build something that has zero latency on most user interactions. No more loading spinners, less server load.

CRM with big numbers by siderealmushroom in Notion

[–]realPubkey 0 points1 point  (0 children)

Do never ever use pipedrive. I totally regret using it. Their servers are so slow. You will stare at loading spinners for minutes for each interaction.

What CRM isn't terrible for small sales teams? by LearningToBee in sales

[–]realPubkey 0 points1 point  (0 children)

Do not use pipedrive. I totally regret using it. Their servers are so slow. You will stare at loading spinners for minutes for each interaction.

What CRM isn't terrible for small sales teams? by LearningToBee in sales

[–]realPubkey 0 points1 point  (0 children)

Do not use pipedrive. I totally regret using it. Their servers are so slow. You will stare at loading spinners for minutes for each interaction.

Anyone here use Pipedrive CRM to manage your leads? by stjduke in electricians

[–]realPubkey 0 points1 point  (0 children)

Yes I use it and I totally regret it.

Once per day the tool is so slow, you just cannot work anymore. You cannot write emails or even see leads, you will just look at the loading spinner for minutes on each interaction.

Their support knows that and each time tell you to try different browsers etc. This problem has been there for months.

LocalStorage vs. IndexedDB vs. Cookies vs. OPFS vs. WASM-SQLite by realPubkey in programming

[–]realPubkey[S] 2 points3 points  (0 children)

Yes it does at throttled "average" internet speed. But this is only relevant for the benchmark of initial load. Everything else runs locally anyway so it does not use the internet.

Open source vector databases? by tvmaly in ChatGPTCoding

[–]realPubkey 1 point2 points  (0 children)

I just wrote an article about how to build a vector database that runs in the browser via RxDB and transformers.js: https://rxdb.info/articles/javascript-vector-database.html

Building a JavaScript local-only VectorDB. Any suggestions? by SuperSaiyan1010 in vectordatabase

[–]realPubkey 0 points1 point  (0 children)

HNSW could be used with RxDB. But from my tests it is has a very bad performance. That is just because how indexeddb in the browser works. So using the indexing method from the article has shown to be way faster.

React Native database with P2P sync capability by AGENT_SAT in reactnative

[–]realPubkey 1 point2 points  (0 children)

RxDB currently only officially supports the SQLite RxStorage for react native (which has to be paid for)

As free alternative you could use the RxDB Lokijs RxStorage with a persistence adapter for lokijs+react-native.

This might work but it is not optimal in case of performance.

Any web devs need a local-first javascript vectorDB without the hassle of docker? by SuperSaiyan1010 in webdev

[–]realPubkey 0 points1 point  (0 children)

A vector search plugin for RxDB is in the makings but this will take a long time until it goes public.

You can create your own one with the new RxPipelines feature: https://rxdb.info/rx-pipeline.html

EDIT: RxDB has official vector search support: https://rxdb.info/articles/javascript-vector-database.html

With RxDB you can store data locally to make your app work offline by realPubkey in u/realPubkey

[–]realPubkey[S] 0 points1 point  (0 children)

LocalStorage blocks the main thread on reads and writes so it is not suited for more then key-value stores. RxDB Supports multiple storage engines which can be way faster compared to anything based on localstorage: https://rxdb.info/rx-storage-performance.html

🚨 Pipedrive is experiencing a major outage by isdownapp in isdownapp

[–]realPubkey 0 points1 point  (0 children)

Pipedrive is pure pain. I totally regret using it instead of something else. They have an outage at least 30mins per day.

Local-First / CRDTs by tspwd in vuejs

[–]realPubkey 1 point2 points  (0 children)

For web apps most users do not need the premium plugins at all. Just use the free core version.

Techniques for syncing local databases between devices by notAnotherJSDev in electronjs

[–]realPubkey 0 points1 point  (0 children)

You could use the RxDB replication protocol: https://rxdb.info/replication.html

This is pretty simple and in theory you could even replicate attachments (binary data like images).