[wp-hackers] Re: Sqlite

David Chait davebytes at comcast.net
Wed Jun 22 19:00:13 GMT 2005

But that actually brings up a great question: does WP >have< to depend upon 
the mysql date type?  I see constant conversions back and forth between 
formats, and I'm not sure it actually buys that much (at the cost of losing 
portability).  I guess specific 'calendar' functions are easier with the 
datetime stuff (i.e., +1 month == how many seconds?  depends on the calendar 
source date! ;) ) -- but don't know how much that stuff is used, or how 
easily it could be replaced.  (Matt, any thoughts?)

I'm torn on this topic, as I have myself locked in a number of mysql-custom 
queries and such in my own plugin work -- but would love to see if there's a 
good way to support SQLite given it makes test environments easier, as well 
as potentially making some sites faster. ;)


----- Original Message ----- 
From: "Robert Deaton" <false.hopes at gmail.com>
To: <wp-hackers at lists.automattic.com>
Sent: Wednesday, June 22, 2005 1:07 PM
Subject: [wp-hackers] Re: Sqlite

People have asked in the past, but due to the insanely large amount of
code relying on mysql specific time/date functions (and the
AUTO_INCREMENT column type that is not implemented in all SQLs) that
porting everything over and trying to support multiple systems would
just be too much of a hassle.

On 6/22/05, Raja Bhatia <raja at twentyouts.com> wrote:
> What's wrong with storing the date/time as unix epoch time? I think a
> better question is to inquire whether there are any plans of including
> database abstraction in WP.
> raja
> Robert Deaton wrote:
> >Not afaik, because the whole time/date system of WordPress relies on
> >mysql specific functions.
> >
> >On 6/22/05, Kai Hendry <hendry at iki.fi> wrote:
> >
> >
> >>Is there support or planned support for sqlite?
> >>_______________________________________________
> >>wp-hackers mailing list
> >>wp-hackers at lists.automattic.com
> >>http://lists.automattic.com/mailman/listinfo/wp-hackers
> >>
> >>
> >>
> >
> >
> >
> >
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers

--Robert Deaton
wp-hackers mailing list
wp-hackers at lists.automattic.com

More information about the wp-hackers mailing list