SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It looks really cool:
    http://www.firstworks.com/sqlrelay.html
    SQL Relay is a persistent database connection system supporting ODBC, Oracle, MySQL, mSQL, PostgreSQL, Sybase, MS SQL Server, DB2, Interbase, Lago and SQLite with C, C++, Perl, Python, Zope and PHP APIs, command line clients and a GUI configuration tool. It is ideal for speeding up database-driven web-based applications, accessing databases from unsupported platforms, migrating between databases, distributing access to replicated databases and throttling database access.
    I'm trying to evaluate it now -- but what looks pretty cool are the result set buffering control (PHP buffers the entire result set in memory, regardless of you fetching it or not), result set caching -- do I hear vB template caching any one? -- suspending and resuming sessions to span things over multiple pages (this helps standardize your SQL so if you need to port something you don't have to worry about MySQL's LIMIT x, y stuff).

    The only thing that annoys me is that I can't find a precompiled .so file. As much as I enjoy downloading 3 different sets of support libraries and then compiling them, it would be nice to offer a .so file so that I don't have to waste my time making everything work. The most annoying part is that if they are of the "release early, release often" crowd that means I have to go through the process every day or so to get the latest fixes.

    Questions to think about:
    Why use this over PHP's DB libraries?
    Does their method of "connection pooling" offer any advantage to PHP's persistent DB connections?

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Looks really interesting, Matt! Indeed, those are the same questions I'd be asking. Let us know what you discover!
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •