External backup (synchronization of bookmarks) in Baserow

[Kovah]

This topic continues the discussion of a post from the old community forum: "External backup (synchronization of bookmarks) in Baserow" by vehijew117
A backup of the full conversation can be viewed on the Internet Archive.

---

Is your feature request related to a problem? Please describe.

1. I'm frustrated with Raindrop, the official Raindrop page said that Raindrop was from the open source community, but that's not true.
2. If you go to their github, there is no repository with the backend code. In other words, the code posted there on official github is just the frontend. This is interesting, but I wanted the backend code. To understand the logic, data structure and database used.
3. I have been a php language programmer for exactly 5 years. I was impressed and excited by the idea of an open source bookmark manager, as Raindrop claimed to be open-source and in fact it wasn't as it didn't have the full back-end code.
4. I said that I am a php programmer as I had a similar idea to Linkace for managing my bookmarks, but it was just my idea and I used it internally for a few years. I had no plans to monetize the program, I just did it for myself. However, this would take time and I would have to test and have more resources to do something cool. What I always liked about Raindrop was the possibility of external backups, filters and smart search.
5. I have a feeling that the database Raindrop uses is PostgreSQL or MongoDB . But the truth is, I don't know which database they use. It's a kick, a vain attempt at curiosity.
6. Every project I do or participate in is usually unique. Despite having known and done some work with MariaDB, SQLite, MySQL at some point, I have more security with these databases: Redis, PostgreSQL, MongoDB and my experience and knowledge are for these databases.

Describe the solution you'd like

1. It would be nice to have an offsite backup option. For this to be possible, we must have the synchronization of bookmark data in Google Sheets, Airtable or Baserow.
2. The only problem I see is the limit of rows in the Google Sheets spreadsheet, which is over 1 million rows (+ -). In turn, the Airtable limit is 1,200 lines per base. That is, you can create multiple tables as long as they don't exceed 1200 rows. If it exceeds 1200 rows, you would have to make more databases, that is, more tables. This limit is on the free plan.
3. It would not be a good option to sync with Google Sheets or Airtable, because of the limit of rows you can create.
4. An alternative for now is Baserow, which does not limit the number of rows, columns or tables. It's free, open source.
5. This external backup is great, in case there is a problem in the database or the data is lost due to a possible failure in the server's processing. A good example of this feature is Raindrop, which offers the synchronization of Bookmarks on Dropbox and Google Drive in the paid plan. In my view, it doesn't make sense. Because, Baserow is free and there is no limit on rows, columns or tables. In addition, Baserow has an api for querying these data with intelligent filters: date, data type (number, email, text, boolean...).

Describe alternatives you've considered

1. I'm thinking about helping the LinkAce community as it's the only software I know of that is written in php and is as good as Raindrop. One of the features to make LinkAce more competitive and closer to Raindrop would be the external backup of Baserow.
2. Another thing, there is no file limit. Under the terms of the security policy, the data is encrypted and you are the only one who has access. Baserow seems to be a great alternative to Google Sheets, Excel and Airtable.
3. We can combine something useful with something pleasant. It's always good to have to have an ace up the sleeve.
4. I can make this feature or someone else can implement it, whichever is best for the community.
5. I think in this architecture, we have a local database and a remote database (which is a copy of the local database). We can configure the backup to be something monthly, weekly, yearly or just sync the data. This is useful to ensure data integrity and availability. Besides being useful to avoid any data loss. Since we have a backup for that.
6. If you are a mac user, there is a feature option called time machine. The offsite backup feature is similar to time machine. I mentioned the time machine feature, as it is a working example of what I wanted to do in the future.
7. It may be possible to create a LinkAce app if it has synced with Baserow.
8. There is a php library that synchronises the data in Baserow via an api and token.

My idea(now, present)

https://www.seguetech.com/wp-content/uploads/2013/06/segue-blog-considerations-planning-sql-server-database-backup-restore-strategy.png

Baserow(External backup (synchronization of bookmarks) <-> Local Database(SQLITE/ PostgreSQL)

My idea(future)

Baserow <-> Local Database(SQLITE, local backup) <-> Remote Database(PostgreSQL, persistent storage) <-> Logs Database(Mongodb)

• External backup(Baserow)
• Google Cloud(Remote Database)
• Google Cloud(Logs Database, temporary)

Benefits

1. Baserow is free, open source and private. There is no limit or amount of files to make upload, save. There is no limit or amount of rows, columns in any free and paid plan.
2. Great option to be an external backup to guarantee the integrity and availability of data. Also to avoid any possible loss of data.
3. There is a php library that can make this possible.
4. Competitive advantage over Raindrop, best cost and benefit.
5. Keep a history of modifications.

Additional context
Add any other context or screenshots about the feature request here.

• https://baserow.io/
• https://www.google.com/sheets/about/
• https://www.airtable.com/
• https://baserow.io/docs/getting-started/api
• https://spreadsheetpoint.com/google-sheets-limitations/
• https://packagist.org/packages/stevecomrie/baserow-php
• https://support.apple.com/en-us/HT201250
• https://github.com/raindropio
• Self Hosted Server Support raindropio/mobile#4
• https://support.mozilla.org/en-US/kb/profiles-where-firefox-stores-user-data
• https://wiki.mozilla.org/images/d/d5/Places.sqlite.schema3.pdf
• https://wiki.mozilla.org/images/0/08/Places.sqlite.schema.pdf

Interesting and futuristic features

• https://github.com/eppineda/sqlite-bookmarks
• https://github.com/kriukov/gethist
• https://gist.github.com/dropmeaword/9372cbeb29e8390521c2
• https://gist.github.com/iafisher/d624c04940fa46c6d9afb26cb1bf222a
• https://github.com/mehdidc/bm
• https://gist.github.com/iafisher/d624c04940fa46c6d9afb26cb1bf222a
• https://github.com/Dissimilis/BookmarksManager
• https://github.com/websafe/ffbx
• https://github.com/spk/marquetapage