{"id":2773,"date":"2019-06-25T14:25:07","date_gmt":"2019-06-25T14:25:07","guid":{"rendered":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/"},"modified":"2022-01-27T19:32:34","modified_gmt":"2022-01-27T19:32:34","slug":"embedded-iot-databases-with-actian-zen-and-python","status":"publish","type":"post","link":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/","title":{"rendered":"Embedded IoT Databases with Actian Zen and Python"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2773\" class=\"elementor elementor-2773\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-99c51b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default qodef-elementor-content-no\" data-id=\"99c51b2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-19d567ac\" data-id=\"19d567ac\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63d4a3b elementor-widget elementor-widget-text-editor\" data-id=\"63d4a3b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 25-04-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h2>Introduction<\/h2><p>In the past, embedded computing was a tiny niche of the software development world. Hardware was expensive, difficult to obtain, and even more difficult to write software for. Fortunately, that is changing. With the introduction of inexpensive, easy-to-use embedded devices like the Raspberry Pi, IoT computing has moved into the mainstream.<\/p><p>While not as small as Arduinos or ESP32-based devices, mini-computers like the Raspberry Pi are small enough in terms of size and power consumption, to embed in a hardware solution like a weather station. With this in mind, we\u2019re going to look at how to use an embedded database \u2013 Actian Zen \u2013 to store and process data on a Raspberry Pi.<\/p><h2>Why an Embedded Database?<\/h2><p>Embedded computers like the Raspberry Pi can talk to a wide variety of sensors. These sensors can measure things like temperature, moisture, wind speed, light levels, heartbeats, motion, acceleration, and even levels of gases like oxygen and carbon dioxide.<\/p><p>When monitoring sensors continually, embedded computers generate a\u00a0<i>lot<\/i>\u00a0of data. Envision a weather station that is measuring temperature, wind speed, humidity, and barometric pressure. If you\u2019re reading data from the sensors every 30 seconds, you\u2019re going to be recording thousands of measurements every day.<\/p><p>You\u00a0<i>could<\/i>\u00a0just set up your embedded device to forward all of its sensor readings to a central server for processing. But you might not want to. Embedded devices like our hypothetical weather station are often operating in remote locations, using mobile internet connections that are slow, unreliable, and expensive.<\/p><p>To ensure that our device doesn\u2019t use too much network bandwidth and is still useful if the network is down, we need a way to store and aggregate data. That\u2019s where Actian Zen comes in. Let\u2019s take a look at how to set up Zen on a Raspberry Pi, and store sensor data in it from a Python application.<\/p><h2>Prerequisites<\/h2><p>The rest of this tutorial is going to proceed on the following:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\">You have a Raspberry Pi with Raspbian Linux installed and running.<\/li><li style=\"font-size: 16px;\">You\u2019re able to use the Linux terminal. You don\u2019t need to be an expert since I\u2019ll tell you exactly what commands to run.<\/li><li style=\"font-size: 16px;\">You understand basic SQL commands like SELECT and INSERT.<\/li><\/ul><h2>Setup<\/h2><p>To get started, you\u2019ll need to download Actian Zen. You can use the web browser on your\u00a0<a href=\"https:\/\/contentlab.com\/dog-mood-detector-with-google-cloud-and-arm-based-raspberry-pi\/\">Pi<\/a>\u00a0to download it directly or download Zen onto your computer and transfer it to your Pi using a USB flash drive.<\/p><p>Start by loading the\u00a0<a href=\"https:\/\/esd.actian.com\/\">Actian downloads page<\/a>. In the Select Via Product dropdown boxes choose the following:<\/p><ul style=\"font-size: 16px; background-color: #ffffff;\"><li style=\"font-size: 16px;\">Product: Actian Zen Community Edition<\/li><li style=\"font-size: 16px;\">Release: V13 R2 Community Edition<\/li><li style=\"font-size: 16px;\">Platform: Raspbian ARM 32-bit<br \/>When you\u2019ve set the filters, you\u2019ll see Zen Edge v13 R2 Community Edition appear below. Click on it, and then click on the blue HTTP button to start your download.<\/li><\/ul><p><img decoding=\"async\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/image001-4.png\" width=\"381px\" height=\"207px\" \/><\/p><p>After the download completes, open up a terminal. On Raspian, you can do this by clicking on the\u00a0<img decoding=\"async\" src=\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/image002-5.png\" width=\"32px\" height=\"23px\" \/>\u00a0icon near the top of the screen.<\/p><p>Next, navigate to the directory where you downloaded Actian Zen. If you downloaded it directly onto the Pi, change to the directory with the following command:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-af1b127 elementor-widget elementor-widget-code-highlight\" data-id=\"af1b127\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>cd ~\/Downloads<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-028188c elementor-widget elementor-widget-text-editor\" data-id=\"028188c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Run this command to unpack Zen:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b019fb4 elementor-widget elementor-widget-code-highlight\" data-id=\"b019fb4\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>sudo tar -C \/usr\/local -xvf Zen-IoT-Community-Linux-13.30-035.000.armhf.tar.gz<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c570ce3 elementor-widget elementor-widget-text-editor\" data-id=\"c570ce3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Zen\u2019s install scripts expect it to reside in the\u00a0<em>\/usr\/local<\/em>\u00a0directory, so that\u2019s where we\u2019ve unpacked it. Next, run the following commands in order:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54e06e5 elementor-widget elementor-widget-code-highlight\" data-id=\"54e06e5\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>sudo apt install unixodbc\r\ncd \/usr\/local\/psql\/etc\r\nsudo .\/preinstall.sh\r\nsudo .\/postinstall.sh<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f4981b elementor-widget elementor-widget-text-editor\" data-id=\"7f4981b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We start by installing the unixodbc package. unixodbc is an Open Database Connectivity\u00a0(ODBC) driver for Unix and Unix-like operating systems. ODBC provides a standard way for applications to connect to databases. We\u2019ll be using it to access Zen from our Python application.<\/p><p>We then change to the psql directory to which we unpacked Zen. Finally, we run Zen\u2019s preinstall and postinstall scripts. Preinstall checks that your system meets the requirements of the version of Zen you\u2019re trying to install. If you download the Raspbian build of Zen, you won&#8217;t encounter any trouble. Postinstall is where the magic happens \u2013 it creates a new psql user, sets up Zen, starts the Zen daemon, creates a DEMODATA database, then fills the demo database with sample data.<\/p><p>Next, we need to run a few more commands as superuser to make Zen accessible via ODBC. A word of caution: running as superuser is potentially dangerous \u2013 if we accidentally run a command to delete our entire filesystem, Raspbian will gladly comply. Be sure to double check the commands you enter before running them.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-991f50b elementor-widget elementor-widget-code-highlight\" data-id=\"991f50b\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>sudo su\r\n\r\ncd \/etc\r\ncat \/usr\/local\/psql\/etc\/odbc.ini >> .\/odbc.ini\r\ncat \/usr\/local\/psql\/etc\/odbcinst.ini >> .\/odbcinst.ini\r\nexit<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b0dd7a elementor-widget elementor-widget-text-editor\" data-id=\"2b0dd7a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>All that we\u2019ve done above is appended Zen\u2019s ODBC configuration data to our system-wide ODBC configuration files. Copying the configuration is what makes it possible for applications to locate and connect to Zen via ODBC. The last exit command makes you no longer a superuser.<\/p><p>There\u2019s one more command we must run:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-743226a elementor-widget elementor-widget-code-highlight\" data-id=\"743226a\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>cat \/home\/psql\/.bashrc >> ~\/.bashrc<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79bc99d elementor-widget elementor-widget-text-editor\" data-id=\"79bc99d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We finish up by appending the data from the psql user\u2019s Bash configuration file to our own user\u2019s Bash configuration file. This adds Zen\u2019s shared libraries to our user\u2019s library load path. Without this step, our Python application won\u2019t be able to find the libraries it needs to connect to Zen.<\/p><h2>Python Application<\/h2><p>We\u2019re going to create a Python 3 application that samples CPU temperature data every 15 seconds and writes it to Zen. Our application will also demonstrate how to query aggregate data from Zen, which is exactly what you\u2019d want to do in preparation for sending the data to a central server.<\/p><p>Before we start writing our application, we\u2019ll need to install a package that enables Python to connect to ODBC databases. In your terminal, run the following:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48b80c2 elementor-widget elementor-widget-code-highlight\" data-id=\"48b80c2\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>sudo apt install python3-pyodbc<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-32dd900 elementor-widget elementor-widget-text-editor\" data-id=\"32dd900\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This command installs a pre-built version of the pyodbc package. With that done, we\u2019re ready to write our app!<\/p><p>To begin, open a text editor of your choice. Raspbian comes with Thonny, which is a lightweight Python IDE. Thonny is a good choice if you\u2019re not sure what to use. I won\u2019t make any assumptions about which editor you\u2019re using, though, so feel free to use something else.<\/p><p>Next, create a directory for your new app. I like to create a projects directory under my home directory, and then keep my projects in it. Here\u2019s how you\u2019d do that:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8b46f7b elementor-widget elementor-widget-code-highlight\" data-id=\"8b46f7b\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>mkdir ~\/projects\r\nmkdir ~\/projects\/zen-iot\r\ncd ~\/projects\/zen-iot<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ce5456c elementor-widget elementor-widget-text-editor\" data-id=\"ce5456c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>These commands create a new directory for your app, and then change the current directory to your new app directory. Keep this terminal window open, because we\u2019re going to use it to run our app.<\/p><p>In your text editor, create a new file, and save it in your app directory as setup.py. Put the following code in it:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c480ebe elementor-widget elementor-widget-code-highlight\" data-id=\"c480ebe\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import pyodbc\r\n\r\nconn_str = \"Driver={Pervasive ODBC Interface};server=localhost;DBQ=demodata\"\r\ndb = pyodbc.connect(conn_str)\r\nc = db.cursor()\r\n\r\nprint(\"Setting up database...\")\r\nc.execute(\"DROP TABLE IF EXISTS cpu_data\")\r\nc.execute(\"CREATE TABLE cpu_data (id identity, timestamp bigint, temperature real)\")\r\nc.execute(\"CREATE INDEX cpu_data_time on cpu_data (timestamp)\")<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e87787 elementor-widget elementor-widget-text-editor\" data-id=\"6e87787\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We start by importing the pyodbc library. Next, we create an ODBC connection string. Although full coverage of ODBC is beyond the scope of this tutorial, you can read more about Zen and OBDC\u00a0<a href=\"https:\/\/docs.actian.com\/psql\/psqlv13\/index.html#page\/odbc%2Fodbcadm.htm%23ww1224120\">here<\/a>.<\/p><p>In the connection string, you\u2019ll notice that we\u2019re using the pre-existing demodata database than Zen created during installation. In a production app, you\u2019d want to create a new database.<\/p><p>Next, we connect to the database and issue three SQL commands: one to drop the table if it already exists, one to create the table, and one to add an index to the table. The index on the timestamp is important because we\u2019ll be querying temperature by timestamp, and the index ensures that lookup will be fast.<\/p><p>Note that we\u2019re using a bigint to store a timestamp instead of a SQL date type. We\u2019re doing this because we\u2019ll be storing the timestamp as Unix time.<\/p><p>Next, create a file in your app directory named\u00a0<em>write.py<\/em>. Add the following code to it:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-83a7ece elementor-widget elementor-widget-code-highlight\" data-id=\"83a7ece\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import time\r\nimport sys\r\nimport subprocess\r\nimport pyodbc\r\n\r\ndef get_cpu_temperature():\r\n  output = subprocess.check_output([\"cat\",\"\/sys\/class\/thermal\/thermal_zone0\/temp\"])\r\n  temp_value = float(output) \/ 1000\r\n  return temp_value\r\n\r\ndef main():\r\n  conn_str = \"Driver={Pervasive ODBC Interface};server=localhost;DBQ=demodata\"\r\n  db = pyodbc.connect(conn_str)\r\n  c = db.cursor()\r\n  insert_command = \"\"\"INSERT INTO cpu_data VALUES (0, ?, ?)\"\"\"\r\n\r\n  while True:\r\n    current_temp = get_cpu_temperature()\r\n    print(\"Saving temperature: {0}\".format(current_temp))\r\n    timestamp = int(time.time())\r\n    c.execute(insert_command, (timestamp, current_temp))\r\n    c.commit()\r\n    c.execute(\"SELECT COUNT(*) FROM cpu_data\")\r\n    row = c.fetchone()\r\n    if row:\r\n      print('Total temperature records:', row[0])\r\n    time.sleep(30)\r\n\r\n    \r\n  return 0\r\n   \r\nif __name__ == \"__main__\":\r\n  sys.exit(main())<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0b88b84 elementor-widget elementor-widget-text-editor\" data-id=\"0b88b84\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We begin by importing pyodbc and several parts of the Python standard library.<\/p><p>Next, we create a function to read the CPU temperature. Since Linux exposes system information as part of the filesystem, we\u2019re going to shell out to the cat command to read the\u00a0<em>\/sys\/class\/thermal\/thermal_zone0\/temp<\/em>\u00a0file. This file contains the current CPU temperature in thousandths of a degree Celsius. To convert it to degrees, we divide it by 1000.<\/p><p>Then, we get to the heart of our application in the main function. The connection string and database the connection are identical to what we saw in setup.py. We then create a SQL command that we\u2019ll use to insert new records into the database.<\/p><p>Finally, we enter a loop that gets the current temperature, writes it to the database, and then waits 30 seconds. This gives us an application that will run forever and record CPU temperature to the database every 30 seconds. In a production IoT Linux app, you would typically set up your application as a systemd service. This makes it easy to ensure that your application will automatically start when the IoT device starts, and will automatically restart if it crashes.<\/p><p>We have one more bit of code to add. In your app directory, create a file named\u00a0<em>read.py<\/em>\u00a0and enter the following code:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5a69bed elementor-widget elementor-widget-code-highlight\" data-id=\"5a69bed\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import pyodbc\r\nimport time\r\n\r\nconn_str = \"Driver={Pervasive ODBC Interface};server=localhost;DBQ=demodata\"\r\ndb = pyodbc.connect(conn_str)\r\nc = db.cursor()\r\n\r\nfive_mins_ago = int(time.time()) - 300\r\nquery = \"SELECT AVG (temperature) FROM cpu_data WHERE timestamp > ?\"\r\nresult = c.execute(query, (five_mins_ago,))\r\nrow = result.fetchone()\r\n\r\nif row:\r\n    print(\"Average temperature over past 5 minutes: {0}\".format(row[0]))<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d15fabc elementor-widget elementor-widget-text-editor\" data-id=\"d15fabc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Here, we\u2019re connecting to the database, calculating a Unix timestamp for five minutes ago, and then running a SQL command to fetch the average CPU temperature over the past five minutes. We then output this value to the terminal.<\/p><p>In a real IoT application, you\u2019d want to send this data off to the cloud or a private server. As discussed earlier, being able to aggregate data and do any necessary calculations on it before transmitting it to a central location is exactly the reason we\u2019d want to use a database like Zen in an\u00a0<a href=\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-c-c\/\">IoT<\/a>\u00a0application.<\/p><p>To run the app we\u2019ve created, run the following commands from your app\u2019s directory:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-428bc9b elementor-widget elementor-widget-code-highlight\" data-id=\"428bc9b\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>python3 setup.py\r\npython3 write.py<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb446d7 elementor-widget elementor-widget-text-editor\" data-id=\"bb446d7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Let this run for 5-10 minutes to save some temperature data into Zen. After that, press CTRL-Z on your keyboard to terminate the app.<\/p><p>Finally, run:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-da69ca7 elementor-widget elementor-widget-code-highlight\" data-id=\"da69ca7\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>python3 read.py<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ca40d92 elementor-widget elementor-widget-text-editor\" data-id=\"ca40d92\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); font-size: 1rem;\">You\u2019ll see your Raspberry Pi\u2019s average CPU temperature over the past five minutes.<\/span><\/p><p>Now that you\u2019re up and running, consider using Zen to store and process more complex sensor data on the Raspberry Pi. If you\u2019re not sure where to start, there are many <a href=\"https:\/\/www.amazon.com\/SunFounder-Modules-Sensor-Raspberry-Extension\/dp\/B014PF05ZA\">inexpensive sensor kits available<\/a> for the Pi. With so many interesting sensors to choose from, you\u2019re bound to come up with something great!<\/p><p><em><span class=\"TextRun SCXW156001673 BCX2\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW156001673 BCX2\">If you\u2019re interested in developing expert technical content that performs, <\/span><\/span><a class=\"Hyperlink SCXW156001673 BCX2\" href=\"https:\/\/contentlab.com\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined SCXW156001673 BCX2\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW156001673 BCX2\" data-ccp-charstyle=\"Hyperlink\">let\u2019s have a conversation<\/span><\/span><\/a><span class=\"TextRun SCXW156001673 BCX2\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW156001673 BCX2\"> today.<\/span><\/span><\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Introduction In the past, embedded computing was a tiny niche of the software development world. Hardware was expensive, difficult to obtain, and even more difficult to write software for. Fortunately, that is changing. With the introduction of inexpensive, easy-to-use embedded devices like the Raspberry Pi, IoT computing has moved into the mainstream. While not as [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":4874,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[276,278,18],"tags":[265,313,312],"hashtags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Embedded IoT Databases with Actian Zen and Python &#183; Technical Content Marketing | ContentLab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Embedded IoT Databases with Actian Zen and Python &#183; Technical Content Marketing | ContentLab\" \/>\n<meta property=\"og:description\" content=\"Introduction In the past, embedded computing was a tiny niche of the software development world. Hardware was expensive, difficult to obtain, and even more difficult to write software for. Fortunately, that is changing. With the introduction of inexpensive, easy-to-use embedded devices like the Raspberry Pi, IoT computing has moved into the mainstream. While not as [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/\" \/>\n<meta property=\"og:site_name\" content=\"Technical Content Marketing | ContentLab\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-25T14:25:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-27T19:32:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1746\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"ContentLab\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ContentLabIO\" \/>\n<meta name=\"twitter:site\" content=\"@ContentLabIO\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ContentLab\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/\"},\"author\":{\"name\":\"ContentLab\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532\"},\"headline\":\"Embedded IoT Databases with Actian Zen and Python\",\"datePublished\":\"2019-06-25T14:25:07+00:00\",\"dateModified\":\"2022-01-27T19:32:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/\"},\"wordCount\":1755,\"publisher\":{\"@id\":\"https:\/\/contentlab.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png\",\"keywords\":[\"IoT\",\"Python\",\"Raspberry Pi\"],\"articleSection\":[\"Databases\",\"Hands-on Tutorial\",\"Portfolio\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/\",\"url\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/\",\"name\":\"Embedded IoT Databases with Actian Zen and Python &#183; Technical Content Marketing | ContentLab\",\"isPartOf\":{\"@id\":\"https:\/\/contentlab.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png\",\"datePublished\":\"2019-06-25T14:25:07+00:00\",\"dateModified\":\"2022-01-27T19:32:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage\",\"url\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png\",\"contentUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png\",\"width\":1746,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/contentlab.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Embedded IoT Databases with Actian Zen and Python\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/contentlab.com\/#website\",\"url\":\"https:\/\/contentlab.com\/\",\"name\":\"Technical Content Marketing | ContentLab\",\"description\":\"Technical Content Marketing Done Right.\",\"publisher\":{\"@id\":\"https:\/\/contentlab.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/contentlab.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/contentlab.com\/#organization\",\"name\":\"ContentLab.io\",\"url\":\"https:\/\/contentlab.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png\",\"contentUrl\":\"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png\",\"width\":768,\"height\":768,\"caption\":\"ContentLab.io\"},\"image\":{\"@id\":\"https:\/\/contentlab.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/ContentLabIO\",\"https:\/\/www.linkedin.com\/company\/17893315\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532\",\"name\":\"ContentLab\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/contentlab.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g\",\"caption\":\"ContentLab\"},\"description\":\"ContentLab provides high-quality written articles, tutorials, courses, and other technical marketing materials to industry leaders. We create no-nonsense tech content that\u2019s purpose-built to attract, educate, and engage your technical audience.\",\"sameAs\":[\"https:\/\/contentlab.op\"],\"url\":\"https:\/\/contentlab.com\/author\/contentlab\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Embedded IoT Databases with Actian Zen and Python &#183; Technical Content Marketing | ContentLab","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/","og_locale":"en_US","og_type":"article","og_title":"Embedded IoT Databases with Actian Zen and Python &#183; Technical Content Marketing | ContentLab","og_description":"Introduction In the past, embedded computing was a tiny niche of the software development world. Hardware was expensive, difficult to obtain, and even more difficult to write software for. Fortunately, that is changing. With the introduction of inexpensive, easy-to-use embedded devices like the Raspberry Pi, IoT computing has moved into the mainstream. While not as [&hellip;]","og_url":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/","og_site_name":"Technical Content Marketing | ContentLab","article_published_time":"2019-06-25T14:25:07+00:00","article_modified_time":"2022-01-27T19:32:34+00:00","og_image":[{"width":1746,"height":530,"url":"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png","type":"image\/png"}],"author":"ContentLab","twitter_card":"summary_large_image","twitter_creator":"@ContentLabIO","twitter_site":"@ContentLabIO","twitter_misc":{"Written by":"ContentLab","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#article","isPartOf":{"@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/"},"author":{"name":"ContentLab","@id":"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532"},"headline":"Embedded IoT Databases with Actian Zen and Python","datePublished":"2019-06-25T14:25:07+00:00","dateModified":"2022-01-27T19:32:34+00:00","mainEntityOfPage":{"@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/"},"wordCount":1755,"publisher":{"@id":"https:\/\/contentlab.com\/#organization"},"image":{"@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage"},"thumbnailUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png","keywords":["IoT","Python","Raspberry Pi"],"articleSection":["Databases","Hands-on Tutorial","Portfolio"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/","url":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/","name":"Embedded IoT Databases with Actian Zen and Python &#183; Technical Content Marketing | ContentLab","isPartOf":{"@id":"https:\/\/contentlab.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage"},"image":{"@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage"},"thumbnailUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png","datePublished":"2019-06-25T14:25:07+00:00","dateModified":"2022-01-27T19:32:34+00:00","breadcrumb":{"@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#primaryimage","url":"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png","contentUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png","width":1746,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/contentlab.com\/embedded-iot-databases-with-actian-zen-and-python\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/contentlab.com\/"},{"@type":"ListItem","position":2,"name":"Embedded IoT Databases with Actian Zen and Python"}]},{"@type":"WebSite","@id":"https:\/\/contentlab.com\/#website","url":"https:\/\/contentlab.com\/","name":"Technical Content Marketing | ContentLab","description":"Technical Content Marketing Done Right.","publisher":{"@id":"https:\/\/contentlab.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/contentlab.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/contentlab.com\/#organization","name":"ContentLab.io","url":"https:\/\/contentlab.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/#\/schema\/logo\/image\/","url":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png","contentUrl":"https:\/\/contentlab.com\/wp-content\/uploads\/2021\/11\/favicon-1.png","width":768,"height":768,"caption":"ContentLab.io"},"image":{"@id":"https:\/\/contentlab.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/ContentLabIO","https:\/\/www.linkedin.com\/company\/17893315\/"]},{"@type":"Person","@id":"https:\/\/contentlab.com\/#\/schema\/person\/e1b8cacc1019e83e8d6cd9ab1a049532","name":"ContentLab","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/contentlab.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3929e740ba8fe876f001a63220500e8e?s=96&d=mm&r=g","caption":"ContentLab"},"description":"ContentLab provides high-quality written articles, tutorials, courses, and other technical marketing materials to industry leaders. We create no-nonsense tech content that\u2019s purpose-built to attract, educate, and engage your technical audience.","sameAs":["https:\/\/contentlab.op"],"url":"https:\/\/contentlab.com\/author\/contentlab\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/contentlab.com\/wp-content\/uploads\/2020\/05\/9.png","_links":{"self":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/2773"}],"collection":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/comments?post=2773"}],"version-history":[{"count":7,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/2773\/revisions"}],"predecessor-version":[{"id":6525,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/posts\/2773\/revisions\/6525"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/media\/4874"}],"wp:attachment":[{"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/media?parent=2773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/categories?post=2773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/tags?post=2773"},{"taxonomy":"hashtags","embeddable":true,"href":"https:\/\/contentlab.com\/wp-json\/wp\/v2\/hashtags?post=2773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}