Lese selbst:
http://www.npd.de/npd_info/deutschland/2005/d0405-39.html

Maybe I need to give clarification to my situation.  I do not have a
choice regarding the web server:

My customer for the database app runs their own servers...which are
run by their own IT people.  The IT people have the servers locked
down to the point where it's a bureaucratic nightmare to get
anything 'fancy' like a database.  It's a miracle that they allow me
to run server-side scripts!  It's a VERY simple database app, only
requires 5 tables and minimal access.  I figured there would be
something out there for flat-file SQL...but I'm used to Metabase and
was hoping there would be a flat-file system that I could use so
that I could keep using the Metabase API that I'm already familiar
with.



--- In metabase-dev@yahoogroups.com, Colleen Dick <platypus@p...>
wrote:
>
> You shouldn't need shell if you have access to web based
> management such as phpmysqladmin.  Most of my web hosting
> clients who run databases neither have nor want shell.
>
> Perhaps the mysql lives on another machine. you need to
> talk to your hoster.
>
> If your host does not give you mysql (LAME LAME LAME),
> get another host. (such as me. hehe)
>
> Another alternative is for you to run the MySQL server
> on your own machine, but you'd need to have 24/7 on and
> a pretty fast pipe.  A third alternative is to find freehosting
with
> mysql that allows remote connections.  then you could have your
> website on the... uhhhh... challenged host and your mysql database
on
> another.  But honestly I wouldn't even consider a webhost that
> doesn't have some RDBMS.  That's like a restaurant that doesn't
serve food.
>
> >
> >
> > Here's my situation:
> >
> > 1.  The webserver does not have mysql
> > 2.  I do not have shell access to the web server
> >
> > Does metabase provide a 'flat-file' style for database access?
I see
> > that there's SQLite support, but I think SQLite requires
shell/telnet
> > access to the server?
> >
> > Any advice?
> >

You shouldn't need shell if you have access to web based
management such as phpmysqladmin.  Most of my web hosting
clients who run databases neither have nor want shell.

Perhaps the mysql lives on another machine. you need to
talk to your hoster.

If your host does not give you mysql (LAME LAME LAME),
get another host. (such as me. hehe)

Another alternative is for you to run the MySQL server
on your own machine, but you'd need to have 24/7 on and
a pretty fast pipe.  A third alternative is to find freehosting with
mysql that allows remote connections.  then you could have your
website on the... uhhhh... challenged host and your mysql database on
another.  But honestly I wouldn't even consider a webhost that
doesn't have some RDBMS.  That's like a restaurant that doesn't serve food.

>
>
> Here's my situation:
>
> 1.  The webserver does not have mysql
> 2.  I do not have shell access to the web server
>
> Does metabase provide a 'flat-file' style for database access?  I see
> that there's SQLite support, but I think SQLite requires shell/telnet
> access to the server?
>
> Any advice?
>

Here's my situation:

1.  The webserver does not have mysql
2.  I do not have shell access to the web server

Does metabase provide a 'flat-file' style for database access?  I see
that there's SQLite support, but I think SQLite requires shell/telnet
access to the server?

Any advice?

Hello,

on 02/17/2005 03:42 AM idiroddi said the following:
> Before I tried Metabase for the first time (last week) i used:
>
> //create select list options (id,lname,fname)
> $options_agents=array(""=>"Select an Agent");
> while($row=mysql_fetch_row($result_agents))
> $options_agents[$row[0]]=$row[1].', '.$row[2];
>
>
> As I'm playing with Metabase, I tried with no success:
>
> //create select list options (id,lname,fname)
> $options_agents=array(""=>"Select an Agent");
> while($row=MetabaseFetchResult($database,$result_agents,0,"fname"))
> $options_agents[$row[0]]=$row[1].', '.$row[2];
>
> What is the portable mysql alternative?

for($line=0; !MetabaseEndOfResult($database, $result) &&
MetabaseFetchResultArray($database, $result, $row, $line); $line++)
	 $options_agents[$row[0]]=$row[1].', '.$row[2];



> Also, is there an alternative for:
> while($row=mysql_fetch_array($result)){
> $name = $row["name"];
> }

Sorry no. There is no portable way for fetching column values by name
because each database may change the case or truncate the returned
column names in an unpredictable way.

You can always use defines like this:

define("NAME", 0);

$name=$row[NAME];

Just take care that defines are global.


> BTW, as with your other classes, Great Great work!

Thank you. ;-)


--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

Before I tried Metabase for the first time (last week) i used:

//create select list options (id,lname,fname)
$options_agents=array(""=>"Select an Agent");
while($row=mysql_fetch_row($result_agents))
$options_agents[$row[0]]=$row[1].', '.$row[2];


