Tag Archives: PostgresSQL

NO SQL Server, stay with PostGresSQL database

NO SQL Server, stay with PostGresSQL database
I also decided not move ahead with SQL Server as well due to uncessary complexities to set up a connection from Matlab. As a result, the notes and caveats are below but I am sticking with PostGreSQL for now as it is very easy to work with and multi platform. It is open source as well which means it is FREE.
http://www.mathworks.com/help/database/ug/microsoft-sql-server-jdbc-windows.html
http://www.mathworks.com/help/database/ug/database.html
For JDBC connection:
http://www.mathworks.com/help/database/ug/microsoft-sql-server-jdbc-windows.html
My Notes and caveats:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9d84f135-ae13-450e-b0b6-87d37576d8f8/sql-server-agent-gives-remote-procedure-call-failed-0x800706be?forum=sqltools
Try opening the SQL server configuration manager with RUN AS ADMIN option and see if that makes any differencofe
Add in the C:\Users\Bryan\AppData\Roaming\MathWorks\MATLAB\R2014a\javalibrarypath.txt contains something like:
C:\Users\Bryan\AppData\Roaming\MathWorks\MATLAB\R2014a\sqljdbc_4.1\enu\auth\x64
The javaclasspath.txt has
C:\Users\Bryan\Downloads\Microsoft JDBC Driver 4.1 for SQL Server\sqljdbc_4.1\enu\sqljdbc.jar
I had to correct:
C:\Users\Bryan\Downloads\Microsoft JDBC Driver 4.1 for SQL Server\sqljdbc_4.1\enu\sqljdbc4.jar

If you the JDBC 4.1, you will get error of
3:01:30 PM com.microsoft.sqlserver.jdbc.SQLServerConnection <init>

SEVERE: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

Use the JDBC4.0 not 4.1!
I created Data Source to SQL Server with sample sa credentials for SQL Server authentication
 

Join my FREE newsletter to learn more about how I use PostGres 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!

LMAX Disruptor model gets less than 1 ms latency for quant development and HFT? Video using open source Java, JBOSS, PostgresSQL

LMAX Disruptor model gets less than 1 ms latency for quant development and HFT? Video using open source Java, JBOSS, PostgresSQL

LMAX – How to Do 100K TPS at Less than 1ms Latency

Summary
Martin Thompson and Michael Barker talk about building a HPC financial system handling over 100K tps at less than 1ms latency by having a new approach to infrastructure and software. Some of the tips include: understand the platform, model the domain, create a clear separation of concerns, choose data structures wisely, and run business logic on a single thread.

http://www.infoq.com/presentations/LMAXgen

Also, the one thing I like about this talk is how they pre-allocated their buffers to optimize and minimize garbage collection. They put everything in a ‘ring buffer’ to minimize GC and optimize their caching. This may eliminate those who doubt Java because of garbage collection.

This has been open sourced as well http://code.google.com/p/disruptor/

After researching, this may become a game change for my solutions?

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!