Poker-AI.org

Re: Is it safe to connect to postgreSQL on VM from host?

2014-05-27T07:46:10+00:00

I have not been very active in the past weeks, but I started my bot project again and I recognized my mistake.

I was pretty much a complete noob, when it came to SQL. The bottleneck was (like it is often) the data transfer. Most stats are just a ratio of sums of things, like SUM(VPIP Flag) / SUM(Hands) but I have been transferig lanrge data sets into my ResultSet object and I was later looping through it in Java.

Now I use SUM() in my SQL statements and only transfer a single integer to Java. It brough the computation of some stats from 340ms down to 1ms, should be fast enough now.
You should do most of your computation in SQL if you have similar problems and filter the data as much as possible with WHERE statemets.

Statistics: Posted by HontoNiBaka — Tue May 27, 2014 7:46 am

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-20T11:45:14+00:00

No, I am using my own cache, where I save the ResultSets. I looked into the PT4 cache, but it doesn't have the elementary stats, this would mean, that I can not create custom columns, or will the appear in the cache, if I define them in PT4?

Statistics: Posted by HontoNiBaka — Fri Dec 20, 2013 11:45 am

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-17T17:47:01+00:00

PT4 already has a cache that they use for fast stat retrieval, are you using that? How big is your db?

Statistics: Posted by ibot — Tue Dec 17, 2013 5:47 pm

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-17T09:36:02+00:00

Well, I implemented simple caching and simple garbage collection now, it seems to work fine now, but I need to test it in real play. Let me know if anyone is interrested in a small pt4 java tutorial.

Statistics: Posted by HontoNiBaka — Tue Dec 17, 2013 9:36 am

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-16T16:04:11+00:00

I started working on my SQL queries, but its extremelly slow, one query takes 0.12 seconds and my DB isn't even big yet. Is that normal? Is there anything I can do, besides caching? Would it make sense to just load the whole Db into RAM?

Statistics: Posted by HontoNiBaka — Mon Dec 16, 2013 4:04 pm

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-15T19:54:36+00:00

Ok, I guess it's really less suspicious. thx

Statistics: Posted by HontoNiBaka — Sun Dec 15, 2013 7:54 pm

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-15T00:06:39+00:00

It is perfectly ok to have your database across the network and connect to it(so DB on host, PT4 or HEM1 on VM). This works for PT and HEM1(not HM2) and is a used function by normal users. On the other hand, an external process connecting to the VM DB might raise some flags. Alternatively, you can probably use several cloud tracker DBs on the market.

Statistics: Posted by maikon — Sun Dec 15, 2013 12:06 am

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-14T13:22:18+00:00

Why is that safer? I don't know a lot about security, what is the difference between both methods?

Statistics: Posted by HontoNiBaka — Sat Dec 14, 2013 1:22 pm

Re: Is it safe to connect to postgreSQL on VM from host?

2013-12-14T02:05:17+00:00

It's possible to know the TCP/IP connections opened from the VM, which would raise a flag. A better solution would be to have postgres running in the host and configuring PT (or whatever you're using) to connect to it using the host's IP

Statistics: Posted by corintio — Sat Dec 14, 2013 2:05 am

Is it safe to connect to postgreSQL on VM from host?

2013-12-12T09:32:28+00:00

Will it still be impossible to scan my processes etc. on the host from the VM?

Statistics: Posted by HontoNiBaka — Thu Dec 12, 2013 9:32 am