As I'm playing with Metabase, I tried with no success:

//create select list options (id,lname,fname)
$options_agents=array(""=>"Select an Agent");
while($row=MetabaseFetchResult($database,$result_agents,0,"fname"))
$options_agents[$row[0]]=$row[1].', '.$row[2];

What is the portable mysql alternative?

Also, is there an alternative for:
while($row=mysql_fetch_array($result)){
$name = $row["name"];
}

BTW, as with your other classes, Great Great work!

Thanks again
James

Hello,

On 11/20/2004 06:13 PM, Jorge Paván wrote:
> Hello!. I want to begin to test the cms component and, after I compile
> it, and want to run "metal\metastorage\install\setup\install.php" and I
> obtain the error: "Error: Could not install database: the database was
> only partially created: Valor por defecto invalido para 'sequence' ".
> I can see the error is in metabase_manager.php, line 345
> Could you help me please?

That sounds like you are using MySQL 4.1 that has a backwards
compatibility problem of not allowing the setting of default values of
auto-increment fields.

That problem was solved almost 2 months ago, but since I have not made a
public release of neither Metastorage or Metabase, the fix is only
available in the CVS version. You may download CVS snapshots from here
and hopefully the problem will be solved:

http://www.meta-language.net/download.html#snapshots


--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

Hello,

On 09/07/2004 11:59 AM, dcpck2004 wrote:
> I've read the other comments about MSSQL and dates/times/timestamps
> not being translated to the ISO format.  I need to get this
> functionalilty working.  Is a solution in the works or already done?
> Surely it can be done either with the "convert" SQL functions or
> within PHP using regular expression manipulation?  What is the best
> way to procede with getting this sorted out?

The Metabase solves that by creating fixed size text fields. Although
text fields may not be suitable for all dates operations they are
sufficient for most (really) portable that you may want to perform
including comparisions and sorting. You may want to double check that by
configuring and running the driver conformance test suite script
driver_test_configuration.php .

This remained that way because the original driver was written to work
with MS SQL server 6, which unlike other databases did not provide a way
to let database clients tell the server to return dates formatted in the
ISO format. I don't know about newer versions.

This solution was preferred to having to guess the current server date
and time format parse it to retrieve dates in ISO format as every other
driver. If newer versions provide new means to assure return correctly
formatted dates without these tricks, it would not be hard to add an
option to the MS SQL driver to use real date and time fields instead of
text fields.

--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

dcpck2004 wrote:

> Hello,
>
> I've recently started playing with Metabase as a solution for my PHP
> database abstraction needs.  I'm trying to write a project that needs
> to be portable across many different databases, and I'm hoping
> Metabase will help me do that, however...
>
> I've read the other comments about MSSQL and dates/times/timestamps
> not being translated to the ISO format.  I need to get this
> functionalilty working.  Is a solution in the works or already done?
> Surely it can be done either with the "convert" SQL functions or
> within PHP using regular expression manipulation?  What is the best
> way to procede with getting this sorted out?

this may help:

Ini setting for output formatting:
     ini_set('mssql.datetimeconvert', 'Off');

Query on startup to tell the server how input will have date parts
ordered:
     SET DATEFORMAT ymd

regards,
Lukas Smith
smith@...
_______________________________
    BackendMedia
    www.backendmedia.com
    berlin@...

    Linn Zwoch Smith GbR
    Pariser Str. 44
    D-10707 Berlin

    Tel +49 30 83 22 50 00
    Fax +49 30 83 22 50 07

Hello,

I've recently started playing with Metabase as a solution for my PHP
database abstraction needs.  I'm trying to write a project that needs
to be portable across many different databases, and I'm hoping
Metabase will help me do that, however...

I've read the other comments about MSSQL and dates/times/timestamps
not being translated to the ISO format.  I need to get this
functionalilty working.  Is a solution in the works or already done?
Surely it can be done either with the "convert" SQL functions or
within PHP using regular expression manipulation?  What is the best
way to procede with getting this sorted out?

Thanks

Dave

Hello,

It has been a while since I have not made a release of Metabase. Some
people have even thought that Metabase development was halted.

However, I have been making a few changes during all this time. Since
each change was not significant, I ended up not making a a release.

Since many small changes were done and many people can benefit from
them, I intend to make a maintenance release before I add some new
features that I have planned to better support the developments of
Metastorage.

Therefore, I would appreciate that you could get the latest version of
Metabase from a read-only CVS repository that I used to distribute MetaL
based projects and then let me know if there are any issues that I may
have escaped.

