Tag: database

How to insert ,update, delete into MongoDB NOSQL database with Python

How to insert ,update, delete into  MongoDB NOSQL database with  Python Watch this 30 minute video to guide you through this process for my database for my trading system   http://quantlabs.net/blog/2016/01/how-to-insert-update-delete-in-a-mongodb-nosql-database-with-python   Source code: Query #https://docs.mongodb.org/getting-started/python/query/ from pymongo import MongoClient client = MongoClient() # db = client.qln # cursor = db.qln.find({“positions.shortsymbol”: “ibm”}) # # for […]

PostGreSQL database SQL for AK47

PostGreSQL database SQL for AK47   Here is the PostgresSQL entire DDL (data definition language) which will create all structures for tables for my initial AK-47 database. This was created using ‘Export Tables’ out of RazorSQL http://razorsql.com/docs/how_to_export.html I use this tool since it can run on Windows, Linux, and Mac OSX

My PostGres SQL Trading Database DDL Schema

My PostGres SQL Trading Database DDL Schema Here is the current and first version of it to be loaded into PostGreSQL trading ddl postgres sql This is the needed for my entire trading ut this will be tweaked to make it efficient. It is a lazy persons person for testing at the current moment. You should […]