Tag Archives: PostgreSQL

Back to Postgresql as MongoDB and SQLite fail

Back to Postgresql as MongoDB and SQLite fail

After heavier testing, I kept running into SQLite ‘database is locked’ message all the time. It is really frustrating so I resorted back to MongoDB. When I tried reading in my database with pyMongo Python package, I kept getting no results. I would then reset tthe script, then it would work in a wierd way. It seems to be unreliable so I gave up there. This was the first time I cam across this issue. The latest hacking of MongoDB does not help either. I tried Cassandra but they proved to be unreliable. So here we are. Back to Postgres I go. At least it is more reliable.

Join my FREE newsletter to see which database option proves to be most reliable

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Demo of Using Python to Connect to PostGreSQL trading database

Demo of Using Python to Connect to PostGreSQL trading database

The video below explains it all but be sure to watch the one in showing how I build my PostGres environment, create tables/databases, and populate the data.

http://unix.stackexchange.com/questions/201666/command-to-list-postgresql-user-accounts

https://wiki.postgresql.org/wiki/Psycopg2_Tutorial

Join my FREE newsletter to learn more about using Postgres as my trading database

First video to watch

Demo of using Python to connect to PostGres

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Open source PostGreSQL could replace Oracle Database

Open source PostGreSQL could replace Oracle Database

I still think Redis is the best NOSQL database. I will hopefully replace SQLite with PosgreSQL

Other open source databases that constitute a threat to Oracle also showed gains. PostgreSQL, often mentioned as a possible Oracle replacement, has gained steadily since early 2014.

http://www.infoworld.com/article/3019332/database/oracle-remains-most-popular-database-but-mongodb-continues-to-rise.html

http://db-engines.com/en/blog_post/54

Join my FREE newsletter to learn more about which databases I use for automated trading

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Decent Java tutorial for PostgreSQL

Decent Java tutorial for PostgreSQL

I hope this works for my Interactive Brokers API ‘trading position manager.’

http://zetcode.com/db/postgresqljavatutorial/

Join my FREE newsletter to learn about connecting Postgres with Java 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Decent PostgreSQL C tutorial

Decent PostgreSQL C tutorial

This is for my position and trading order management so hopefully this tutorial will work

http://zetcode.com/db/postgresqlc/

I can verify the above works fine!

This would be good for those who want C++

http://www.tutorialspoint.com/postgresql/postgresql_c_cpp.htm

Join my FREE newsletter to learn how I will implement this database for my automated trading 

 

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

PostgreSQL demo with CPP on Ubuntu Linux

PostgreSQL demo with CPP on Ubuntu Linux

As in the this 20 minute video, I got the last piece working with C++ in Linux. Time for beer again!

There are various links and step descriptions at:

Good Linux connector for PostgreSQL to C++

Here are the sample files that seem to work for me from my Linux cpp-samples

Join my FREE newsletter to learn more about how I planb to deploy more C++ for automated trading 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

How to install PostgreSQL into Ubuntu Linux

How to install PostgreSQL into Ubuntu Linux

This is an excellent guide for the current version of Ubuntu

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-14-04

 

Join my FREE newsletter to learn more on what I plan to do with PostGres in Linux

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Redis NOSQL cache for Postgresql data backend?

Redis NOSQL cache for Postgresql data backend?

I am looking a HUGE datastore. As I really like the PostGres backend capabilities, I am also looking at a cache memory layer like Redis NoSQL. These might be a neat combination to speed up the combination of both a traditional datastore with the ultra cool features NOSQL gives.

https://github.com/pg-redis-fdw/redis_fdw

Join my FREE newsletter if you are ever interested in learning about this cool combo for a future use in trading

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Insert Yahoo FInance forex with Bitcoin data into PostGreSQL Database

Insert Yahoo FInance forex with Bitcoin data into PostGreSQL Database

Cardstock version for forex pairs

Details here with video

This a minor change to focus on pure forex data acquired for the expensive price of free

All source code provided to all my Quant Elite members 

Join my FREE newsletter to learn more where this utility goes 

 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

NEC presents Open Source GPU-Based Acceleration For PostgreSQL with Nvidia In memory database?

NEC presents Open Source GPU-Based Acceleration For PostgreSQL with Nvidia In memory database?

Someone from Skype sent this which I think is quite genius. Just another option to kick around

Thanks for the sender on this

http://www.phoronix.com/scan.php?page=news_item&px=MTg3MTQ

https://github.com/pg-strom/devel

Join my FREE newsletter to see if this gets implemented

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!