KeepThisSite Blog

Add a comment to your pin


It is now possible to add a personal comment to your pins. The system will consider the comment for the search with the same weight as the custom "title".

Preview of the pin result

I changed the design to accommodate the new field in the form, specifically the popup from the bookmarklet.

Preview of the new pin form


Import from SQLite Dump


As announced in the previous post, I finally released the "SQLite dump importer".

It means that you can back up your pins and reimport them in the same account in case of delete them by mistake or in a different account if you wish.

Import screenshot


Export as SQLite


I think that good services let their users export their data as easily as possible, whether to migrate to other services, use themselves, or make their backups (I do backups of my Google Photos with Google Takeout)

According to that idea, I added an option to export your account as an SQLite DB.

Screenshot of the SQLite export view

The SQLite DB does not copy the schema of KeepThisSite internals; it is just a projection with some normalized data in a way that would be helpful for the users.

Currently, the export has three tables, pins, tags, and the join table pin_tags. The pins table contains all the user's introduced data and the data the system collects, like "meta description", the extracted HTML, text, and detected language. There is also a base 64 image. I opted for including URLs for downloading big files like the screenshots and MHTML captures.

As the next step, I am currently working (it's already available)on a process to allow importing the SQLite again so the user can back up its account, perform some destructive action, and restore it from the SQLite.

Quickly post with a bookmarklet


A bookmarklet is available to quickly post URLs to KeepThisSite without losing focus. The bookmark will open a popup and will close automatically after submitting the URL.

You can find the bookmarklet at the right of the "add pin" page.

BTW: You can customize the bookmarklet if you like and know how to on my bookmarklet generator.

What is KeepThisSite?


KeepThisSite is a humble and opinionated bookmarking service. There are several similar services out there, some pretty mature, but only this one is mine.

I am building it because I want to test in a production environment things that I could not try in my daily job. Also, a bookmarking service is something that I would use daily, so I am the first user.

It is free, at least at the moment; probably, I would keep it free forever, at least a basic account. The most expensive feature currently is the full screenshot (which I can optimize) and the MHTL capture.

Some expensive features, like the full screenshot and the MHTML capture, would be only enabled for some users.

I have a long list of features to work on, starting with the UI (browser and edit tags), the web extension (I am already working on it), and boards (private and public), but also other features that are more experimental but exciting in my opinion like allowing the users export and import the account in SQLite (the idea on HN), find relations between links, fetch information from other sources about the link (it's already implemented for HackerNews)

If you are interested, you can sign up in less than 10 seconds; there is already a basic system for importing  Firefox bookmarks. Let me know if you are interested in other formats; the email should appear at the bottom of the page.