You may find all the instructions to download Metabase from MetaL CVS
repository here.

http://www.meta-language.net/download.html#cvs

Obviously you only need to get metabase module unless you want to build
the documentation, despite it hasn't changed.

Just execute a cvs log command to learn about all the changes done since
the version you are using.

--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

Hello,

On 07/17/2004 02:01 PM, Stefano wrote:
> Hello,
>
> In the latest released Metabase the method CreateDatabase() inside
> manager_mysql tests for existance of mysql_create_db function. If that
> function exists goes for it, otherwise issues a "CREATE DATABASE" query.
>
> This is fine and fixes the problem of older versions
> of metabase with MySQL 4 php api. Unfortunately on a test windows XP
> installation (EasyPHP 1.7 packaging Apache 1.3.27 - PHP 4.3.3 - MySQL
> 4.0.15) despite executes correctly mysql_create_db() gives a warning
> about the function being deprecated.
>
> Therefore I suggest to modify the command adding a @ modifier to
> suppress the warning:
>
> $success=@mysql_create_db($name,$db->connection);
>
> A second possibility that could be even better would to remove the use
> of mysql_create_db and always go with a CREATE DATABASE query.

Humm... I have silenced the warning in the latest release. Now, I have
just noticed that I did not make any release after that. I think I will
do it soon when I add a few planned maintenance features. Meanwhile you
may want to get the most upto date version from MetaL CVS repository:

http://www.meta-language.net/download.html#cvs



--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

Hello,

In the latest released Metabase the method CreateDatabase() inside
manager_mysql tests for existance of mysql_create_db function. If that
function exists goes for it, otherwise issues a "CREATE DATABASE" query.

This is fine and fixes the problem of older versions
of metabase with MySQL 4 php api. Unfortunately on a test windows XP
installation (EasyPHP 1.7 packaging Apache 1.3.27 - PHP 4.3.3 - MySQL
4.0.15) despite executes correctly mysql_create_db() gives a warning
about the function being deprecated.

Therefore I suggest to modify the command adding a @ modifier to
suppress the warning:

$success=@mysql_create_db($name,$db->connection);

A second possibility that could be even better would to remove the use
of mysql_create_db and always go with a CREATE DATABASE query.

Regards,
Stefano

Hello,

On 06/07/2004 10:40 PM, jamiescottmcclelland wrote:
> Hi - I'm interested in extending the metabase class so I can add a
> wrapper around the Query function. I'd like to record all sql queries
> that are run by my application before executing them.
>
> However - since metabase is setup using a function
> (MetabaseSetupDatabaseObject) instead of a new declaration I'm not
> sure how to extend it without tinkering with the distributed code. Is
> this possible?

You can use custom driver classes for that purpose. Just take a look at
these parameters of the MetabaseSetupDatabase function:
IncludedConstant, Include, SubIncludedConstant, SubInclude, ClassName.

OTOH, if what you want to develop is something that could benefit the
developers that use any of the driver classes, you may also consider
discussing the creation a patch to be submitted when you have developed it.

--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

Hi - I'm interested in extending the metabase class so I can add a
wrapper around the Query function. I'd like to record all sql queries
that are run by my application before executing them.

However - since metabase is setup using a function
(MetabaseSetupDatabaseObject) instead of a new declaration I'm not
sure how to extend it without tinkering with the distributed code. Is
this possible?

Thanks,
Jamie

Hello,

New and improved Metastorage documentation materials were released with
the intention of helping developers to get started with this software
development productivity tool and quickly deploy their PHP applications.

Besides the Metastorage reference manual that already existed and was
improved for this release, there is now a tutorial and an how-to
document to address different levels of interest from the developers on
Metastorage documentation.

http://www.meta-language.net/news-2004-03-20-metastorage.html

http://www.meta-language.net/screenshots.html

What is Metastorage?

Metastorage is an application that is meant to automatically generate
code from an high level data model definition.

Metastorage is a tool meant to provide an efficient method of
development of medium or large size applications that store and retrieve
data from SQL based databases or other types of persistence storage
containers, like XML files, flat file databases or in LDAP servers.

What does Metastorage generate?

Metastorage generates data object access classes. Currently it generates
code in PHP. The data objects are stored in SQL based relational
databases. In the future, other languages and storage containers will be
supported.

http://www.meta-language.net/metastorage-faq.html



--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Manuel Lemos wrote:

|Hello,
|
|On 12/25/2003 07:57 AM, bruce_nicholls wrote:
|
|>>From looking at the code I can see that you are not fully supporting
|>INNODB tables for mysql 4.  ie transactions.

<snip>

