Note: This section of the site is under heavy construction, tread carefully.

Bookmarks tagged with “database”

91 bookmarks by garrettc


Django filter - filter(A).filter(B) vs filter(A, B)

"Sometimes, when chaining filters together – SomeModels.objects.filter(a=A).filter(b=B) – we get duplicate objects in our queryset. In this article, we’ll explore & explain why."

Bookmarked on #



pgloader

"pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL"

Bookmarked on #


Supabase

The Open Source Alternative to Firebase.

Bookmarked on #


Scaling Django with Postgres Read Replicas

"Replication is a feature of PostgreSQL that you typically use to achieve high availability by running copies of a database that are ready to take over if your primary database fails. However, you can also use replication to make your Django applications faster. In this post, I’ll explain how to configure Django to query read-only Postgres replicas, allowing you to scale your database read performance linearly with the number of replicas."

Bookmarked on #



Typesense | Fast, typo-tolerant open source search engine

"… an open source, typo tolerant search engine that is optimized for instant sub-50ms searches, while providing an intuitive developer experience."

Bookmarked on #



The Technium: The Tiny Web

The history of the Whole Earth Catalog CD ROM.

Bookmarked on #


The Electronic Whole Earth Catalog : Stewart Brand, Kevin Kelly, Broderbund Software

"The Electronic Whole Earth Catalog is a very early CD-ROM presentation of The Whole Earth Catalog. Utilising HyperCard, The Electronic Whole Earth Catalog consists of over 9000 cards connected to one another with hypertext; essentially the web before the web existed, but offline! "

Bookmarked on #


PokéAPI

"All the Pokémon data you'll ever need in one place, easily accessible through a modern RESTful API."

Bookmarked on #


Lesser Known PostgreSQL Features

"Most of us are not aware of all the features in tools we use on a daily basis, especially if it's big and extensive like PostgreSQL. With PostgreSQL 14 released just a few weeks ago, what a better opportunity to shed a light on some lesser known features that already exist in PostgreSQL, but you may not know."

Bookmarked on #




Passenger Search - The Statue of Liberty & Ellis Island

"Welcome to our free Ellis Island Passenger Search database, home to 65 million records of passengers arriving to the Port of New York from 1820 to 1957"

Bookmarked on #



Local Docker databases

A collection of Docker Compose files to quickly spin up local databases of various sorts.

Bookmarked on #



Supabase

An Open Source Firebase alternative

Bookmarked on #


Generating JSON Directly from Postgres

Simplify web tiers by pushing JSON creation to the database.

Bookmarked on #


Globally Distributed Postgres · Fly

“This is a story about a cool hack we came up with at Fly. The hack lets you do something pretty ambitious with full-stack applications. What makes it cool is that it’s easy to get your head around, and involves just a couple moving parts, assembled in a simple but deceptively useful way. We won’t bury the lede: we’re going to talk about how you can deploy a standard CRUD application with globally-replicated Postgres, for both reads and writes, using standard tools and a simple Fly feature.”

Bookmarked on #


Modeling Polymorphism in Django With Python

Modeling polymorphism in relational databases can be a challenging task, but in this article, you'll learn several modeling techniques to represent polymorphic objects in a relational database using the Django object-relational mapping (ORM).

Bookmarked on #


Nocodb

Free & Open Source Airtable alternative. Turns any SQL database into a smart spreadsheet. Supports MySQL, Postgres, SQL server, MariaDB & SQLite.

Bookmarked on #


Django SQL Dashboard

an interface for running arbitrary read-only SQL queries directly against a PostgreSQL database, protected by the Django authentication scheme

Bookmarked on #



litestream

Streaming S3 replication for SQLite.

Bookmarked on #


Falsehoods Programmers Believe About Names – With Examples

"In 2010, Patrick McKenzie wrote the now-famous blog “Falsehoods Programmers Believe About Names”, in which he listed 40 things that were not universally true about names. Did programmers sit up, take notice and change their attitudes to names? Sadly, not really. We still get asked to fill our names out in online forms which assume we have a first name and a last name (in that order) and which refuse to allow us to continue unless we have filled out both. They assume our names can be entered in alphabetic characters, often only ASCII. I fear that part of the reason that this blog post had less impact than I hoped was that Patrick did not give examples of how each assumption can be false. But having worked in a previous life on IBM’s Global Name Management product, I can assure you that it’s all true. Still not convinced? In this post I’m going to list all 40 of Patrick’s original falsehoods, but give you an example (or two) drawn from my experiences working in this space."

