Support PHP 5.4+ (upgrade to PDO)

[soren121]

From [email protected] on August 12, 2012 03:51:27

I'm running Debian Wheezy with PHP 5.5.4, with the sqlite3 (PDO) extension enabled.

When trying to install lightblog it says that sqlite is disabled.
As I look in install.php, I see this piece of code:

<tr>
  <td>SQLite</td>
    <?php if(extension_loaded('sqlite')): ?>
      <td><?php echo sqlite_libversion(); ?></td>

My phpinfo() tells me I have 'sqlite3' installed. Sadly, the function sqlite_libversion() seems to be depricated as of PHP 5.4.0: http://php.net/manual/en/function.sqlite-libversion.php I hope it helps :)

Original issue: http://code.google.com/p/lightblog/issues/detail?id=53

[soren121]

From [email protected] on August 12, 2012 00:52:46

Oops, I meant I'm running PHP 5.4.4, sorry.

[soren121]

From doodle62 on August 12, 2012 08:11:35

For now, you'll need the SQLite2 extension ("sqlite") enabled. Install the "php5-sqlite" package from the Wheezy repositories and it should work.

We have a new database abstraction layer in the works that will let people use SQLite2 ("sqlite"), SQLite3 ("sqlite3"), and PDO (with any driver, including sqlite3, mssql, etc.) This feature will be in LightBlog 0.9.5, which is two releases away.

[soren121]

From [email protected] on August 13, 2012 13:01:20

Hello, thanks for your report!

However, we are aware of this issue. As seen in our Roadmap (in the Wiki), PDO will not be supported until v0.9.5. We're currently working on 0.9.4, so that work will begin soon.

I already have the abstraction layers for PDO (SQLite 3, SQLite 2 will also be supported via PDO) and SQLite 2 (the sqlite_* functions) working, though they won't be implemented until after we ship 0.9.4.

While 0.9.4 has taken us longer than we would have liked, we are getting very close to getting it done.

But the good news is that LightBlog 0.9.5 isn't too much different than 0.9.4. There are only a handful of new features in 0.9.5, SQLite v3 support being the biggest. So it will come fairly quickly after 0.9.4.

Status: Accepted
Owner: [email protected]
Cc: [email protected] doodle62
Labels: -Milestone-0.9.3 Milestone-0.9.5

[soren121]

From [email protected] on August 13, 2012 13:05:44

(No comment was entered for this change.)

Labels: Component-DB

[soren121]

From [email protected] on August 14, 2012 22:32:11

Hi guys :)

Thanks for the heads-up; I'm looking forward to the update :)

[soren121]

From [email protected] on August 15, 2012 08:26:17

You're very welcome! It's people like you, who get involved, that keep us going!

Thanks, and we hope to get this finished soon.

[soren121]

From [email protected] on January 03, 2013 20:56:03

Any news about release 0.9.4 or even better 0.9.5?
I have discovered your code just now, but I would like to go with sqlite3...

Thumbs up, keep up the good work!

[soren121]

From doodle62 on January 04, 2013 13:51:42

We're still here, the project definitely isn't dead. Lightblog is very much a hobby project that both Ian and I work on when we want to. Life gets in the way far too often.

That said, I still want to get 0.9.4 out the door soon-ish. 0.9.4 really is a massive release, we're rewriting the majority of the codebase and if I had to guess, we're around 60% finished with it. I've got a few other projects I need to attend to first, but I will get back to Lightblog ASAP.

Thanks for the words of encouragement as well :)

[soren121]

From [email protected] on September 01, 2014 02:06:00

Hello can you send me your 0.9.4 because i need this because my new server don't have sqlite2 :(

[soren121]

From doodle62 on September 01, 2014 11:29:48

Oh hey! A user! Thanks for your interest in LightBlog, but uh...I haven't worked on it in two years or so. 0.9.4 is still only partially-finished. I'm not sure that the database changes were implemented. I think the repository is up-to-date if you want to try 0.9.4 in its current state, but again, I don't think it supports SQLite 3 at the moment.

Maybe I'll start working on it again. It seems like a shame to leave it unfinished.