stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


Released Metabase greatly improved







Released Metabase greatly improved

Released Metabase greatly improved 01/16/2003 03:04 AM

Metabase is a popular PHP database abstraction package that lets developers write portable database applications. This means that Metabase makes it possible to write database applications that do not need to be changed to work with different databases. Currently, Metastorage generates the code of persistence layer APIs that is based on Metabase. The latest improvements in Metabase make it possible for Metastorage to generate more compact persistence APIs.




This is a GrokNews Entry: (what is grok?)





Similar Items

Released Metabase greatly improved

Grok Headline matches for Released Metabase greatly improved

New InstallShield X has greatly improved
Windows Mobile device support


New InstallShield X has greatly improved
Windows Mobile device support
05/10/2004 02:48 PM

SimpletextCompiler Beta Released With
Improved HTML Formatting


SimpletextCompiler Beta Released With
Improved HTML Formatting
09/12/2002 04:12 PM
Mac Observer Sep 12 2002 2:50PM ET

Metabase 2004.09.02


Metabase 2004.09.02 09/02/2004 11:24 PM
A DBMS-independent package to access and manage databases with PHP.

Backing up the IIS Metabase


Backing up the IIS Metabase 06/30/2004 12:59 AM

Metabase 2005.01.05


Metabase 2005.01.05 01/06/2005 04:50 AM
A DBMS-independent package to access and manage databases with PHP.

HttpHandlers and the IIS Metabase


HttpHandlers and the IIS Metabase 03/13/2003 10:14 AM

Our team has recently consolidated a bunch of intranet sites housed on various team members' machines into subwebs on a larger server.  I had been hosting one of the sites from my office, and needed a way to redirect all hyperlinks to that particular subweb to a new subweb without affecting the rest of the sites on the machine.  ASP.NET provides a rather simple way of doing this:

using System.Web;

namespace Forward {
  public class Forwarder : IHttpHandler
  {

  public Forwarder(){}

  public void ProcessRequest(HttpContext context)
  {

  string subWeb = "http://mymachine/subweb";
  string oldWeb = "http://newmachine/newsubweb";

  HttpRequest request = context.Request;
  HttpResponse response = context.Response;
 
  string newUrl = request.Url.AbsoluteUri.Replace(subWeb,newWeb);
  response.Redirect(newUrl);
  }

  public bool IsReusable
  {
  get { return false; }
  }
  }
  }

compiled as forward.dll and placed in the subweb's bin/ directory, with the following added to the Web.config:

<httpHandlers>
<add verb="*" path="*" type="Forward.Forwarder, Forward" />
</httpHandlers>

Funny enough, this only worked for paths like http://mymachine/subweb/foo.as px, since paths like http://mymachine/subweb/foo.htm were routed directly to the filesystem by IIS and bypassed ASP.NET.  I remembered having this problem before, when .NET was still in development, and the trick was to associate the "*" file extension with ASP.NET in the script map.  Too bad IIS no longer stores the script map in the registry where it's easy to mess with.

A bit of searching and I found:

http://suppor t.microsoft.com/default.aspx?scid=KB;en-us;q232068#3

I just had to use MetaEdit to find LM/W3SVC/1/ROOT/ScriptMaps and add:

*,C:\WINDOWS\Microsoft.NET\Framework\v1.2.x86dbg\aspnet_isa pi.dll,1

and everything is working great now.

 

 


Metabase Errors


Metabase Errors 06/25/2004 02:28 AM

Backing Up the IIS Metabase Using VB
Script


Backing Up the IIS Metabase Using VB
Script
09/04/2004 06:47 AM

Internet greatly changes world


Internet greatly changes world 12/02/2003 01:47 AM
Washington Times Dec 2 2003 0:36AM ET

Death By Blog Greatly Exaggerated


Death By Blog Greatly Exaggerated 04/09/2004 04:02 PM
Shel Israel considers if blogs are the death of 'Zines. Like David Weinberger, he offered one when it was cutting edge media. Now he asks will blogging kill Confrenza, his paid subscription conference coverage 'Zine. ...Two weeks ago, while attending...

U.S. Greatly Boosts Tsunami Aid
(washingtonpost.com)


