A bare-bones server that implements a universal back-end for a content management system. Works a little like a key/value store, or a straight JSON store. Implements a JSON HTTP API. Set up the database on the command line by giving it the data spec and then write your code to refer to it. Supports HTTP/2 and Let's Encrypt natively. Can also generate basic HTML for implementing the front-end.
A simple, fully responsive Dashboard to forward to the services of your choice! Ideal for Desktop and mobile usage! Add all of your services, whether you host them yourself or not and display them as neat Icons from the FontAwesome libary. simple-dash is made to be as simple and minimalistic as possible.
Drill down JSON interactively by using filtering queries like jq. Sort of like a CLI JSONpath explorer. Written in Go. Suggestions and autocomplete. Give it JSON somehow and go to it. Has hotkeys, too.
A self-hosted financial manager. It can help you keep track of expenses, income, budgets and everything in between. It supports credit cards, shared household accounts and savings accounts. It’s pretty fancy. You should use it to save and organize money. Does double-entry bookkeeping. Can interface with some banking APIs.
Documentation on how JSON RPC hive files work and what they do.
How to load JSON into a SQLite database all in one go using Python.
SQLite has a JSON datatype, so it's possible to load JSON objects into columns. There still needs to be a unique key for each entry, though.
Datasette provides an instant, read-only JSON API for any SQLite database, even those applications on your system maintain. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now. Got CSV data? Use csvs-to-sqlite to convert them to SQLite. Runs its own webserver on localhost:8001 so you don't need to write code to use it, just point it at a .sqlite3 file.
Requires Python 3.
beekeeper is a Python library designed around dynamically generating a RESTful client interface based on a minimal JSON hive. The hive specification is designed to provide beekeeper (or other applications consuming hive files) with programmatically-designed insight into the structure of both the REST endpoints that are available and the objects and methods that those endpoints represent.
With a properly formatted JSON API hive, beekeeper can automagickally construct and present to you a Pythonic API client. It'll be up to you to analyze what it gives you and best make use of it, but at least it means not having to reverse engineer someone's API yourself.
A complete Python client for the Kodi JSON-RPC API. Supposedly self-configuring so it always uses the stable version for the Kodi box you're contacting. Does all the heavy lifting for you. Even self-documenting: By print'ing your connection instance you can get a list of all of the operations you can carry out.
I think I could use this to make the Kodi bot self-configuring to a certain extent by checking to see what functions were available and adding or removing them from the bot's online docs, as well as frobbing flags to allow or disallow those commands.
Supports password authentication to Kodi instances, too.
A Python module for writing Cloudformation templates. You define stuff in Python and it writes JSON for you.
An open source replacement for the Google News service. REST API using JSON documents. Uses breaking news Twitter feeds as input, but other sources can be added as well. Designed so that you can build your own clients if you want, but has a matching LibreNews application if you want it. Uses MongoDB as its back-end.
json is a command line utility for working with JSON-formatted data on the command line. At its most basic it'll take JSON data, reformat it so that it's easier to work with, and display it in the terminal. It can also be used to extract only certain bits of data from a JSON stream, lint and debug JSON, and filter input in various ways.
Requires node.js, though it isn't a web app.
The API is very similar to that of CouchDB, which makes it easy to add to the HTML of your app.
How to prettify a block of JSON in vim so that it's easier to read. You need to have Python installed for it to work.
An online JSON validator and editor. Short, sweet, and to the point. Also open source, code available at https://github.com/arc90/jsonlintdotcom
A document oriented noSQL database server that uses SQLite as its back end. Written in Python. Network aware. Requires no configuration. Claims to be lightweight.
jq is a command line JSON parser that implements JSONpath syntax for slicing, dicing, and querying arbitrary JSON documents. Perfect for when your favorite online JSONpath expression tester can't handle that two gigabyte JSON dump somebody just gave you to parse...