Bookmarked on #


Hasura

"Instant realtime GraphQL APIs on PostgreSQL"

Bookmarked on #


SQL queries don't start with SELECT - Julia Evans

SQL queries don't start with SELECT

Bookmarked on #



Monica

Monica lets you remember everything about your loved ones.

Bookmarked on #



Select Star SQL

“An interactive book which aims to be the best place on the internet for learning SQL. It is free of charge, free of ads and doesn't require registration or downloads. It helps you learn by running queries against a real-world dataset to complete projects of consequence. It is not a mere reference page — it conveys a mental model for writing SQL.”

Bookmarked on #



geomesa

"GeoMesa is an open source suite of tools that enables large-scale geospatial querying and analytics on distributed computing systems. GeoMesa provides spatio-temporal indexing on top of the Accumulo, HBase, Google Bigtable and Cassandra databases for massive storage of point, line, and polygon data. GeoMesa also provides near real time stream processing of spatio-temporal data by layering spatial semantics on top of Apache Kafka. Through GeoServer, GeoMesa facilitates integration with a wide range of existing mapping clients over standard OGC (Open Geospatial Consortium) APIs and protocols such as WFS and WMS. GeoMesa supports Apache Spark for custom distributed geospatial analytics."

Bookmarked on #


XMySQL

One command to generate REST APIs for any MySql Database.

Bookmarked on #


Database Flow

"Database Flow is an open source self-hosted SQL client, GraphQL server, and charting application that works with your database. Visualize schemas, query plans, charts, and results. You can run Database Flow locally for your own use, or install to a shared server for the whole team."

Bookmarked on #




VinylHub

Every record shop in the world

Bookmarked on #




Interactive Database of the World's River Basins

"This database provides the first-ever compilation of the world’s river basins developed specifically for corporate disclosure. It features a comprehensive list of river basins worldwide, including their names, boundaries, and other helpful information."

Bookmarked on #


Make Your Company Data Driven | Redash

Use Redash to connect to any data source (Redshift, BigQuery, MySQL, PostgreSQL, MongoDB and many others), query, visualize and share your data to make your company data driven.

Bookmarked on #


Supercook: recipe search by ingredients you have at home

Supercook is a recipe search engine that lets you search by ingredients you have at home. Find thousands of recipes you can make right now with the ingredients you have available at home. Supercook can help you save hundreds on grocery bills by showing you how to fully use the ingredients you have at home. No more wasted left-overs. Asian,Breads,Breakfast,Cakes,Caribbean,Casseroles,Cookies,Desserts,Dinner,Dips,Drinks,Fish recipes,Grilling & BBQ,Indian & Thai,Italian,Kid Friendly,Meat recipes,Mediterranean,Mexican,Poultry recipes,Quick & Easy,Salad Dressings,Salads,Sandwiches,Sauces,Seafood recipes,Slow Cooker,Soups,Veggie recipes

Bookmarked on #


PouchDB & CouchDB: An interview with Nolan Lawson

"With so many databases out there to choose, it’s hard to know which one will work best with your project’s infrastructure. Nolan Lawson, software developer and core maintainer of the popular JavaScript database PouchDB, understands firsthand the importance of examining a database’s tradeoffs before implementing it into your stack. He recently offered us some of his database insights."

Bookmarked on #


Tableau Software

Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations, and share with a click.

Bookmarked on #


Sqlectron

A simple and lightweight SQL client desktop/terminal with cross database and platform support.

Bookmarked on #


A beginner’s guide to ACID and database transactions

Introduction Transactions are omnipresent in today's enterprise systems, providing data integrity even in highly concurrent environments. So let's get started by first defining the term and the context where you might usually employ it. A transaction is a collection of read/write operations succeeding only if all contained operations succeed. Inherently a transaction is characterized by…

Bookmarked on #