U.S. Greatly Boosts Tsunami Aid
(washingtonpost.com)
12/31/2004 10:45 PM
washingtonpost.com - JAKARTA, Indonesia, Dec. 31 -- President Bush on Friday increased the U.S. financial contribution for victims of the Indian Ocean tsunami to $350 million, 10 times the previous pledge toward the emergency effort to funnel food, water and medicine to about 5 million people in South Asia and parts of Africa.

Death of the desktop PC has been greatly
exaggerated


Death of the desktop PC has been greatly
exaggerated
06/11/2004 04:10 PM
SABC Jun 11 2004 7:58PM GMT

Rumors of my death are greatly
exaggerated.


Rumors of my death are greatly
exaggerated.
02/01/2005 09:53 PM

Okay, first off: I've got a massive MacWorld / Borders / Trip to SF and back report to write up. It's coming, and I hope it will be worth the wait. Until I can get it done, there are some wonderful links in the comments for my previous entry, from other bloggers who came to MacWorld, Borders, or both.

My short version? It was awesome. It was everything I'd hoped it would be, and more than I could have ever expected. The drive up was great, and the drive home (without Anne, because she went over to Tahoe to spend the weekend with her friend) was lonely, but enjoyable because I listened to Jay Mohr's book Gasping for Airtime most of the way. It's a interesting story . . . but you have to hear him read it. It's the difference between listening to Dark Side of the Moon and reading the sheet music.

Okay. Enough about the trip report that's coming. Here's the thing that made me fire up this nifty browser called "Epiphany," and write these words: I totally, completely, utterly b0rked my Debian machine before I left for MacWorld. I don't know what I did, exactly, but somehow it completely lost my mouse. modprobe psmouse and modprobe mousedev did nothing, and I couldn't find anything in a single online forum that would help me make my goddamn mouse work again. I tried dpkg-reconfigure gpm. I tried mouseconfig I tried cursing in lots of different languages, and making Faustian bargains with gods I'm pretty sure I just made up . . . I even taught myself how to recompile a linux kernel (the debian way and the other way) . . . but no dice.

Finally, I gave up, and decided to just start over with a clean partition and a new install. So I did mv /home/wil /mnt/hda1/backedup/, did a diff to make sure I didn't miss anything, and burned myself a copy of the latest Debian (Sarge) Network installer.

Oh. My. God. Becky. It was so easy.

Okay. Seriously. Back in the old days of 1999, everyone told me how easy it was to set Red Hat up, but how much cooler Debian was if you could just get past the nightmare install . . . well, this was about as easy an install of anything I've ever done. It was literally a handful of commands, and then a bunch of waiting while it grabbed a ton of packages and set them up.

I'm now sitting here with a honest-to-goodness Debian system, running kernel 2.6.8!

Check it out:


wil@bender:~$ uname -a
Linux bender 2.6.8-1-386 #1 Thu Nov 11 12:18:43 EST 2004 i686 GNU/Linux

Okay, this is probably not as exciting to anyone else as it is to me . . . but the fact that I got this working, and took all the HAM radio and isdn stuff out of the kernel, and still got it to work . . . it's a pretty big deal to me.

I'm logged into Gnome right now,( which I usually don't use -- I'm a KDE or Enlightenment kind of guy -- but it looks beautiful) and I've got apt installing Firefox and Thunderbird in a terminal, and then I've got to restore some of the backups, but I'm very proud of myself. Until I totally screw something else up, I feel like I can put on my propeller hat and give it a mighty spin. *snort*

I've got an audition tomorrow morning, then I'm working on the audio book of Just A Geek in the afternoon. Check back around Friday for the full SF trip report, and some other cool news.

Oh, man! And if this moment needed to get any better . . . They Might Be Giants just started singing Ana Ng on the radio behind me.


Greatly increase the animation speed of
sheets


Greatly increase the animation speed of
sheets
05/12/2004 11:14 AM
I'm going to do something I don't normally do, and repeat a previous hint. However, when the original hint was posted, I think the context sort of misled some folks (myself included) about what you could do with the hint. Yo...

A replacement script to greatly speed
Clutter


A replacement script to greatly speed
Clutter
05/04/2004 12:25 PM
Unfortunately, Clutter development seems to be stopped. This little app is the greatest iTunes companion, but with a big library (mine contains 30,000 songs), selecting an album to play was very slow. Clutter make extensive ...

Hackers, Public Differ Greatly On
E-voting


