473,383 Members | 1,737 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Firebird instead of MySQL ?

Because PHP5 does not include the mysql extension any more is there
a chance that we will see more Providers offering webspace with
Firebird or Postgres Databases ?

What is your opinion ? I must say that i like it to see mysql replaced
by a real database (stored procedures etc.)
Jul 16 '05 #1
8 3635
RG

"Lothar Scholz" <ll*****@web.de> wrote in message
news:6e**************************@posting.google.c om...
Because PHP5 does not include the mysql extension any more is there
a chance that we will see more Providers offering webspace with
Firebird or Postgres Databases ?

What is your opinion ? I must say that i like it to see mysql replaced
by a real database (stored procedures etc.)

Personal opinion is I would be sorry to see it go.
I've been using it for a few years and am comfortable with it.
I think most will say the same, but then again, this is usenet :)
RG
Jul 16 '05 #2
On 1 Jul 2003 01:41:14 -0700, ll*****@web.de (Lothar Scholz) wrote:
Because PHP5 does not include the mysql extension any more
That just means they don't have a _bundled_ MySQL CLIENT library_

Last I saw of the PHP5 bits of the manual, there were significant improvements
in the MySQL extension (the imysql_* functions) and the original mysql_* set of
functions still in the mysql extension; but you have to link against a proper
MySQL client, i.e. at least have the real MySQL client libraries installed
instead of having it come with its own version of the client libraries.

PHP MySQL extension != MySQL client libraries.

Hardly a great inconvenience; probably boils down to just having to specify
--with-mysql=DIR when compiling.

(Unless there's been some other news - writing this offline at the moment so
can't check...)
is there
a chance that we will see more Providers offering webspace with
Firebird or Postgres Databases ?
Doubt it'll change that much; particularly given the slow uptake of new 4.x
versions, many providers are way behind - how long will it take to take up
PHP5?
What is your opinion ? I must say that i like it to see mysql replaced
by a real database (stored procedures etc.)


MySQL has its niche, but it's amazing how much is missing from it compared to
a 'real' database.

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Jul 16 '05 #3
>
Admittedly if I was working in a large team on a large distributed
application then mySQL would probably have to go in the bin. As per
usual it's all horses-for-courses.


so, i guess that Yahoo Finance is just a bunch of homepages so, and isn't a
"large distributed application"... ;-)

http://www.mysql.com/press/user_stor...o_finance.html

Jul 16 '05 #4
On 2 Jul 2003 06:29:42 -0700, ll*****@web.de (Lothar Scholz) wrote:
But the problem comes with the windows version that a lot of developer
use before staging to a UNIX system. If you can't bundle the fu**ed
MySQL Client libraries
But this is the same point again, isn't it? Why bundle the MySQL client
libraries anyway?

The _MySQL PHP extension_ will be bundled (I haven't seen anything saying it
won't be, yet?), and dynamically linked against the no-longer-included MySQL
client library DLLs.

So you install MySQL for Windows; giving you the MySQL client libraries, add
that to the PATH, and it all links at runtime...

Just means you have to install one more thing; and if you're running it on
Windows and want MySQL access you may well have MySQL installed anyway...
because the swedisch became greedy now, this
will be not possible anymore. So what's now. MySQL was never free -
because they were going much to far with there linkage definition in
there license (connecting via a socket and using a protocol is the
same as linking to a GPL library).


MySQL hasn't been completely free for a very long time; only for certain
circumstances.

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Jul 16 '05 #5
Andy Hassall <an**@andyh.co.uk> schrieb:
PHP MySQL extension != MySQL client libraries.


Oh fine. I got the idea.

Thanks for pointing me the right direction.

Matthias
Jul 16 '05 #6
Harry Slaughter wrote:
i don't ever understand where people get this idea that mysql doesn't
scale. only valid reason for switching to something like Oracle (at
least that i've ever seen) is to please investors. yes, mysql doesn't
offer some of the features of bloatware dbs. in theory this is a
limitation; in practice, it's normally moot.


While I love mysql dearly and use it for 80% of all my
development, there are some things which make me switch to other
dbs for some projects.

The main missing functionality is stored procedures, and more
importantly nested queries.

--
Grunff

Jul 16 '05 #7
Andy Hassall <an**@andyh.co.uk> wrote in message
is there
a chance that we will see more Providers offering webspace with
Firebird or Postgres Databases ?


Doubt it'll change that much; particularly given the slow uptake of new 4.x
versions, many providers are way behind - how long will it take to take up
PHP5?


Agreed. I find any code I write needs to check for old vars like
$HTTP_POST_VARS as well as new ones like $_POST. I'm often surprised
how many hosting companies still use pre 4.1 PHP.

However, SQLlite is being bundled into PHP 5. Isn't this a clear
indication that the PHP dev team expects SQLlite to eventually replace
MySQL as the database that beginners expect to use with PHP?

Any way, I'd be damn happy to see PostGreSQL replace MySQL as the most
ubiqitous database in the PHP world. MySQL DOES NOT scale, as Tim
Perdue pointed out a long time ago on PHPBuilder, and PostGreSQL has
grown surprisingly fast.
Jul 16 '05 #8
ng**********@rediffmail.com (R. Rajesh Jeba Anbiah) wrote in message
Agreed that SQLite will dominate in the near future. My
experience with MySQL is: MySQL is not good for big sites--I have
coded one PPC site in which MySQL started bugging "too many
connections". BTW, I couldn't accept the domination of PostGreSQL as
it's slow compared to MySQL.


But, again, on large sites PostGreSQL is faster. It handles more
simultaneous connections than MySQL. Again, Tim Perdue's articles on
PHPBuilder were informative on this matter.
Jul 16 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Fred the man | last post by:
Hi, Some of our customers have remote offices. I was wondering if it'd be safe to have a DBMS running at their central office, and have our client application running on hosts in the branches...
2
by: rozrabiak | last post by:
Hi everybody! I need create trigger in firebird and mssql. The trigger must do this: If someone try to delete record in table "mast_trans" and if column "ID" is equal 145 delete cannot be...
25
by: Unregistered | last post by:
The A:link property does not seem to work in firebird. open http://blisslive.tripod.com in IE and then try it in FIRBIRD. i not sure what to do Unregistered...
0
by: Raigo | last post by:
I have Firebird SQL 1.0.3 and Visual Web Developer 2005 Express Beta 2 (latest at the moment). Also, I have installed Firebird SQL .NET driver Version 2.0 Alpha 3 for Microsoft .NET 2.0 ...
4
by: saif | last post by:
Hi all, I'm working with WinXP and IIS 5.1 and I use Mozilla firebird browser. When I check localhost I am promted for password but that's not the problem. Real problem is I am given this error...
0
by: Ann Harrison | last post by:
Tom, Actually, I've never had a corrupted firebird database. There were two bugs in an older version of InterBase that produced income for me. The first was a failure to realize that a file had...
10
by: Jennifer Carr | last post by:
I have an Access 2003 application that is split into two .mdb files for the interfaces and data. This app is distributed on a CD to be used on computers that have no internet access. When someone...
12
by: timothy.williams | last post by:
Hi. I have a Python program that parses a file and inserts records into a database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my parser runs *really* slow. Writing out to CSV...
1
by: juancho8529 | last post by:
I ned know how set the number of rows obtained from a interbase 2.0 query, hi have tried with instructions has fetch rows, limit, top... but i didn't have found a correct result, Please if...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.