Category Archives: SQL

SQL and UniVerse

What happened in 1986?

Posted on July 21, 2011 by davidjmurray

I have been rather busy of late, doing a bit of reading and a lot of research regarding the NF² or The Nested Relational Model. While browsing my old Universities library last year, I discovered an old text book on … Continue reading →

Posted in General, mvdbs, Publications, RANT, SQL, Technologies | Tagged , | Leave a comment

Free eBook on Database Team Development

Posted on March 24, 2011 by davidjmurray

Well, the focus of the book is on Microsoft SQL-Server, but there are some ideas there, which may be of interest to U2 people. Have a look at – http://www.red-gate.com/products/sql-development/sql-source-control/entrypage/assets/RG_Guide_to_SQL_Server_Dev.pdf

Posted in Free-bees, Publications, SQL, Techniques | Leave a comment

Update to Active Python Database Modules

Posted on September 2, 2010 by davidjmurray

While I have been on hiatus during this summer, Active State have not.

Posted in odbc, Python, SQL | Tagged , | Leave a comment

Is UniVerse non-relational?

Posted on June 18, 2010 by davidjmurray

This morning, I received an email summary of my linked-in activities. One of the network activities was Susan Joslyn comment that U2 had been added to the nosql-database.org website.

Posted in mvdbs, SQL, U2, UniVerse | Tagged , | Leave a comment

More on UniVerse to MySQL

Posted on October 9, 2007 by davidjmurray

I have now been able to do simple sql statements from within UniVerse to access data in MySQL. All good stuff. As I really want to see how I can use MySQL as a multivalued database, I have decided to … Continue reading →

Posted in Code, mvdbs, SQL, Techniques | Tagged , | Leave a comment

UniVerse odbc to MySQL

Posted on October 8, 2007 by davidjmurray

I wanted to see how easy it was to access a MySQL database from UniVerse; using UniVerse as the client. This is on Linux (CentOS 4) with UniVerse 10.2 PE.

Posted in Code, mvdbs, SQL, Techniques, UniVerse | Tagged , | Leave a comment

Further Thoughts on MySQL Proxy

Posted on September 29, 2007 by davidjmurray

I have been thinking about how easy it would be to implement the previously mentioned idea of using MySQL Proxy as a uniVerse query processor/converter to SQL. Now, the CREATE.FILE can be translated to a number of create table statements … Continue reading →

Posted in Idea!, mvdbs, SB+ Server, SQL, UniVerse | 2 Comments

MySQL Proxy – MySQLForge Wiki

Posted on September 20, 2007 by davidjmurray

The latest Linux Magazine (October 2007) has an article about MySQL Proxy – MySQLForge Wiki. This is a piece of software that sits between the MySQL client (or any sql client) and MySQL server. It traps the SQL commands and … Continue reading →

Posted in Idea!, mvdbs, SQL, UniVerse | Leave a comment

DIY B-Tree’s

Posted on September 14, 2007 by davidjmurray

While reading through the PICK entry on the wikipedia.org website, I found a link to www.semaphorecorp.com which has code and instructions on writing your own b-tree’s within PICK. It is dated from 1987…

Posted in I-Types, Idea!, mvdbs, SQL, Techniques, UniVerse | Leave a comment