Hackers, Public Differ Greatly On
E-voting
08/06/2004 03:25 PM

Losses to file sharing greatly
exaggerated


Losses to file sharing greatly
exaggerated
04/10/2005 02:12 PM
The Canadian Recording Industry Association is pushing the Canadian government to eliminate private copying rights by parading out big loss figures. Michael Geist did some digging, and found that exaggeration is the CRIA's specialty.


Death of the Internet greatly
exaggerated | CNET News.com


Death of the Internet greatly
exaggerated | CNET News.com
08/27/2004 03:40 PM
Death of the Internet greatly exaggerated .. the Internet is still functioning

news.com.com/Death+of+the+Internet+greatly+exaggerated/2 100-7349_3-5323900.html?tag=nefd.lede
track this site | 3 links


Patching can greatly reduce the chances
of Sasser doing damage


Patching can greatly reduce the chances
of Sasser doing damage
05/06/2004 10:03 AM

Rumors of Pentium 4 Extreme Edition
demise greatly exaggerated


Rumors of Pentium 4 Extreme Edition
demise greatly exaggerated
08/08/2004 08:38 PM
It is important to note that, despite reports elsewhere, this does not mean that the entire line is being canceled. The 3.4 and 3.6GHz LGA775 versions are still in development, and will be released.

The Improved Web Kit


The Improved Web Kit 06/17/2005 02:53 PM

We've already received and committed several patches from external contributors and the repository has only been live for a few hours!

As some of you have already noticed (those of you that built), the new Web Kit not only passes Acid2, but it's also substantially faster at loading Web pages and at handling JavaScript. It contains a number of additional performance improvements that went in post-Tiger.

One question people have asked is "Does this have to replace my system frameworks?" The answer is "No." You can run this custom version of Web Kit with a particular instance of Safari without replacing your system frameworks. The run-safari script we provided does this for you. If you study what it does, you'll see that you can easily try out your own WebKit apps with the new frameworks as well. We in fact encourage you to do this so that you can make sure your apps are functioning properly with the latest WebKit.


IPod Improved


IPod Improved 07/23/2004 01:27 AM
Abcnews.go.com - Thu Jul 22, 08:47 pm GMT

Improved Search


Improved Search 07/11/2004 10:27 PM

I worked on improving the search on this site today. Search has been through a number of iterations. First, I used the basic Movable Type search. But it was slow and I wanted to do some interesting things with search.

So last year, I switched to using a SQL "LIKE" query to return two-tiered results, first from the title and keywords, then from the body and extended body. This has worked really well so far.

However, one thing bothered me about it: LIKE has no concept of word boundaries. This...

WHERE entry_text LIKE '%date%'

...returns matches for "date," "update," etc. So, I changed it a while ago to this syntax:

WHERE CONCAT(' ',entry_text,' ') LIKE CONCAT('% ','date',' %')

Basically, I started looking for the search term with a space on either side. This turned out to be an astoundingly stupid way to do it. What happens when the search term ends a sentence? Or begins the entry? Newlines, periods, and question marks are not spaces. Duh.

Today, however, I found the right way to do it:

WHERE entry_text RLIKE '[[:<:]]date[[:>:]]'

Those bracket-y things are MySQL's character classes for word boundaries. So it's like my "tack a space on either side" method, but it includes anything that's not a word. Very handy.

(But why don't I just use MySQL's full-text indexing, you ask? Because this is a hosted server, so I have to live with all the default MySQL settings. And the default settings exclude any word of less than four characters from being indexed. So three-letter acronyms like PHP, PDF, JSP, etc. wouldn't be in the index, and for a site like this, that's kind of a showstopper.)

I also did a little hacking of the search phrase you submit. For instance, searching for...

windows update

...will give you different results than if you search for...

"windows update"

Essentially, I tokenize the string but group quoted passages together. So, this...

"four score and seven years ago" abraham lincoln gettysburg

...would get tokenized like this:

Array
(
    [0] => four score and seven years ago
    [1] => abraham
    [2] => lincoln
    [3] => gettysburg
)

Finally, I included some stop words to save my database some work. This...

The penguin is the mascot of Linux

...gets reduced to this...

Array
(
    [0] => penguin
    [1] => mascot
    [2] => linux
)

