Get Connected
Where to start with your open source database? Start here.
“Get Connected” represents our body of work on how to start interacting with various open source databases, in the context of specific sample applications, software languages, and database drivers. Why?
Open source databases provide flexibility. Not just to stay up-to-date with the latest software updates or to develop your own features, but to ensure that you have the option of running your database wherever you want and never be locked into a particular company or platform. They also provide lots of documentation, configuration, and options. That can be a good thing for experienced users, but it can be overwhelming for new users looking for simple examples. That’s where we come in. We’re here to get you started.
Collections
Projects
-
MongoDB and the Trouble with DBRefs
Compose ArticlesDBrefs don't work anywhere as well as the name suggests. Join us as we look at the feature that no one should use and why.
-
Cloudant Fundamentals : The _rev token
MediumThe basics of CouchDB-style revision system that make the database unique (part 3 of 10)
-
Cloudant Fundamentals: The _id
MediumUnlocking the mysteries of the unique _id field (part 2 of 10).
-
How Compose does... MongoDB
Compose ArticlesIn this series, we'll look at each of the Compose databases and how & why we configure them.
-
Road Trip Through Database Country
MediumYou have options in the modern database landscape. Let’s go touring..
-
Unstructured data vs Personal Information
Compose ArticlesWith GDPR, we're being reminded how much personal information is scattered through our organizations and databases.
-
Cloudant Fundamentals: The Document
MediumGeneral tips on data modeling (part 1 of 10).
-
Compose Tooltips for MongoDB, PostgreSQL and Elasticsearch
Compose ArticlesWhat's new and interesting in database tooling for Compose users?
-
Failing Over Yourself to Succeed
Compose ArticlesHow to do fully automatic, seamless failover on the various Compose databases.
-
Elasticsearch, Bulk Uploading and the High-Level Java REST Client - Part 2
GitHub | Compose ArticlesHow to use the BulkProcessor to bulk up all your Elasticsearch updates.
-
Etcd and Compose for MySQL - NodeJS Grand Tour
Compose Articles | GitHubThe last leg of the NodeJS journey stopping at etcd and MySQL.
-
Elasticsearch, Bulk Uploading and the High-Level Java REST Client - Part 1
GitHub | Compose ArticlesA practical look at the relatively new High-Level Java REST Client for Elasticsearch uploads.
-
Analyzing Data with IBM Cloud SQL Query
Medium | NotebookEasily make SQL queries on your object storage data.
-
To Scylla and RethinkDB - The Node.js Compose Grand Tour
Compose Articles | GitHubThe Node.js segment of the Grand Tour of database connections continues with Scylla and RethinkDB.
-
Build a Data Catalog in Minutes With IBM Cloud Object Storage
MediumEasily upload datasets and publish metadata (part 1).
-
From Node.js to Redis and RabbitMQ: The Compose Grand Tour
Compose Articles | GitHubWe'll look at connecting to Redis with both popular drivers and plugging into RabbitMQ.
-
Quick Access to IBM Cloud Service Credentials from a Python Notebook
Medium | NotebookSee all your orgs, spaces, and services together in one place.
-
How to stunnel to Redis On-Demand With stunredis
GitHub | Compose ArticlesIntroducing stunredis, a script to turn the trickiness of configuring a TLS/SSL tunnel for Redis into an automated breeze.
-
NodeJS, MongoDB, Elasticsearch and PostgreSQL: The Compose Grand Tour
Compose Articles | GitHubA trip to visit all the databases of Compose with as many languages and drivers as possible.
-
Tuning it up to 11 - Transporter and the Cloudant Adaptor
GitHub | Compose ArticlesRevisiting the simple Cloudant adaptor to make it a bit smarter.
-
Python and Compose - Scylla and Compose for MySQL
Compose Articles | GitHubThe final Python leg of the Compose Grand Tour.
-
Building an API Cache with Redis and Node
GitHub | MediumHow to optimize API usage in a college search example application.
-
Building the Soul of a New Transporter Adaptor
Compose ArticlesTaking the first steps to creating our own Transporter adapter for Cloudant.
-
Easy PostgreSQL Performance Stats with pgHero and Docker
Compose ArticlesPostgreSQL is packed full of stats, but they are not always easy to interpret.
-
Powering PHP With JanusGraph
Compose ArticlesIntroducing the Gremlin-OGM PHP library.
-
Building Your Own Data Transport with Compose Transporter
Compose ArticlesA stodge-free open source ETL tool you can extend in Go. Here's how.
-
Python and Compose - Redis, RethinkDB, and RabbitMQ
Compose Articles | GitHubThe second stop of the Compose Grand Tour in Python.
-
API Caching with Redis and Node.js
Compose Articles | GitHubMake your applications run quickly and predictably.
-
Python and Compose - MongoDB, Elasticsearch and PostgreSQL
Compose Articles | GitHubKicking off the Pythonic leg of the Compose Grand Tour.
-
Code-First Database Design with Entity Framework and PostgreSQL
Compose ArticlesHow to use the Entity Framework in C# to create a table in a Compose PostgreSQL database.
-
Looking inside Books with PostgreSQL's hstore
Compose ArticlesPostgreSQL is versatile. Let's explore hstore, a key-value model that is less-used but conveniently flexible.
-
How to Handle Tagged Data with Redis Sets
Compose ArticlesSets are a powerful data structure in Redis. Learn how to use them to your advantage.
-
Importing Graphs into JanusGraph
Compose ArticlesUsing Gremlin I/O to load existing graph structures into a remote database.
-
Graph 101: Traversing and Querying JanusGraph using Gremlin
Compose ArticlesVertices and edges, oh my! Let's cover some basic graph DB queries.
-
Go and Compose – etcd v3, Scylla, and MySQL
Compose Articles | GitHubThe third and final stop on the Compose Grand Tour for the Go language.
-
Graph 101: Getting Started with Graphs
Compose ArticlesEvaluate if a graph database will work for you, and learn how to import data.
-
Discover Space on Twitter with Elasticsearch and Redis
Compose ArticlesCount Elasticsearch percolated queries using a sorted set. Use Redis to count the number of uniques using HyperLogLog.
-
Go and Compose – Redis, RethinkDB, and RabbitMQ
Compose Articles | GitHubThe second stop on the Compose Grand Tour for the Go language.
-
Go and Compose – MongoDB, Elasticsearch and PostgreSQL
Compose Articles | GitHubHow to connect to every Compose database using Go: The first stop on the Compose Grand Tour.
-
ToolUp: PostgreSQL Studio 2.0
Compose ArticlesUsing PostgreSQL Studio to administer Compose for PostgreSQL in the cloud.
-
Go and Simplifying Scylla with Gocqlx
Compose Articles | GitHubGocqlx does for CQL what the sqlx package does for SQL in Go: make it more manageable. A pit stop on the Compose Grand Tour for Go.
-
Compose Compare: MongoDB vs. PostgreSQL
Compose ArticlesWhich database is the best fit for your project?
-
Getting Started with Compose PostgreSQL and Jupyter Notebooks
Compose ArticlesConnect to Compose PostgreSQL and run a Jupyter Notebook environment within Docker to analyze a Titantic data set.
-
Connecting PHP to Compose for MySQL on Bluemix
Compose ArticlesIt's simple to to connect Compose for MySQL on Bluemix with PHP.
-
Utilizing Etcd3 with Go
Compose ArticlesWith etcd3 powering many cloud applications, it's time to learn how you can use it.
-
From SQL to Scylla - User and Session Management
Compose ArticlesHow SQL database techniques can translate over to NoSQL databases like Scylla.
-
Querying Your PouchDB Database With SQL
GitHub | Medium | npmAdapting the silverlining npm module to work with in-browser database PouchDB.
-
Building a Poem Generator App Using Watson APIs
GitHub | Medium | demoA way with words and code.
-
A Fancier Graph for an Already-Smarter Chatbot
GitHub | MediumUpdating the recipe chatbot demo to use JanusGraph, the latest in graph databases.
-
Mastering PostgreSQL Tools: Full-Text Search and Phrase Search
Compose ArticlesGetting the most out of full-text and phrase search in PostgreSQL 9.6.
-
Push Notifications with MongoDB
Compose ArticlesHow to leverage Compose MongoDB to send more effective push notifications.
-
Querying your Cloudant database with SQL
GitHub | Medium | npmUpdating the silverlining Node.js library to support the basics of SQL.
-
How to Enable a Redis Cache for PostgreSQL with Entity Framework 6
Compose ArticlesCan we cache cheaply and transparently to the application?
-
Integration Testing Against Real Databases
Compose ArticlesThe most fragile part of automated testing is the connection to external systems.
-
Building an Ordering Application with Watson AI and PostgreSQL: Part II
Compose ArticlesIn part II, you'll tie together your services with Node.js and deploy to Bluemix.
-
Building an Ordering Application with Watson AI and PostgreSQL: Part I
Compose ArticlesAn IBM Bluemix application that lets Watson interact with users via Twilio's SMS service, then sends their data over to Compose PostgreSQL.
-
Choosing a Cloudant Library
MediumWhich level of abstraction is just right for you?
-
Mastering PostgreSQL Tools: Filters and Foreign Data Wrappers
Compose ArticlesHow to streamline database imports.
-
Adding a Recommendation Feature to Your App Using a Graph Database
GitHub | MediumGraph user interactions for an even smarter chatbot.
-
Handling Failure Successfully in RabbitMQ
MediumGet your ducks in a row. Design message queues to manage problems.
-
Build Scalable Webhooks with a Queue and Workers Setup
Medium | GitHubGet asynchronous with webhooks + RabbitMQ.
-
Realtime Infrastructure Made Simple
GitHub | Medium | demo | developerWorksLive event updates for your web app with our Simple Notification Service.
-
Deploy Your PHP Application to Bluemix
GitHub | MediumAdd RabbitMQ to your existing app to send notifications.
-
Simple Service Registry: Distributed Config Management for Microservices
GitHub | MediumMicroservices are great, but how do we wire them all together at scale and without downtime?
-
Persisting Data for a Smarter Chatbot
GitHub | MediumYou'll need more than just log data to take your chatbot to the next level.
-
Seven Databases in Seven Days
GitHub | developerWorksA quick tour of (some of) our database services.
-
OSCON Europe Talk Review: Open Source Datastores at Yelp
developerWorks'Building a Powerful Data Tier from Open Source Datastores'
-
Blazingly Fast Geospatial Queries with Redis
GitHub | developerWorks | datasetRedis provides simple commands that you can use like building blocks to assemble your own data structures, including geospatial functions that use lat lon data.
-
Plug into the Cloudant Node.js Library
GitHub | developerWorksJavaScript all the way down.
-
Put Messages into RabbitMQ from Your PHP Application
developerWorksHow to adapt an existing PHP application to create jobs on a queue using RabbitMQ.
-
Real-Time Q&A App With RethinkDB
GitHub | developerWorksGet real-time, with changefeeds in RethinkDB.
-
Get Started With CouchDB Using PHP and Guzzle
developerWorksHow to use CouchDB in PHP applications, using the excellent PHP HTTP library Guzzle.