|The MySQL driver supports transactions since a long time ago, regardless
|of the table type.

<snip again>

For what it's worth, I've been using Metabase w/MySQL 4 transactions
for over a year now and it works great.  In addition to what Manuel
said about setting the default table type, take a look at the
following functions:

MetabaseAutoCommitTransactions()
MetabaseCommitTransaction()
MetabaseRollbackTransaction()

- --
:: t h o m a s       d u f f e y
:: h o m e b o y z   i n t e r a c t i v e
:: AB64 0DB9 CAA7 A904 A20A C56F F1F2 9602 9F02 CC30

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQE//H+48fKWAp8CzDARAjMTAKCOgRqewZeOcF5xtvceEuLDEkxYugCeOZgx
mduGquhD0P1B4lWlFp5gj7U=
=UX/1
-----END PGP SIGNATURE-----

Hello,

On 01/07/2004 03:43 PM, Jon wrote:
> I have a varchar field in MSSQL server 2000 and for some reason, it
> won't fetchResult for the whole field (the field is over 4000
> characters).  does metabase have a limit for the size of a column when
> retrieving data? and how to I fix it?

Not Metabase but MS-SQL server has some options to override the 4096
character limit. There are a few settings in php.ini but in the manual
notes somebody pointed that these settinsg are not affecting those
limits and you need to execute a query like this "set textlimit 65536"
before retrieving large fields.

http://www.php.net/function.mssql-query



--

Regards,
Manuel Lemos

Free ready to use OOP components written in PHP
http://www.phpclasses.org/

Hello,

On 12/25/2003 07:57 AM, bruce_nicholls wrote:
>>From looking at the code I can see that you are not fully supporting
> INNODB tables for mysql 4.  ie transactions.
>
> If you don't mind I would like to have a look at the code and extend
> it with some functions to include transactions etc for mysql???
>
> Haven't look at INNODB properly yet but it also supports row locking (
> not just table locking) for transactions and casscading foreign keys.
>  Haven't had a proper look yet to see how that might be implemented in
> the mysql driver but... would like to have a bash at it???

The MySQL driver supports transactions since a long time ago, regardless
of the table type.

You can sepecify the default table type but that is meant just for table
creating during database schema installation.

--

Regards,
Manuel Lemos

Free ready to use OOP components written in PHP
http://www.phpclasses.org/

I have a varchar field in MSSQL server 2000 and for some reason, it
won't fetchResult for the whole field (the field is over 4000
characters).  does metabase have a limit for the size of a column when
retrieving data? and how to I fix it?

Thanks,

Jon

The mysql changes can be found at
http://www.phpfreaks.com/articles/188/0.php

Hi

From looking at the code I can see that you are not fully supporting
INNODB tables for mysql 4.  ie transactions.

If you don't mind I would like to have a look at the code and extend
it with some functions to include transactions etc for mysql???

Haven't look at INNODB properly yet but it also supports row locking (
not just table locking) for transactions and casscading foreign keys.
  Haven't had a proper look yet to see how that might be implemented in
the mysql driver but... would like to have a bash at it???

Bruce

Hello,

On 12/16/2003 07:02 PM, klaas_venekamp@... wrote:
> Just walked into Metabase, and took a look at the documentation.
> Seemd to be just what I am looking for.
> Just one little question
> Where should best I install the metabase files
> I am running a apache server under W2k (Will soon be Linux)and PHP 4.

Usually, libraries should be installed outside your Web document tree.
Since has to do with PHP, you may install it for instance under your PHP
include path directory.

--

Regards,
Manuel Lemos

Free ready to use OOP components written in PHP
http://www.phpclasses.org/



To Unsubscribe, send a blank message to: metabase-dev-unsubscribe@eGroups.com
Need other Metabase drivers? http://www.egroups.com/surveys/metabase-dev?id=263873
Latest beta version: http://www.egroups.com/files/metabase-dev
Vote on Metabase: http://www.zend.com/apps.php?id=122&single=1

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/metabase-dev/
   
• To unsubscribe from this group, send an email to:
  metabase-dev-unsubscribe@yahoogroups.com
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Hello,

On 12/16/2003 07:02 PM, klaas_venekamp@... wrote:
> Just walked into Metabase, and took a look at the documentation.
> Seemd to be just what I am looking for.
> Just one little question
> Where should best I install the metabase files
> I am running a apache server under W2k (Will soon be Linux)and PHP 4.

Usually, libraries should be installed outside your Web document tree.
Since has to do with PHP, you may install it for instance under your PHP
include path directory.

--

Regards,
Manuel Lemos

