Pebbling Club 🐧🪨

  • JSON Functions And Operators
    Notes
    The json_extract(X,P1,P2,...) extracts and returns one or more values from the well-formed JSON at X.
    Unfurl
  • Dogsheep | dogsheep.github.io
    Notes
    Dogsheep is a collection of tools for personal analytics using SQLite and Datasette.
    Unfurl
  • SQLite as a document database
    Notes
    This makes it possible to insert JSON straight into SQLite and then have it extract data and index them, i.e. you can treat SQLite as a document database. This has been possible with PostgreSQL and obviously is what something like Elastic provides but having it available in an embedded database is very nice for lightweight stuff.
    Feed
    Unfurl
  • Hosting SQLite databases on Github Pages - (or any static file hoster) - phiresky's blog
    Notes
    "so I implemented a virtual file system that fetches chunks of the database with HTTP Range requests when SQLite tries to read from the filesystem"
    Feed
    Unfurl
  • Your Git Repository in a Database: Pluggable Backends in libgit2
    Notes
    You can actually use a relational or a NoSQL database, or an in-memory data structure, or something like Amazon S3. This is made possible by the pluggable backends provided by the libgit2 library.
    Feed
    Unfurl
  • Dexie.js - Minimalistic IndexedDB Wrapper
    Notes
    A Minimalistic Wrapper for IndexedDB
    Unfurl
  • 10 things I learned from reading (and writing) the PouchDB source
    Notes
    The fact that PouchDB works at all is a tiny miracle.
    Feed
    Unfurl
  • database-antipattern - IndieWebCamp
    Notes
    Using databases for the primary storage of content on your personal site is considered by some in the community to be an antipattern.
    Feed
    Unfurl
  • Doing the SDE Conversions - Fuzzwork Enterprises
    Notes
    I’m not planning on stopping doing these any time soon, as I need them for my own porpoises, but I thought it might be worth having a few instructions out there, so people can run their own conversions of the EVE SDE. Just in case I get hit by a bus, or mauled by crazed Cetaceans.
    Feed
    Embed
    Unfurl
  • RethinkDB - an open-source distributed database built with love
    Notes
    Enjoy an intuitive query language, automatically parallelized queries, and simple administration.
    Feed
    Unfurl
  • CouchDB "Joins" - Christopher Lenz
    Notes
    Obvious to Damien, but not at all obvious to the rest of us: it's fairly simple to make a view that includes both the content of the blog post document, and the content of all the comments associated with that post. The way you do that is by using complex keys. Until now we've been using simple string values for the view keys, but in fact they can be arbitrary JSON values, so let's make some use of that:
    Unfurl
  • Don't use MongoDB | Hacker News
    Notes
    From CTO of 10gen First, I tried to find any client of ours with a track record like this and have been unsuccessful. I personally have looked at every single customer case that’s every come in (there are about 1600 of them) and cannot match this story to any of them. I am confused as to the origin here, so answers cannot be complete in some cases.
    Unfurl
  • Don't use MongoDB
    Notes
    I've kept quiet for awhile for various political reasons, but I now feel a kind of social responsibility to deter people from banking their business on MongoDB.
    Unfurl
  • [from codepo8] HTML5 Rocks - A Simple TODO list using HTML5 IndexedDB
    Unfurl
  • Lucandra: A Cassandra-based Lucene backend « Sematext Blog
    Notes
    "In this guest post Jake Luciani (@tjake) introduces Lucandra, a Cassandra-based backend for Lucene."
    Unfurl
  • SQL pie chart | code.openark.org
    Notes
    "Shown below is a (single query) SQL-generated pie chart. I will walk through the steps towards making this happen, and conclude with what, I hope you’ll agree, are real-world, useful usage samples."
    Feed
    Embed
    Unfurl
  • fault-tolerance.png (PNG Image, 784x393 pixels)
    Notes
    @stlhood Did you just tell me to go eff myself?
    Unfurl
  • Spock Proxy
    Notes
    "Spock Proxy supports range-based horizontal paritioning of a large MySQL database. The proxy intercepts SQL queries from the client, sends queries to the correct databases based on how the database is partitioned, then aggregates the results from each database and returns them to the client as a regular MySQL result set. "
    Unfurl
  • Oracle Database 10g Express Edition
    Notes
    Well... I guess 150MB is actually "small-footprint" for Oracle.
    Unfurl
  • Then each went to his own home - Does del.icio.us scale?
    Notes
    "MySQL is just not built for large tag-systems. It just doesn't scale. It does scale up to 1 Million items but delicious does have far more posts."
    Unfurl
  • PostgreSQL and XML
    Notes
    "Here's a brief outline of the four production-ready XPath functions which represent the most complete XML support of any open source RDBMS."
    Unfurl
  • xsdb - eXtremely Simple Database (100% python database)
    Notes
    Nifty new widget from the creator of Gadfly
    Unfurl