Database

A photo gallery built on the Skapi database. Every post is a record in the table posts with an image file, a description and tags. The page shows how records are uploaded with files, queried in different orders and connected to each other:

• Posts are uploaded with skapi.postRecord() and fetched with skapi.getRecords(), four at a time.
• A private post is uploaded to the access group private, so only its uploader can read it.
• A like is a record in the table likes that references the post. The reference count of a post is its number of likes.
• A comment is a record in the table comments with the compound index name comment.<record_id>, which is also what "Most commented" is ordered by.
• Subscribing to an uploader adds their posts to your feed, fetched with skapi.getFeed().

Post a photo

Photo Description Tags (optional) Private post (only you can see it) Post