Free ready to use OOP components written in PHP
http://www.phpclasses.org/

Hi,

Just walked into Metabase, and took a look at the documentation.
Seemd to be just what I am looking for.
Just one little question
Where should best I install the metabase files
I am running a apache server under W2k (Will soon be Linux)and PHP 4.

Root
- Apache2
-- bin
-- conf
-- ..
-- ..
-- htdocs
-- ..
-- PHP
--- bin
--- ..
-- Mysq
--- ..
-- temp
-- users
-- ..

Txs in advance

Klaas Venekamp

Dear Lemos;

Id I do not assign the Host in database_arguments
array, my visitors can connect to my mysql server
through php-metabase as localhost

And I have create user in mysql database and assign
the Host as localhost
mysql -> user -> Host = localhost

there is no problem.


But If I assign Host="10.11.12.9" in
database_arguments;
And user in mysql database Host as "10.11.12.%'
my visitors can not connect.

But If I do not use metabase and directly write as
mysql_connect("10.11.12.9","","");
and in mysql database table user and Host Column as
"10.11.12.%'

There is no problem.

How I could solve this?

Thanks and best Regards;
Muammer Biskinler
mb@...

Hello,

On 11/26/2003 10:43 AM, deathbycarrots wrote:
>>This example should send you a e-mail message reporting the error
>
> that
>
>>occured.
>>
>
>
> Thanks for the example!  I'll likely switch to that (or something
> similar) as soon as the website is launched.  For now, I'm debugging
> to the browser.

If you are using PHP 4.3 or better, you may also want to take a look at
a PHP error handler that I wrote to include with a class that mails PHP
error logs to the system administrator or a developer for prompt
assistance. This class lets you track fatal errors that is impossible
for normal PHP scripts to catch.

The error handler function that I provide is capable of including a
backtrace of all the functions that called the function where the error
ocurred. You can use PHP trigger_error() function for your Metabase
error handler code or just adapt this error handler to have a better
notion where your errors occurred including the function names and
arguments. This should satisfy also the request of a developer that
wanted to know which query as failed.

http://www.phpclasses.org/logwatcher


> One more question....
> I'm a tad confused where the documentation suggests that I can make
> direct API calls rather than using the functions...
>
> for example:
> $db->SetDatabase("someting");
>
> Or I can use:
> MetabaseSetDatabase($database,"something");
>
> The former method, using an object, seems to have additional
> documentation missing for some reason.  Is it *really* as easy as it
> says where I only need to use MetabaseSetupDatabaseObject and then
> refer to $db (or whatever I call it) as an OOP-style programming
> interface?  I guess I could just try it out and see what happens, but
> I figured I would tap into your knowledge and get the answers from the
> source!  :)

The procedural interface is just a wrapper around the direct to object
API. They call the same functions so they have the same arguments, apart
from the $database handler argument that is converted into the $db object.

--

Regards,
Manuel Lemos

Free ready to use OOP components written in PHP
http://www.phpclasses.org/

> query. For example during my tests I've got a message:
>
> Scope = Query
> Message = Unknown column 'abbr' in 'field list'
>

One of the first things I messed with when I started using Metabase
was the debugging options.  My error handling function (which is now
working, thanks for the help, Manuel!) just spits out the error inline
with
the rest of the text and at the end of the script, I print out the
results of the

MetabaseDebugOutput($database);

function.

Interestingly enough, the debugger records each query that your
perform and puts it into the output.  That way, you can see where your
error is occuring.

Just a thought :)

Jon

> > Fatal error: Call to undefined function: errhandler() in
> > C:\public_html\include\metabase_database.php on line 431
>
>
> This means that you have not defined the function errhandler(). You
> probably defined it in a script that you forgot to include.
>

You got that right!  I wasn't paying close enough attention and had
put the errHandler() function in the wrong place!  Now it's working
well.


> This example should send you a e-mail message reporting the error
that
> occured.
>

Thanks for the example!  I'll likely switch to that (or something
similar) as soon as the website is launched.  For now, I'm debugging
to the browser.

One more question....
I'm a tad confused where the documentation suggests that I can make
direct API calls rather than using the functions...

for example:
$db->SetDatabase("someting");

Or I can use:
MetabaseSetDatabase($database,"something");

The former method, using an object, seems to have additional
documentation missing for some reason.  Is it *really* as easy as it
says where I only need to use MetabaseSetupDatabaseObject and then
refer to $db (or whatever I call it) as an OOP-style programming
interface?  I guess I could just try it out and see what happens, but
I figured I would tap into your knowledge and get the answers from the
source!  :)

I appreciate your efforts on this API...nicely done!

Jon