SNGs - Constructing real opponent ranges

Good stuff. I really need to do more of this for the fiddy fiddys so I'm interested in seeing what you can get out of this. I'm using PT3 (PostgreSQL).

Originally Posted by Nakamura

Some you may have heard of MySQL, that's Oracle's version of SQL, a database language. PostgreSQL is an open source version that basically does the same thing

MySQL is opensource too. I don't think it has any relationship with Oracle. Hey, I'm picking nits but if I can't do this for stuff that involves my regular day job, when can I?

Originally Posted by kevster

MySQL is opensource too. I don't think it has any relationship with Oracle. Hey, I'm picking nits but if I can't do this for stuff that involves my regular day job, when can I?

I never knew it was opensource, I always thought it was a commercial product. There is apparently an Enterprise edition which is a pay product and has better support etc., but the standard edition is free and opensource.

As for the history it appears somewhat complicated but it used to belong to Sun MicroSystems and then Oracle bought Sun MicroSystems a short while ago. From Wiki...

Corporate backing history

In October 2005, Oracle Corporation acquired Innobase OY, the Finnish company that developed the third-party InnoDB storage engine that allows MySQL to provide such functionality as transactions and foreign keys. After the acquisition, an Oracle press release mentioned that the contracts that make the company's software available to MySQL AB would be due for renewal (and presumably renegotiation) some time in 2006.[37] During the MySQL Users Conference in April 2006, MySQL issued a press release that confirmed that MySQL and Innobase OY agreed to a "multi-year" extension of their licensing agreement.[38]
In February 2006, Oracle Corporation acquired Sleepycat Software,[39] makers of the Berkeley DB, a database engine providing the basis for another MySQL storage engine. This had little effect, as Berkeley DB was not widely used, and was deprecated (due to lack of use) in MySQL 5.1.12, a pre-GA release of MySQL 5.1 released in October 2006.[40]
In January 2008, Sun Microsystems bought MySQL for US$1 billion.[41]
In April 2009, Oracle Corporation entered into an agreement to purchase Sun Microsystems,[42] then owners of MySQL copyright and trademark. Sun's board of directors unanimously approved the deal, it was also approved by Sun's shareholders, and by the U.S. government on August 20, 2009.[43] On December 14, 2009, Oracle pledged to continue to enhance MySQL[44] as it had done for the previous four years. A movement against Oracle's acquisition of MySQL, to "Save MySQL"[45] from Oracle was started by one of the MySQL founders, Monty Widenius. The petition of 50,000+ developers and users called upon the European Commission to block approval of the acquisition. At the same time, several Free Software opinion leaders (including Eben Moglen, Pamela Jones of Groklaw, Jan Wildeboer and Carlo Piana, who also acted as co-counsel in the merger regulation procedure) advocated for the unconditional approval of the merger. As part of the negotiations with the European Commission, Oracle committed that MySQL server will continue to use the dual-licensing strategy long used by MySQL AB with commercial and GPL versions available until at least 2015. The Oracle acquisition was eventually unconditionally approved by the European Commission on January 21, 2010.[46] Meanwhile, Monty Widenius has released a GPL only fork, MariaDB. MariaDB is based on the same code base as MySQL server and strives to maintain compatibility with Oracle provided versions.[47]
[edit]

Hi Nak,

cool stuff as usual.

some of that SQL syntax is unfamiliar, but i'm just wondering if you could skip the manual clean-up bit by suppressing your player_id in the WHERE clause?

Originally Posted by DoubleJ

some of that SQL syntax is unfamiliar, but i'm just wondering if you could skip the manual clean-up bit by suppressing your player_id in the WHERE clause?

I guess so, I'm not very familiar with SQL coding. I just borrowed the code and tweaked it until it worked for me. I decided it wasn't worth the hour it would take me to figure out how to exclude my player id in SQL; it's easy enough to do manually.

That said I guess this might work

Code:

WHERE tourneyhands>$2$BODY$ AND player_id != 'YourPlayerID'

I think Player_IDs are stored as integers in SQL and you would need to figure out what your ID is. There is a way but I'm too lazy to do a Google search right now...

the easy (i.e. non-dynamic) way would be to run a simple query to get your player_id

SELECT

playername,
player_id

FROM

players

WHERE

playername = '<your name here>'

this will return a list of all the player_id associated w/ you - number will depend on how many sites you play at.

make a note of 'em, then amend the WHERE clause in your function to

WHERE

tourneyhands>$2 AND
player_id NOT IN (<copy the list of ids here, separated by commas>)$BODY$

EDIT: I'm MSSQL not Oracle, so you may have to amend for dialects. Same disclaimer as for Nak's code