singlestore-labs / start-with-singlestore-python

2 stars 2 forks source link

Getting started with SingleStore and Python

Attention: The code in this repository is intended for experimental use only and is not fully tested, documented, or supported by SingleStore. Visit the SingleStore Forums to ask questions about this repository.

Whether you're using an ORM or straight SQL, you can get started with SingleStore (formerly MemSQL) fast. Here's an introductory sample of using SingleStore with Python. This sample includes all the CRUD methods: Create, Read by id, Read all, Update, and Delete.

Usage

  1. Sign up for a free SingleStore license. This allows you to run up to 4 nodes up to 32 gigs each for free.

  2. Spin up a SingleStore cluster. Choose the deployment strategy that makes sense to you:

    a. Cloud: Start a Managed Service trial and run init.sql.

    b. VMs: Install SingleStore on a supported Linux distribution then run init.sql.

    c. Containers: Grab your license key from SingleStore portal and set it into docker-compose.yaml. Then run docker-compose up to start the cluster and automatically run init.sql.

  3. Adjust the connection details in main.py, pip install -r requirements.txt, and run python main.py.

License

MIT