Please provide your feedback in this short Flings' survey.
fling logo of SQL30 - An ORM for SQLITE on ESX

SQL30 - An ORM for SQLITE on ESX

version 1.0 — September 30, 2020

Contributors 1

View All

Comments 0

View All

Summary

Persistence is an integral part of any real world software application. A widely used method of achieving (file based) persistence is through SQLITE database. Python natively provides support for interacting with SQLITE with the help of module "sqlite" (sqlite3 in python3). SQLAlchemy is a popular ORM used for interacting with sqlite database in Python. However, this and many other similar ORMs do not work on ESX Hypervisor as is. It is because these packages have dependency on other packages which are not supported / installable on ESX hypervisor further.

In this fling, we present SQL30, a ZERO weight ORM for SQLITE database written using only native python constructs. This python package has no dependency on any external python package and works as is on ESX version 6.5 and above.

SQL30 is useful as :

  • It helps developers achieve persistence in Python applications even on platforms such as ESX which have limited / trailing support for Python.
  • It improves productivity as developers can write (SQL based) database applications without having to learn SQL itself.

Requirements

Python and sqlite
(Both are available as of now on ESX 6.5)

Python is still 3.5 version on ESX 6.5 , while widely used on now is Python 3.6. However, beauty of this fling submission is that it works with very limited support of Python as well.

Instructions

Installation

SQL30 python package, sql30.egg, with applicable license can be downloaded from fling site under the file name sql30.zip. The package can also be built locally with the steps below or installed directly from pypi server ( https://pypi.org/project/sql30/ ). However, the license attached (in sql30.zip) would still be applicable to this fling.

$ virtualenv -p python3 . 
$ mkdir unpacked
$ bin/pip install --target=./unpacked/ sql30
$ cd unpacked
$ zip -r9 ../sql30.egg *
$ cd -
# 

sql30.egg file generated by above steps can now be taken and used with any machine with python3 and sqlite3 (python module) available. An example of the same is shown below. Here sql30.egg is being taken to an ESX Hypervisor with a Python 3.5.6 version and shown to consume egg file.

[root@prom-0505695d9ce:~] PYTHONPATH=sql30.egg python
Python 3.5.6 (default, Feb  2 2019, 01:09:51)
[GCC 4.6.3] on linux
Type "help", "copyright", "credits" or "license" for more information.
No entry for terminal type "screen.xterm-256color";
using dumb terminal settings.
>>> from sql30 import db
>>> import os
>>> os.system('uname -a')
VMkernel prom-0505695d9ce.nsbucqesystem.test 6.5.0 #1 SMP Release build-13753126 May 19 2019 21:13:25 x86_64 x86_64 x86_64 ESXi
0
>>> class Dummy(db.Model):
...     pass
...
>>> dir(Dummy)
['DB_SCHEMA', 'VALIDATE_BEFORE_WRITE', '__class__', '__delattr__', '__dict_




Contributors

Similar Flings

No similar flings found. Check these out instead...
Sep 16, 2020
fling logo of vRealize Network Insight and HCX Integration

vRealize Network Insight and HCX Integration

version 1.0

This integration script between vRealize Network Insight (vRNI) and VMware HCX, allows you to streamline the application migration process.

Mar 09, 2022
fling logo of VMware Event Broker Appliance

VMware Event Broker Appliance

version 0.7.2

The VMware Event Broker Appliance (VEBA) Fling enables customers to unlock the hidden potential of events in their SDDC to easily event-driven automation based on vCenter Server Events

Mar 30, 2022
fling logo of vSphere Diagnostic Tool

vSphere Diagnostic Tool

version 1.1.4

vSphere Diagnostic Tool is a python script that runs diagnostic commands on the Photon Appliance or ESXi platform to return useful troubleshooting data while running within the confines of the local environment with out upstream dependencies.

Nov 11, 2015
fling logo of Auto Deploy GUI

Auto Deploy GUI

version 5.0/5.1/5.5/6.0

Auto Deploy GUI is a front end interface to the Auto Deploy/Stateless infrastructure.

Apr 20, 2022
fling logo of Horizon Peripherals Intelligence

Horizon Peripherals Intelligence

version 3.0

Horizon Peripherals Intelligence is an online self-serviced diagnosis service that can help increase the satisfaction when using peripheral devices with Horizon product by both the end users and the admin user. Currently, we support diagnosis for the following device categories – USB storage devices, USB printers, USB scanners, Cameras. We will continue to cover more device categories in the future.

Jul 19, 2016
fling logo of VMware Modified Enhanced SCAP Content Editor

VMware Modified Enhanced SCAP Content Editor

version 1.0

VMware Modified Enhanced SCAP Content Editor is an updated version of the Enhanced SCAP Content Editor too by G2, Inc, and is an open source project, vmware-scap-edit, on GitHub.

View More