Tag Archives: MYSQL

Move to MariaDB over MySQL with C++

Move to MariaDB over MySQL with C++

I tried this a while back but had no success but maybe things have improved. What you think? Here are some links to consider:

https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql

 

For OSX Connector with C++:

http://blog.davenicholas.me.uk/2013/04/how-to-c-mysql-mac-osx.html

http://stackoverflow.com/questions/17265471/using-mariadb-in-c

 

HOWTO: MySQL Connector/C++ on Mac OS X

Potential front end GUI

http://www.heidisql.com/download.php?download=installer

https://mariadb.com/kb/en/mariadb/graphical-and-enhanced-clients/

Seems more popular on Mac based on the reviews: http://database-management.softwareinsider.com/l/22/MariaDB

Join my FREE newsletter to learn more about MariaDB vs MYSQL for automated trading 

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!

Oracle says they fixed security..MYSQL ha ha

Oracle says they fixed security..MYSQL ha ha

Judging from my experience with Java 7, this is funny

http://www.computerworld.com/article/2998399/data-security/oracles-larry-ellison-decries-poor-state-of-security-says-he-has-fixed-it.html

But wait, is MYSQL not a Oracle managed product?

http://news.softpedia.com/news/malware-infects-mysql-servers-enrolls-them-in-worldwide-ddos-botnet-495435.shtml

Ellison must tell us secret drugs he takes

Join my FREE newsletter to learn which safe software to use for algo trading 

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!

Karen Super Trader market entry with Interactive Brokers Java API MYSQL on Ubuntu Linux

Karen Super Trader  market entry with Interactive Brokers Java API MYSQL on Ubuntu Linux

Video starts at 50 seconds

This is a full on video on some of the challenges you may run into using Java and Interactive Brokers. It shows how this Karen Supertrader strategy can be used for market entry. Full source code is post for my Quant Elite members

 

Join my FREE newsletter to learn more about automating this Karen Super Trader

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!

MySQL demo with Matlab C Java in Ubuntu Linux

MySQL demo with Matlab C Java in Ubuntu Linux

Well I had problems with Postgres driver issues with Java so I made the switch to get it working faster under these languages

Helpful links:

Java instructions for MYSQL and Ubuntu Linux

C tutorial for MySQL in Ubuntu Linux works

Join my FREE newsletter to see how I proceed with these languages and MYSQL

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!

C tutorial for MySQL in Ubuntu Linux works

C tutorial for MySQL in Ubuntu Linux works

I got this working no problem. I can confirm it looks like I will dump Postgres for MySQL since I got it working with both Java and C. Let’s hope I can do the same with Matlab in my Linux

http://zetcode.com/db/mysqlc/

 

NOTE: You get Matlab working with MYSQL by using http://www.mathworks.com/help/database/ug/mysql-jdbc-linux.html

Join my FREE newsletter to learn more about MYSQL in my automated  trading 

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!

Java instructions for MYSQL and Ubuntu Linux

Java instructions for MYSQL and Ubuntu Linux

Frig, Postgres JDBC driver hell prevented from using it with Java. As a result, I am trying MYSQL. Here are my instructions to get you started:

To install into Ubuntu Linux
https://ariejan.net/2007/12/12/how-to-install-mysql-on-ubuntudebian/

To test with Java:
http://www.vogella.com/tutorials/MySQLJava/article.html

 

These seems to work above for MYSQL

Join my FREE newsletter to learn more about using this technology for trading

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!

Best charts for your open source database? MySQL Postgres?

Best charts for your open source database? MySQL Postgres?

I got this sent over from someone via email who says this may be a good choice for visualizing your data. Thanks to him for sending

Periscope

Type SQL, Get Charts

Periscope plugs directly into your databases and lets you run and share analyses over billions of data rows in seconds

https://www.periscope.io/

Join my FREE newsletter to see how I implement my trading database in PostgreSQL

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!

Ways to use Java Hibernate to connect to MYSQL

Ways to use Java Hibernate to connect to MYSQL
This stuff is sort of easy and standard out of box with Hibernate so this should be enough
http://www.codesolid.com/2013/05/22/a-simple-hibernate-mysql-and-junit-tutorial/

