I want to have my data flow directly from digger to RDBMS

Do you want to save data to RDBMS?

Its not that hard.

And today I’m going to show you how easily it can be done using Diggernaut’s Compile Service.

Stage One: preparation.

This is test configuration you can use as sample for education, its fully working example and doesnt break any ToS. So its safe to use it in any country.

Our out data set will have forllowing structure:

Lets prepare our database. Digger can save data to MySQL, Microsoft SQL and PostgreSQL. So we need to create database and tables for our data.

MYSQL

MS SQL

PostgreSQL

Now lets compile our digger.
compile

compilemysql

compilemssql

compilepostgre

Dowload it and run.
There you go, you can see data not in your DB.

MySQL

mysql_items

mysql_dates

MS SQL

mssql_items

mssql_dates

PostgreSQL

pslq_items

psql_dates

So now you can have your data flow directly from digger to your database without a hassle.

Leave a Reply

Your email address will not be published. Required fields are marked *