Tag Archives: SQL

Microsoft release SQL Server preview for Linux

Microsoft release SQL Server preview for Linux

I say who cares? I am not interested in paying out annual licensing fees no more. Hail NOSQL

Thanks to an old pal who now a big a whig at a company in Seattle but not MS

Join my FREE newsletter to learn more about how NOSQL will help in automated trading

Microsoft releases SQL Server Preview for Ubuntu and Red Hat Enterprise 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!

SQL is slow for analysis but use dplyr

SQL is slow for analysis but use dplyr

There goes that idea but could this be done with Redis?

https://blog.exploratory.io/why-sql-is-not-for-analysis-but-dplyr-is-5e180fef6aa7#.nfciyobza

Join my FREE newsletter to learn more about R with 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!

To SQL or NOSQL? Easy choice with MongoDB

To SQL or NOSQL? Easy choice with MongoDB

AS I have said over the last few months, I go with MongoDB NOSQL for various reasons. I just did a live talk/tutorial on it how I will use it for my automated trading solution.

Get access here

Python algo course series for your Indie Automated Trading Business

http://arstechnica.com/information-technology/2016/03/to-sql-or-nosql-thats-the-database-question/

Join my FREE newsletter to learn about using NOSQL for your 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!

PostGres SQL in Docker but I use NOSQL

PostGres SQL in Docker but I use NOSQL

From Super Fan Nuno who sent this but I must say I am now using NOSQL MongoDB as I my choice for persistance. See my video playlist below on why. Thanks to Nuno

Persistent PostgreSQL inside Docker

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

PostGres SQL scares me on Mac OS X

PostGres SQL scares me on Mac OS X

Here is why with this dumb error message. It just happened out of the blue or from a Brew Uprade. Either way, it is not safe to use nor stable.  As a result I am going back SQLite. This will be useful for my very old Mac Minis as SQLite is much smaller compared to PostGres

http://stackoverflow.com/questions/8465508/can-not-connect-to-local-postgresql

http://stackoverflow.com/questions/8465508/can-not-connect-to-local-postgresql

http://stackoverflow.com/questions/10763143/in-rails-couldnt-create-database-for-adapter-postgresql/19609228#19609228

Ugh. See which databases I use for my automated trading by joining my FREE newsletter

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!

Walkthru of Karen Super Trader strategy with CSharp Postgres SQL IQFeed and IB

Walkthru of Karen Super Trader strategy with CSharp Postgres SQL IQFeed and Interactive Brokers

I have finally finished off the new Karen Super Trader strategy in .Net with IQFeed and Interactive Brokers connectivity I have completed an entire 45 minute walk through video of the entire code.

 

Go here to see the video

 

LIVE Q&A Meetup: Walkthru of Karen Super Trader strategy with source code

I will also be scheduling a LIVE Meetup event to handle all your questions and answers next Monday. This is the only time where I will be able to do it so please attend.  Do note that I will not be having any video playback at all which is exclusively only for my Quant Elite members.

 

Go here to see the details of this event online

 

Lastly, if you are interested in retrieving the code:

 

Go here for immediate access

 

If you’re not familiar with my Quant elite membership, go here for details and benefits

 

Thanks for reading

 

Bryan

 

PS. I just posted last night’s webinar on the tools that I use for both IQFeed and Interactive Brokers TWS

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!

Walkthru of Karen Super Trader strategy with CSharp Postgres SQL IQFeed and Interactive Brokers

Walkthru of Karen Super Trader strategy with CSharp Postgres SQL IQFeed and Interactive Brokers

Finally it has been pulled together to complete this potential real world trading strategy. This C# code has been posted for my Quant Elite Members. You can use this as role model for your own trading strategies or algorithms!

Join my FREE newsletter to learn more about this code for your automated trading systems 

Complete walkthrough

Part 1 is here

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 MySQL C Insert Java Select with Positions Database Table

Demo MySQL C Insert Java Select with Positions Database Table

A nice a combo of MYSQL calls

Join my FREE newsletter to to learn how much 

 

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!

N1QL SQL for NOSQLCouchbase database

N1QL SQL for NOSQLCouchbase database

How will it adopted in popular NOSQL solutions like Redis? This looks like it is for Couchbase

http://www.infoworld.com/article/2977045/nosql/n1ql-brings-sql-to-nosql-databases.html

Join my FREE newsletter to see the benefits of open source Redis 

 

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!

PostGres SQL GUI client choices

PostGres SQL GUI client choices

Here are some front end GUI choices. I use Razor which is ok but looking for something a little more slick like MYSQL Workbench

https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

Join my FREE newsletter to learn more on what tool I end up using

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!