Why I Stick with MYSQL over Postgres?


Join my FREE newsletter to learn more about why I will use this

 

 

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!

Why I Stick with MYSQL over Postgres?

Why I Stick with MYSQL over Postgres?
I may need to stick with my SQL over Postgres or SQL Server is due to a simple but dumb reason. As I plan to heavily travel overseas in the next few years, I anticipate I will need a remote server no different than web hosting. As I have looked around for various out of box database options, the only standard one is MySQL as opposed to Postgres SQL is a more expensive option. I will need this to connect into Trade Manager software which I have download a few months ago. MySQL is the standard database used for this powerful day trading software which is also open source. Also it appears that CentOS is the chosen Linux distribution.
In the last few months, my website has been hacked with major security enhancements for my Windows PC’s. It  Does become a royal pain to maintain as Norton and other unneeded software really slows down my system and makes it very lagging. You get kind of tired of having to face this situation every few months as you experiment with more software. As a result, I am looking towards a Mac environment with a backend running Linux. This obviously means to move away as much as possible from windows technology.  The real tough part is the stellar charting front in libraries you can use like infragistics. Lightning charts or devexpress. There is no doubt that this is where windows rain supreme for anything later around charting and trading software. As the world of Java seems to improve since 1.8, more software I choose is based around this this language. But it always comes down to coming back to good old MySQL but has said just browsing data and now a remote server is needed as well.
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!

Prepping open source Trade Manager link URLs for latest Java 8 JDK MySQL 5.6 Eclipse Luna on Ubuntu Linux

Prepping open source Trade Manager link URLs for latest Java 8 JDK MySQL 5.6 Eclipse Luna on Ubuntu Linux

UPDATE: I decided to abandon the Linux version for to attempt installing a Windows version. I kept getting an exception when it tried to build the database during the build.sh (Application bug but I don’t know) See below for Windows Update issues!

There are required for this Trade Manager

https://quantlabs.net/blog/2014/12/amazing-open-source-java-trade-manager-that-works-with-interactive-brokers-tws/

IMPORTANT NOTE: Read the entire installation directions before implementing at http://code.google.com/p/trade-manager/wiki/Installation

This works now under Windows!

https://quantlabs.net/blog/2014/12/open-source-java-trade-manager-runs-on-windows-for-potential-algoithmic-trading-system/

You could run into priveleges problems!
Latest MySQL 5.6

https://rtcamp.com/tutorials/mysql/mysql-5-6-ubuntu-12-04/

http://unix.stackexchange.com/questions/125327/how-can-i-upgrade-mysql-in-debian-using-apt-get

http://xmodulo.com/upgrade-mysql-server-debian-ubuntu.html]

To change MYSQL root password

https://help.ubuntu.com/community/MysqlPasswordReset

Latest Java JDK 8

http://tecadmin.net/install-oracle-java-8-jdk-8-ubuntu-via-ppa/

Latest Eclipse Luna

https://wiki.opendaylight.org/view/Getting_Started:Eclipse:Installing_Eclipse_on_Ubuntu

 

Strange errors:

./configure : /bin/sh^M : bad interpreter
http://stackoverflow.com/questions/2920416/configure-bin-shm-bad-interpreter

How to set JAVA_HOME in Ubuntu Linux:

http://stackoverflow.com/questions/2920416/configure-bin-shm-bad-interpreter

If you have MYSQL root access problems, try this:

http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y

If I use: mysql -u root -p

enter password like hell1o23, it is fine but still cannot connect into mysql with no password set (?)

http://www.cyberciti.biz/faq/mysql-change-root-password/

This works when you need to verify MYSQL root password changes:

mysql -u root -p’hello123′ -e ‘show databases;’

FOR WINDOWS:

MYSQL is crap now but for Windows, you may come across this:

http://stackoverflow.com/questions/27346487/mysql-installation-unable-to-determine-the-products-that-correspond-with-tha

 

Don’t forget Interactive Broker TWS demo login info:

 

  • For Individual Demo
    • User Name: edemo
      Password: demouser
  • For Advisor Demo
    • User Name: fdemo
      Password: demouser

 

Join my FREE newsletter to learn more about how install high speed open source trading systems on Linux

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!