So, I'm hoping to shake a few bugs out of it in the next few weeks, then I'll post the class so anyone who wants to can take a look at it.

Click here to comment on this entry


Repression, new and improved!


Repression, new and improved! 12/16/2003 12:31 PM
A Net of Control "Picture, if you will, an information infrastructure that encourages censorship, surveillance and suppression of the creative impulse. Where anonymity is outlawed and every penny spent is accounted for. Where the powers that be can smother subversive (or economically competitive) ideas" Brought to you by (among others)......Microsoft !

New and Improved SETI


New and Improved SETI 01/02/2005 02:05 PM

Now, a new, improved internet


Now, a new, improved internet 12/27/2004 10:51 AM
Economictimes Dec 27 2004 1:58PM GMT

Improved Caching in ASP.NET 2.0


Improved Caching in ASP.NET 2.0 07/07/2004 01:17 AM
Stephen Walther looks at the new caching features included in ASP.NET 2.0, and how you can use them to improve the performance and scalability of your ASP.NET applications.

Sonic unveils improved ESB


Sonic unveils improved ESB 05/18/2004 06:02 AM
Personal Computer World May 18 2004 10:19AM GMT

XServe Improved: Dual 2.3 GHz G5s, 1.2
TB


XServe Improved: Dual 2.3 GHz G5s, 1.2
TB
01/04/2005 10:52 AM

Ten CSS tricks β€” corrected and
improved


Ten CSS tricks β€” corrected and
improved
09/08/2004 08:55 AM

Tantek Γ‡elik offers his critique of Evolt's recent article "Ten CSS tricks you may not know" (via W ebStandards.org).


The new and improved John Bolton


The new and improved John Bolton 04/11/2005 02:34 PM
Bush's nominee to serve as U.N. ambassador tempers his criticisms to win confirmation.

WiFi security improved


WiFi security improved 05/06/2004 11:11 PM
Sunday Times South Africa May 7 2004 3:33AM GMT

Servoy 2.1: over 50 new or improved
features


Servoy 2.1: over 50 new or improved
features
09/24/2004 03:36 AM
Servoy BV has released Servoy 2.1, an upgrade to the company's database development and deployment environment that offers over 50 new or improved features. Important additions to the software include localization tools that enable deploying one solution in multiple languages from the same server without added coding; Style Sheets, which use a syntax similar to cascading Style Sheets for a consistent look and feel across multiple solutions and servers; Type Ahead, which creates an ever-narrowing dropdown list of words or phrases as you type in a field, allowing you to make a selection when it appears; and more.

Linux interoperability improved


Linux interoperability improved 09/20/2004 09:17 PM
Computer Weekly Sep 21 2004 1:19AM GMT

Improved 3G Wireless Application CPUs


Improved 3G Wireless Application CPUs 01/08/2004 08:38 PM
3G Jan 8 2004 5:24AM ET

Moving away from chaos toward improved
control


Moving away from chaos toward improved
control
04/23/2004 11:13 PM
Sunday Times South Africa Apr 24 2004 2:20AM GMT

AdWords Announce Improved Ad Relevancy


AdWords Announce Improved Ad Relevancy 06/30/2004 07:42 PM
"When broad matching it appears as if the overall minimum CTR will no longer be relevant. Instead, if you bid on widgets and only sell red widgets, you will probably find blue widgets getting automatically disabled but your ad still showing for red widgets."

57 Crown Courts now have improved
e-communications, 53 still to fix


57 Crown Courts now have improved
e-communications, 53 still to fix
04/16/2004 02:26 AM
PublicTechnology.net Apr 16 2004 7:14AM GMT

FTPDroplet II v2.1 offers improved
interface


FTPDroplet II v2.1 offers improved
interface
04/30/2004 03:27 AM
SubRosaSoft.com today announced the release of FTPDroplet II v2.1, the latest version of the company's easy-to-use utility for helping users upload files to Web servers (FTP Servers)...
Grok Description matches for Released Metabase greatly improved
GrokA matches for Released Metabase greatly improved

AppleWorks 6.2.9 Available


AppleWorks 6.2.9 Available 01/16/2004 11:33 AM
Apple has released AppleWorks 6.2.9, an update to its productivity suite for Mac OS X as well as version 6.2.8, an update for the Classic AppleWorks. The new versions contain bug fixes and improvements, including support for mice with scroll wheels and web-based templates when used with a proxy server. The update is available from the AppleWorks webpage.

