mahcha

13 ms·

1. 1.▲
   by mahcha 7d ago

   Hey HN, We building a cross-language library that wraps SQLite and enables it to sync data to a centralized database, with no external service required. It works with the existing SQLite programming model, so applications can continue using
2. 2.▲
   Show HN: SyncLite – Offline-first apps with automatic database sync(youtube.com)

   2 points by mahcha 14d ago|0 comments
3. 3.▲
   by mahcha 2mo ago

   SyncLite currently supports unidirectional replication/consolidation from embedded database to destination database. Reverse path from destination to local db(with conflict resolution) is on the roadmap.
4. 4.▲
   by mahcha 2mo ago

   Each write operation (DDL + DML) is transactionally captured by the synclite logger ( a wrapper over underlying embedded db) and logged into the log file. So, it handles all schema operations create, drop, alter ( add/drop/rename
5. 5.▲
   Show HN: SyncLite – An embedded synchronization layer for SQLite and DuckDB(github.com)

   2 points by mahcha 2mo ago|4 comments
6. 6.▲
   by mahcha 2mo ago

   There is an interesting pattern SyncLite ( https://github.com/syncliteio/SyncLite ) attempts to solve to bring the best of both SQLite and Postgres with one or more SQLite databases directly serving the application while
7. 7.▲
   by mahcha 2y ago

   Hello HN, Thank you for feedbacks on our earlier introductory post about SyncLite, and we have been incorporating it ! Earlier, we posted about a specific case of replicating app-embedded DuckDBs into a centralized PostgreSQL database. We w
8. 8.▲
   by mahcha 2y ago

   While the title mentions about one combination, the framework is generic to handle data consolidation from - numerous applications which may be using one or more popular embedded databases: SQLite, DuckDB, Apache Derby, H2, HyperSQL and - i
9. 9.▲
   by mahcha 2y ago

   Thank you @Terretta for your thoughtful feedback on SyncLite! I appreciate your suggestions for a clearer and more practical introduction. Your version definitely captures the core benefits more effectively, and we will be revising the READ
10. 10.▲
    by mahcha 2y ago

    1. Database Replication/Consolidation for embedded databases used in edge/desktop applications, into centralized databases/a data warehouse/a data lake 2. A Kafka Producer and SQL API for streaming data from edge/de
11. 11.▲
    by mahcha 2y ago

    The framework is generic to handle data consolidation from - numerous applications which may be using one or more popular embedded databases: SQLite, DuckDB, Apache Derby, H2, HyperSQL and - into a wide range of industry leading databases
12. 12.▲
    by mahcha 2y ago

    Thank you @haswell for the feedback! We will improve this further: Here is a brief summary updated in the README at the start: SyncLite is an open-source, no-code, no-limits relational data consolidation platform empowering developers to ra
13. 13.▲
    by mahcha 2y ago

    Thanks @buremba Absolutely agree on "combination of cloud and embedded databases is the future IMO" Universql looks interesting as well. SyncLite also provides an ability to send back custom commands from SyncLite consolidator to
14. 14.▲
    Show HN: Data and Embeddings Consolidation from Edge to Cloud with SyncLite(medium.com)

    1 points by mahcha 2y ago|0 comments
15. 15.▲
    Show HN: SyncLite: A Novel CDC and Replication Framework for Embedded Databases(medium.com)

    1 points by mahcha 2y ago|0 comments