Sqlite and plugins

pylpa · Post by **pylpa** » Sat Apr 12, 2008 4:42 pm

Hello everyone

I 'm a neebie with Serendipity and I want to tell you that for me it's a great product

. What interest me is SQlite and smarty templates : Sqlite for using it simply on a local machine, and smarty for the power of their templates.

I have some bugs with some event_plugins like faq, may be because that there no ALTER TABLE in Sqlite ??? all works fine with a MYSQL database.

Have you any solution for that ?

Thanks a lot for your reply.

Post by **garvinhicking** » Sat Apr 12, 2008 5:16 pm

Hi!

Yeah, it's a shame that SQLite does not provide ALTER TABLe. The only solution to that is to use a tool like SQLiteAdmin and re-create the proper table.

You can also create a temporary table, create the new table with the new layout, copy all records from the temp table to the new one, delete the new temporary table and then rename the new table to the old one.

that's how the internal s9y db updates perform it, but because it's so complicated, many event plugins don't do that. Though there are only a handful of event plugins that need to ALTER TABLE. Only FAQ, Staticpage and few others.

Regards,
Garvin

pylpa · Post by **pylpa** » Sat Apr 12, 2008 5:28 pm

Thanks for your reply.

Could you tell me where i can found the database structure that i must modify.
i want to use S9Y as a cms to save ideas and notes with an easy and powerful search engine. do you think that it's a good idea or do you have another suggestion for that goal ?

Post by **garvinhicking** » Sat Apr 12, 2008 6:17 pm

Hi!

It's only inside the event .php files of the correspondig plugins, you will have to "read" the code there. If you don't succeed, tell me again next week and I'll check it out for you.

i want to use S9Y as a cms to save ideas and notes with an easy and powerful search engine. do you think that it's a good idea or do you have another suggestion for that goal ?

Hm, I'm not completely sure. For things like that I often use a wiki or simple plaintext files

But certainly it can be done with s9y if you like the interface

Regards,
Garvin

pylpa · Post by **pylpa** » Sat Apr 12, 2008 6:55 pm

Thank your for your sincerity about my project (wiki, plain text files). It' true that have look before to Dokuwiki.

But i find s9y great and i will have a look to the event file...

Regards,

Sqlite and plugins

Sqlite and plugins

Re: Sqlite and plugins