I am back from my trip to this year's LinuxTag. In the past I stayed for the entire
week but this time around I could only stay for one-and-a-half
days.
On Thursday I woke up at 3:00 AM and could not sleep
anymore. At 7:12 AM I took an ICE 3 train to Karlsruhe where I arrived at 8:59 AM. About
fifteen minutes later I signed in at the venue and, after a first
stroll through the exhibition area, said "Hello!" to my peers at
the …
A new version of FUDforum is in the works, 2.6.14. This release
is intended to introduce some new functionality as well as
address any existing bugs. Some additional work has been done to
enable future PDO support. At this time I already have a "beta"
PDO driver that works with PostgreSQL, MySQL and partially
supports SQLite. I hope to have it in CVS within a release or
two.
This version can be downloaded at:
http://fudforum.org/download.php
New Features:
Added Brazilian Portuguese translation.
Allow resizing of the textarea for message posting.
Added ability to set temporary bans.
Added admin control panel to view all banned users.
Improved performance of threaded topic view list rendering.
Improved png hack for IE, it is now done by PHP.
Better caption for template set on theme editor.
…
Ever wanted to know why everyone talks about SQLite? Well, it's simple like that: SQLite is damn small and very very fast. As a Senior Developer for Mayflower/Würzburg it was my pleasure (uhuum) to lead the Spare Parts Project for Vaillant Group. 100.000 CD's are already shipped running PHP with SQLite locally - mind the licenses one have to pay choosing MySQL for the job... Anyway, figuring out the differences between MySQL (which is the storage layer for the Spare Parts web application) and SQLite (which is used for the CD variant) was pretty hard. This is what it's all about: There are virtually many shops with different sets of tables in the background for country specific pricing data. If a country administrator wants a cd variant of the current shop, he simply starts the following process in a web form: import the MySQL tables in a SQLite file, package a minimalistic version of chairman together with the relevant databases, pass the whole …
[Read more]Just a quick response to Lukas' blog entry.
I know Lukas would love to see things work a little differently in PDO, but there are good technical reasons why things are the way they are now. Here are some reasons in random order:
- It's impossible to build a magic database abstraction layer that works for everything
- PDO is data-access abstraction (not database abstraction). The primary goal is to make things similar enough that you don't end up cursing at the API. The abstraction is also present for the benefit of extension developers, making it less of a headache to build database drivers for PHP.
- No two underlying database client APIs are the same
- Most don't separate the concept of a prepared statement handle from a result set.
- Most overload functions like RowCount() to …
n0other: Hello, I have a field publish_to, I want to select only those entries, where publish_to is not older than today, publish_to contains for example ‘2005-05-30′, I do: SELECT * FROM table WHERE (publish_to - “‘.date(’Y-m-d’) .’”) > 0; (php date function), but that doesnt work, how should I implement this, I cannot change date structure
Notice the detailed question with example. This shows people exactly what the problem is and that you have taken the time to try to solve it yourself.
firewire: so you want where it’s today and newer?
firewire: where publish_to >= curdate()
A quick response prior to testing
n0other: oh :}
Now after a quick test a final response letting everyone know that the problem was solved
n0other: works perfectly, thanks again
firewire:
It’s little times like these that make helping people on irc so much fun.
It seems to me that a lot of people have auth denial when trying to make connections to MySQL. They seem to ignore the text of the error message. ‘Access Denied’ means access denied, nothing else.
Remember three things have to match. The host as MySQL sees it, the username, and the password. When MySQL returns access denied it’s not broken. One or more of those three things does not match. I don’t really need to reiterate what’s in the manual. Chang the lock or change the key to make it fit.
Zend recently decided to not call themselves the creators of PHP anymore. This change in Zend’s marketing has been long overdue. It caused friction with some PHP core developers over the past years that spread into the PHP community.
Others also make mistakes
It is not that Zend is the only company in the Open Source market that made some marketing mistakes in the past. MySQL for example had their CTO Monty Widenius talk fancier then usual in an internally conducted interview and the answers did not sound like he really said them. It made known members of the MySQL community wonder who kidnapped Monty.
Sex sells?
To some marketing experts, the Open Source community might seem like a …
[Read more]
I just returned home after attending the International PHP
Conference 2004 and MySQL ComCon
Europe 2004 conferences.
Monday
After a convenient ride with the ICE-3
high-speed train from Siegburg to Frankfurt
am Main / Airport (about 40 minutes) and a short ride with a
shuttle bus to the hotel (about 10 minutes) I arrived at the
conference venue just in time for the first coffee break of the
day.
Following the first "Hello!"s with my fellow PHP developers …
via Zak:
The Shaken (but not stirred) Announcement
Recipe for MySQL ComCon Europe 2004:
- Take equal parts kick-ass MySQL community event and MySQL mission-critical business event.
- Add key MySQL community members and developers.
- Drop in three days in November (8th to 10th).
- Shake well.
-
Serve ice cold at http://mysqlcomconeurope.com/.
If you're interested in attending, by all means beg/bribe, borrow or steal to get there; a lot of effort has gone into organizing the event, particularly into getting the developers to be at the same place at the same time, so make the most of it!
Developing PDO and releasing an alpha has sparked a lot of interest already (probably helped along by George ;-)) and we got our first "how does it work" e-mail today. As it happens, I've already written a intro to PDO for the OTN but George informs me that they can take a while to publish.
Meanwhile, to avoid being swamped by mail as the word gets out, here are a couple of sample PDO scripts to get you started. Please keep in mind that it is alpha software (although still works pretty well) and requires PHP 5 from CVS (RC3 will work too, but that isn't released until next week).
The API is "grown-up" by default; you get so called "unbuffered" result sets as standard and the prepare/bind/execute API is preferred, although there are some short-cuts already (and some more planned). Note …
[Read more]