Introduction If you’re just getting started with Redis, there are a few important things you need to know. You probably already understand what Redis is: a lightning-fast, in-memory, key-value data store. You likely know that it’s open source and can be used as a cache, database and message broker. However, these facts don’t necessarily explain … Continued
Introduction Redis and Memcached are two similar data-storage systems. Redis is an open source in-memory key value store, whereas Memcached is a high-performance distributed-memory system. Both systems hold most data in memory and support various operations. Here is a head-to-head comparison of Redis vs Memcached: Memcached Memcached is a simple cache server that allows for … Continued
Introduction When you’re getting started with MongoDB, you don’t always stop to think about certain challenges you may encounter along the way. One important area of concern is security– identifying potential loopholes and knowing how to shield your database from threats should be one of your top priorities. Fortunately, there are a number of best … Continued
Introduction In this article we will learn how to use PL/pgSQL function parameters in PostgreSQL. Prerequisites Basic understanding on PostgreSQL trigger. Ensure that PostgreSQL server is properly installed, configured and running on the background. For Linux and Windows systems you can download PostgreSQL here To start PostgreSQL server use a LINUX machine use the following … Continued
Introduction Much of the data we store in our databases is text and we need advanced ways of filtering it for the exact data we need. Filtering data can become very complex and there are several ways PostgreSQL enables you to search for it. PostgreSQL in particular offers three ways to do pattern matching, LIKE, … Continued
Introduction In this article we’ll be discussing composite primary keys in PostgreSQL. Primary keys are a way to uniquely identify a record. More often than not we use simple arbitrary id numbers that progress sequentially whenever a new record is created. But in certain scenarios you don’t need an arbitrary number to guarantee uniqueness, you … Continued
Introduction In this article we’ll cover what a primary key is in SQL programming languages and go over a concrete example using PostgreSQL. What is a Primary Key A primary key is a column in a table which must have a unique value so that each row in a table has at least one unique … Continued
Introduction The USING command can be quite hard to get a grasp on because it’s difference from other commands that accomplish similar functionality is quite subtle. We’ll spend some time discussing when you might use the USING command because it’s applied in very specific situations. Prerequisites You should have PostgreSQL installed and running. A basic … Continued
Introduction This article will explain how to build a stand-alone Elasticsearch query application using Python. The original Python code used for the app can be found in this ObjectRocket article explaining how to query Elasticsearch documents in a terminal window. Prerequisites 1curl -GET "localhost:9200" -v Building an executable Python script with PyInstaller Installing PyInstaller and … Continued
Introduction This is beginner’s guide to building collections within MongoDB. We will show you basic commands to use when working with collections. Interesting fact: MongoDB will accommodate large documents of up to 16 MB in collections. While we are not going to be building a large collection today, it’s good to know there are limitations … Continued
