Introduction to the _mapping schema for Elasticsearch schema The _mapping of an index in Elasticsearch is the essentially the schema for the documents. It’s the layout of the index’s fields that sets up a blueprint for storing and organizing fields, and their respective data, when documents are indexed to the Elasticsearch index. Getting the mapping … Continued
Introduction to Elasticsearch and Python The Python low-level REST client for Elasticsearch maps closely to the Java API for the Elasticsearch client. This article demonstrates how you can use the client to create a _mapping schema for a document with an encoded bytes string, and then index an encoded dictionary. The article will demonstrate how … Continued
Introduction MongoDB stores its data (known as “documents”) by grouping them in collections that are themselves stored in a database. This article will help you to create database and collection names for a MongoDB server, and then it will help you to retrieve the database and collection names, in Python, with some example code. Prerequisites … Continued
Introduction Part one of this series demonstrated how you can use Python to crawl for files in a directory, and then use the os library’s open() method to open the files and return their content as string data. This article will show you how to use the helpers module, in the low-level Python client, to … Continued
Introduction One useful feature of Python is its built-in os and glob libraries that allow you to get files in a directory and read their content. This article will show you how to use Python to index files and their content, found using glob, in order to index the data in an Elasticsearch index. Let’s … Continued
Introduction to the psycopg2 adapter When you connect to PostgreSQL in Python, using the psycopg2 Python adapter, you can created a cursor that allows you to execute SQL statements. This article will demonstrate how to use the SELECT SQL keyword, and the fetchall() psycopg2 method, to return all of the records, iterate the rows, and … Continued
Introduction The psycopg2 Python adapter for PostgreSQL has a library called extensions has polling and status attributes to help you make your PostgreSQL application more efficient by better monitoring and managing the transactions taking place. This article will provide a brief overview of how to get the status of a transaction with the psycopg2 adapter … Continued
Introduction This article will provide a brief overview of how you can better handle PostgreSQL Python exceptions while using the psycopg2 adapter in your code. Make sure that the psycopg2 package is installed on your machine using the PIP3 package manager for Python 3 using the following command: 1pip3 install psycopg2 We’ll also be building … Continued
Introduction to Cursors in PostgreSQL If you’re writing code that interacts with PostgreSQL using Python or PHP, you’ll probably want to use cursors in your scripts. A PostgreSQL database cursor is a read-only pointer that allows a program, regardless of the language used, to access the result set of a query. This conserves the free … Continued
Introduction to the psycopg2 Python adapter for PostgreSQL When you connect to PostgreSQL from a Python script, you can do much more than just query the database. You can insert rows into a table, create a new table and even create a new database. The psycopg2 adapter is a library that simplifies making SQL queries … Continued