AppleWorks for Mac OS X 6.2.9


AppleWorks for Mac OS X 6.2.9 01/16/2004 01:00 PM
This update to AppleWorks 6.0 and later supports mice with scroll wheels and improves the performance and reliability.

ADOdb and PDO


ADOdb and PDO 06/14/2004 10:38 PM
PDO is a new database API that will be part of the official PHP 5.1 release. AFAIK, PDO will not be a full-fledged database abstraction library, but will provide a standard database API for PHP.

Here is a sample taken from the PDO download:

<?php
   $x = new PDO("odbc:ram", 'php', 'php',
array(PDO_ATTR_AUTOCOMMIT => 0));
   $stmt = $x->prepare("select NAME, VALUE from test where value
like ?");
   $the_name = 'bar%';
   $stmt->execute(array($the_name)) or die("failed to
execute!");
   $stmt->bindColumn('VALUE', $value);
   while ($row = $stmt->fetch()) {
   	echo "name=$row[NAME] value=$row[VALUE]n";
   	echo "value is $valuen";
   	echo "n";
   }
    echo "Let's try an updaten"
   $stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES
(:name, :value)");
    $stmt->bindParam(":name", $the_name, PDO_PARAM_STR,
32);
   $stmt->bindParam(":value", $the_value, PDO_PARAM_STR,
32);
    for ($i = 0; $i < 4; $i++) {
   	$the_name = "foo" . rand();
   	$the_value = "bar" . rand();
	if (!$stmt->execute()) {
   		break;
   	}
   }
    echo "All donen";
?>

Highlights of PDO include the unified object-oriented API, compiled statements are now first class objects (the PDOStatement class), and better support for bind variables, which will give a substantial speed boost for performance freaks.

Does this make ADOdb superflous? If you are looking for something that just works with mysql, then ADOdb might not be for you. However ADOdb still has a big role to play, because:

(1) ADOdb makes it easier to develop PHP apps that work with multiple databases, with portable handling of data types and schemas.

(2) PDO does not provide an infrastructure for enterprise database access, such as recordset caching, sql logging and tuning, and session management.

(3) If you come from a Windows background (like me), it is easy to learn ADOdb because it follows many M'soft conventions.

So the next question is, how to extend ADOdb to support PDO? I think we can retain the existing ADOdb infrastructure, treating PDO as just another ADOdb driver. At the same time, we will add PDO specific extensions to the ADOdb PDO driver.

So the classic ADOdb calling conventions will still work:

	
        include('adodb.inc.php');
	$DB = NewADOConnection('pdo');
	$DB->Connect($host, $user, $pwd, $db);
	$rs = $DB->Execute("select * from table where name=?",array('Jill'));
	while (!$rs->EOF) {
		var_dump($rs->fields);
		$rs->MoveNext();
	}
And we will add a new ADOdb statement class to support PDO conventions:
        include('adodb.inc.php');
	$DB = NewADOConnection('pdo');
	$DB->Connect($pdo_connection_string);
	$stmt = $DB->PrepareStmt("select * from
table where name=?");
	$stmt->Execute(array('Jill'));
	while ($arr = $stmt->Fetch()) {
		var_dump($arr);
	}

Wez has more PDO examples. A PDO discussion at sitepoint.


ADODB 4.52


ADODB 4.52 08/17/2004 09:14 AM
A PHP database abstraction layer.

AppleWorks Update


AppleWorks Update 01/16/2004 11:03 AM

Appleworks Updated to 6.2.9


Appleworks Updated to 6.2.9 01/16/2004 01:05 PM
Apple released an update to their Appleworks application.This update to AppleWorks 6.0 and later supports mice with scroll wheels and improves the per...

Report: AppleWorks


Report: AppleWorks 06/22/2005 02:00 AM
A tip from Ray Sanders solves a big problem for another reader.

AppleWorks 6.2.9 for Mac OS X released


AppleWorks 6.2.9 for Mac OS X released 01/16/2004 11:33 AM
Apple has posted AppleWorks 6.2.9, the latest version of the company's productivity suite for Mac OS X...

adodb-xmlschema 0.0.2.4


adodb-xmlschema 0.0.2.4 11/17/2003 08:54 PM
An XML database creation extension for ADODB.

adodb-xmlschema


adodb-xmlschema 02/12/2004 10:14 PM
adodb-xmlschema (axmls) Release 1.0!

ADOdb 2.10 Released


ADOdb 2.10 Released 06/05/2002 07:50 AM
ADOdb 2.10 has just been released. This is a database abstraction library for PHP that supports many databases, including Oracle, MySQL, PostgreSQL, Informix, Sybase, Microsoft SQL Server, Access, FoxPro, DB2, ODBC etc.

It now provides an easy-to-use pager class. The following code

include_once('../adodb.inc.php');
include_once('../adodb-pager.inc.php');
session_start();

$db = &NewADOConnection('mysql');
$db->Connect('localhost','root','','xphplens');
$sql = "select * from adoxyz ";

$pager = new ADODB_Pager($db,$sql);
$pager->Render($rows_per_page=5);
will produce:
|<   <<   >>   >|  
IDFirst NameLast NameDate Created
36  Alan  Turing  Sat 06, Oct 2001 
37  Serena  Williams  Sat 06, Oct 2001 
38  Yat Sun  Sun  Sat 06, Oct 2001 
39  Wai Hun  See  Sat 06, Oct 2001 
40  Steven  Oey  Sat 06, Oct 2001 
"tri" This is 100% customizable with source code provided. Enjoy! "zeldman.57"

ADODB 0.70 Released


ADODB 0.70 Released 06/11/2004 11:17 AM
ADODB is a database wrapper library for PHP4 modelled on Microsoft's ADO. You are all urged to upgrade because of a bug in MoveNext(), which did not handle EOF properly.

--Calls by reference have been removed (call_time_pass_reference=Off) to ensure compatibility with future versions of PHP, except in Oracle 7 driver due to a bug in php_oracle.dll.

--PostgreSQL database driver contributed by Alberto Cerezal (acerezalp@dbnet.es).

--Oci8 driver for Oracle 8 contributed by George Fourlanos (fou@infomap.gr).

--Added mysqlt database driver to support MySQL 3.23 which has transaction support.

--Oracle default date format (DD-MON-YY) did not match ADODB default date format (which is YYYY-MM-DD). Use ALTER SESSION to force the default date.

--Error message checking is now included in test suite.

-- MoveNext() did not check EOF properly -- fixed.


ADOdb for Python


ADOdb for Python 01/26/2004 10:15 AM
In my work with Python, I found that there's no good database abstraction library, so I wrote my own. Looks familiar, doesn't it?

PHP Python
include "adodb.inc.php";
$conn = NewADOConnection('mysql');
$conn->Connect('server','user','pwd','db');
$rs = $conn->Execute('select * from tab);

while (!$rs->EOF) { print_r($rs->fields); $rs->MoveNext(); } $rs->Close(); $conn->Close();

import adodb_mysql;
conn = adodb_mysql.adodb_mysql()
conn.Connect('server','user','pwd','db')
cursor = conn.Execute('select * from tab)

while not cursor.EOF: print cursor.fields cursor.MoveNext()

cursor.Close() conn.Close()

It also supports the iterator protocol:

  cursor = conn.Execute('select * from table')
  for row in cursor:
       print row

Python does have the DB API, but it's similar to ODBC in that it provides a very minimal layer, without abstracting SELECT ... LIMIT, LOBs, string quoting, etc. Download zip.

I will try to post a comparison between developing in Python and PHP when I have more time.


ADOdb 2.20 released


ADOdb 2.20 released 07/09/2002 09:09 AM
ADOdb is a PHP library for writing portable database code. It supports many databases, including oracle, mysql, mssql, postgresql, access, informix, sybase, db2, interbase, firebird, frontbase, foxpro, etc.
  • Busy working on making the code more consistent and modular. Added new caching functions: CacheGetOne($secs2cache,$sql), CacheGetRow($secs2cache,$sql), CacheGetAll($secs2cache,$sql).
  • Added a new function useful for scheduling appointments portably. $conn->OffsetDate($dayFraction,$date=false) to generate sql that calcs date offsets.
  • Improved portability when handling joins. Added connection properties: leftOuter, rightOuter that hold left and right outer join operators, and ansiOuter to indicate whether ansi outer joins supported.
  • New driver mssqlpo, the portable mssql driver, which converts the string concat operator from || to +. This allows you to write portable sql using || that is automatically converted to + when you switch databases to mssql.
  • Fixes PageExecute() bug when sql has GROUP BY, and msaccess SelectLimit() bug.

"zeldman.57"

Notes and Tips: AppleWorks Bug


Notes and Tips: AppleWorks Bug 05/20/2004 10:03 AM
A bug in AppleWorks Find/Change can crash the application at close time.

Rumor Today: AppleWorks X


Rumor Today: AppleWorks X 08/05/2004 06:05 PM
The source of the rumor? A listing for an upcoming book entitled "Ap pleWorks X for Mac OS X: A Visual Quickstart Guide."
I hope what this means is that Apple, in addition to Keynote, has now a word processing and a spreadsheet application. And AppleWorks X is a suite consisting of all these applications, plus, perhaps with a version of FileMaker Pro.
And, hopefully, like the current AppleWorks/ClarisWorks, the entire suite is also available for Windows.
One can dream, can't I?

Enhancement Pack for AppleWorks 1.8


Enhancement Pack for AppleWorks 1.8 09/23/2004 11:09 AM
Enhancement Pack for AppleWorks adds many new features to AppleWorks, accessible via new menu items, including new formula functions (eg Linear Regression, Frequency, Median); inter-database Lookup, Table of Contents, Text Along Arc, database batch field Replace, Compare word processing or database documents, Extract for XPress, and much more.

Other News: AppleWorks Replacement?


Other News: AppleWorks Replacement? 01/03/2005 12:45 PM
Apple reportedly has new software suites lined up for a January 10 announcement.

Appleworks Database Templates 1.0


Appleworks Database Templates 1.0 04/09/2004 04:07 PM
3 Appleworks 6.x database files to track hardware, software and internet passwords.

Apple: AppleWorks Updates


Apple: AppleWorks Updates 01/16/2004 10:58 AM
Scroll wheel support and a variety of other improvements are promised in this AppleWorks update for Mac OS X, with another version for Mac OS 8/9.

A Sign Of What AppleWorks Is Worth


A Sign Of What AppleWorks Is Worth 12/04/2003 07:10 PM
$5, that is about what the application is worth to me these days. By Rob McNair-Huff (Mac Net Journal via MyAppleMenu)

iWorks to replace AppleWorks


iWorks to replace AppleWorks 03/19/2003 10:24 PM
AppleWorks will be ditched in favor of a new office suite tentatively called iWorks, reports Think Secret. The purported package will contain a new word processor, Keynote and both spreadsheet and database applications. "If you're waiting for AppleWorks 7, look instead for iWorks, coming from Apple later this year. Sources said that iWorks will consist of a word processing application tentatively called "Document," Apple's Keynote presentation software, a...

Pseudo PostreSQL ADODB


Pseudo PostreSQL ADODB 11/08/2002 07:17 PM
Pseudo PostgreSQL ADODB is a PHP class designed as a drop-in replacement for ADOdb for PHP applications that do not need the full power of ADOdb, want to remain light and fast but want to remain compatible with ADOdb. The API of PostgreSQL ADODB Emulation was designed to be compatible with ADOdb. I was able to remove ADOdb from my application framework and use this class instead.

PHP App Development With ADODB (part 2)


PHP App Development With ADODB (part 2) 08/05/2002 10:44 PM
In the first part of this article, I introduced you to the ADODB database abstraction library, and showed you a little of how it works. I demonstrated how using it in your PHP application development could substantially reduce the time spent on code rewrites if your RDBMS decided to change shape, and also gave you a crash course in the basic functions built into the library.

Fortunately, that isn't all she wrote. ADODB comes with a whole bunch of bells and whistles, which allow you to do some fairly nifty new things in your PHP scripts. Over the next few pages, I'll be showing you some of them - so flip the page, and let's get started! -- icarus

PS: : ADOdb 2.30 released on August 1st. Features generation of SQL for pivot-tables/cross-tabulations. Thanks to Daniel Lucazeau for the original idea. Also a mssql "select distinct" bug fix when the SelectLimit() function is used.

"zeldman.pinme"

Pear Versus ADOdb


Pear Versus ADOdb 11/25/2002 09:58 AM
Comparing Pear and ADOdb is one of those PHP things that we're all curious about. I haven't used it but I'd also look at Metabase (sorry for no link) since someone I respect technically really likes it. [ Go ]

Comparing PEAR DB to ADOdb


Comparing PEAR DB to ADOdb 11/17/2002 10:47 PM

PEAR DB is the default database abstraction library for PEAR. ADOdb is a high end database abstraction library modelled on Microsoft's ADO that is also very popular.

1. Feature Comparison
Where we try to put you to sleep by showing you the similarities between PEAR DB and ADOdb 2. Features Missing from PEAR DB
Now we try to wake you up with some teasers 3. Criticisms of ADOdb
Read what other people are moaning and complaining about

"zeldman.57"

Apple offers AppleWorks 6.2.9 update


Apple offers AppleWorks 6.2.9 update 01/16/2004 10:58 AM
Apple has released an update to AppleWorks, its integrated productivity software suite for consumers. The new version updates AppleWorks 6.0 or later to 6.2.9 if you're using Mac OS X, or 6.2.8 if you're still using Mac OS 8.1 - 9.x.

Notes and Tips: AppleWorks and
Newsletters


Notes and Tips: AppleWorks and
Newsletters
06/24/2004 11:24 AM
We've got some tips about working around problems in AppleWorks, plus other approaches to doing simple newsletters on the Mac.

AppleWorks File Repair Utility 1.0


AppleWorks File Repair Utility 1.0 02/10/2004 02:54 AM
Designed to fix AppleWorks documents that have become damaged.

Clean Up AppleWorks temporary files


Clean Up AppleWorks temporary files 01/28/2004 11:20 AM
Some background: AppleWorks 6.2.9 Latest version (I hoped updating to the latest would fix the problem, but it didn't). OS X 10.2.8I use "insert equation" on a regular basis with the Word Processing document type I often use...

Released Metabase greatly improved

The following phrases have been identified by the grok system as matching this entry: adodb appleworks

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

Yahoo Plans Big
Expansion of
Broadband

Yahoo Reports Q4
Profit

Australian Open:
Kournikova begins
seventh year without
a title

Rock, Angel
Alexa Adds ODP to
Homepage

Apple's Safari hunts
Explorer users

Yahoo! celebrates
turnaround

Yahoo posts earnings
of 8 cents to top
expectations

Yahoo! Posts
Earnings of $46
Million

Yahoo tops
expectations with
earnings of 8 cents
a share

PHP Class 'ctlTpl'
released

PHP Class 'Text on
Image' released

Yahoo tops
expectations and
posts earnings of 8
cents a share

Google PageRank -
Democracy or
Corporate Muscle?

Securing Web
Services

Creative Comments:
On the Uses and
Abuses of Markup

Transforming XML
Schemas

Red Hat Linux
Advisory: MySQL

What Advertisers
Want

Offshore Outsourcing
Freeze, E-dirtbag!
Dangerous Dealings
Yahoo touts
turnaround

Yahoo! Posts
Earnings, Tops
Expectations

Yahoo post earnings
of 8 cents to top
expectations

Yahoo! posts
earnings of 8 cents,
topping expectations

CNET News:
Mainframes Get
Open-Source Database

Web site blockage
frustrates
'bloggers'

Europe search
partners fight US
threat

W3C Embraces
Scalable Vector
Graphics Specs

Intel Offers Testing
Tools for Linux

Microsoft to Open
Windows Code to
Foreign Governments

MandrakeSoft Files
for Bankruptcy

Mainframes get open
source database

Efficiently Updating
Web Sites on
Clusters

Jobs for PHP Folk
Suggestions on a PHP
Problem Anyone?

Infoworld: Reviewing
Open Source CMS

Google response to
search - fixing
lawsuit attacked

Adaptive Website
Framework (AWF)

China blocking
bloggers

TM4J 0.8.0 released
To write: perchance
to try again: ay,
there's the rub or
Do I Write Another
Book?

Ne1 know of a good
place to le . . .

To go Dynamic or Not
to go Dynamic

Kartoo To Release
Site Search

eWeek: Open Source
Provides Viable CMS
Options

Movers and shakers
abuzz at Wired
awards

Kicking the Tires
Again At Teoma

UK ’ s First ‘ At
Work ’ Internet
Panel Research from
...

what is grok?