http://blog.s9y.org/ Serendipity - The official Serendipity blog en Serendipity 1.3-alpha1 - http://www.s9y.org/ Jannis Hermanns jannis@gmail.com Jannis Hermanns jannis@gmail.com Sun, 18 May 2008 04:13:42 GMT http://blog.s9y.org/templates_s9yorg/default/img/s9y_banner_small.png http://blog.s9y.org/ 100 21 http://blog.s9y.org/archives/194-Netmirror.org-Outage,-Spartacus-affected..html http://blog.s9y.org/archives/194-Netmirror.org-Outage,-Spartacus-affected..html#comments http://blog.s9y.org/wfwcomment.php?cid=194 nospam@example.com (Typ.o) Server seems to be still down on Sunday, 18. Sun, 18 May 2008 05:55:01 +0200 http://blog.s9y.org/archives/194-guid.html#c2412 http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html#comments http://blog.s9y.org/wfwcomment.php?cid=193 nospam@example.com (Garvin) Thanks a lot. Will contact jannis. Thu, 15 May 2008 20:46:05 +0200 http://blog.s9y.org/archives/193-guid.html#c2410 http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html#comments http://blog.s9y.org/wfwcomment.php?cid=193 nospam@example.com (AO) Garvin - the TLD / forum seems to be down / unavailable. AO Thu, 15 May 2008 20:18:28 +0200 http://blog.s9y.org/archives/193-guid.html#c2409 http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html#comments http://blog.s9y.org/wfwcomment.php?cid=193 nospam@example.com (Holger Mitterwald) It is more a philosophic question which part of the software should do automatic casting. Fact is, postgresql doesn't do it any more and breaks s9y. Perhaps I might help getting s9y running on pgsql - simply as I want to use both of them in future. Question is if you should build a small Framework with object-oriented methods. So you can declare most of the SQL-Statements for all databases. Those who differ are overwritten in a database-specific include. So you have to explicitly load a database-specific driver for your database. I really can't imagine a good/fast solution otherwise. On the other hand there are some lets call it "mysql-Emulation" funktions available for pgsql. As far as I know openx.org works with this. (but I doubt this might help with casts). Thu, 15 May 2008 18:41:22 +0200 http://blog.s9y.org/archives/193-guid.html#c2408 http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html#comments http://blog.s9y.org/wfwcomment.php?cid=193 nospam@example.com (Michael) This seems to be a release with lots of helpful options. As I've been to busy to notices this new release I will catch up on this now. Wed, 14 May 2008 13:06:03 +0200 http://blog.s9y.org/archives/193-guid.html#c2407 http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html#comments http://blog.s9y.org/wfwcomment.php?cid=193 nospam@example.com (Garvin) Simone, thanks for discussing this. We are actually in need of people who use pgsql and s9y and can help in finding a solution. Additionally to what is stated in http://board.s9y.org/viewtopic.php?t=12402 here's a quick summary: Serendipity uses a single SQL code that runs on all DBs we support (MySQL,SQLite,PGSql,SQRelay). There are only few exceptions to that SQL, namely where DISTINCT vs. GROUP is used, which requires special case for PostgreSQL. As for implicit casts, we use those in a central place of the code, where basically any involved DB table can contain a column that is matched against a user specified term. At that point in code, plugins can interfer and supply custom joined tables with differing column types, but all need to be generally matched against the key. So for this, onle the "LIKE" command or "=" term with single quotes (implicit string cast) really works, because at that place in code, the script might not know if it needs to match an integer or a string. To change this would mean that every plugin or code that hooks into those central functions first needs to check which column type a match key is. That would mean additional performance hits as well as changing all plugins that relate to this. This is nearly an impossible task and involves tidious patching of a lot of plugins. However, this really is a thing where implicit string typecasting makes sense, and I actually fail to see why this is removed in PGSQL, BC-breaking a lot of existing code (not only s9y). Typecasting should not simply be put up to the application; IMHO it's the job of a database to do actual casting on its own, introspecting the input and other meta information that is. It's just like lazy variable initializing in PHP: You can simply prototype faster if you are not restricted to explicit casting. Hope that clears up some things and why I see that more of a shortcoming of PGSQL design decisions. Regards, Garvin Tue, 22 Apr 2008 22:02:14 +0200 http://blog.s9y.org/archives/193-guid.html#c2406 http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html#comments http://blog.s9y.org/wfwcomment.php?cid=193 nospam@example.com (Simone) I fail to see how "there is no ultimate solution to" PostgreSQL problems: simply use explict casts where needed. Tue, 22 Apr 2008 21:35:04 +0200 http://blog.s9y.org/archives/193-guid.html#c2405 http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html http://blog.s9y.org/archives/193-Serendipity-1.3.1-released.html#comments http://blog.s9y.org/wfwcomment.php?cid=193 nospam@example.com (Judebert) This release also includes updates to the Karma plugin, allowing karma bars to be displayed on summary pages. Tue, 22 Apr 2008 15:45:56 +0200 http://blog.s9y.org/archives/193-guid.html#c2404 http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html#comments http://blog.s9y.org/wfwcomment.php?cid=192 nospam@example.com (Sascha) Fine, maybe now more people should change from Wordpress to s9y! :) Thu, 03 Apr 2008 05:00:19 +0200 http://blog.s9y.org/archives/192-guid.html#c2400 http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html#comments http://blog.s9y.org/wfwcomment.php?cid=192 nospam@example.com (macdet) Yes, great. I stumble opften :(but that great! Wed, 02 Apr 2008 10:29:16 +0200 http://blog.s9y.org/archives/192-guid.html#c2397 http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html#comments http://blog.s9y.org/wfwcomment.php?cid=192 nospam@example.com (Bernd) Yes great Work Guys ! Thanks ! Mon, 31 Mar 2008 19:19:36 +0200 http://blog.s9y.org/archives/192-guid.html#c2395 http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html#comments http://blog.s9y.org/wfwcomment.php?cid=192 nospam@example.com (it's so cool) cool~ anyhow realsease is so quick Wed, 26 Mar 2008 04:06:01 +0100 http://blog.s9y.org/archives/192-guid.html#c2394 http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html#comments http://blog.s9y.org/wfwcomment.php?cid=192 nospam@example.com (Rob A) Thx Garvin! Is there another post in the forums that explains the sparticus FTP mode and back end in greater depth? -Rob A> Mon, 24 Mar 2008 15:41:40 +0100 http://blog.s9y.org/archives/192-guid.html#c2393 http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html#comments http://blog.s9y.org/wfwcomment.php?cid=192 nospam@example.com (Robert) Thx Garvin and the s9y-Team! Especially the improved pingback support is something I will certainly love! As my S9y Version is currently pretty old with this update I will find many new features to s9y, that are actually not new ;). Thu, 20 Mar 2008 17:22:45 +0100 http://blog.s9y.org/archives/192-guid.html#c2391 http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html http://blog.s9y.org/archives/192-Serendipity-1.3-released-addresses-security.html#comments http://blog.s9y.org/wfwcomment.php?cid=192 nospam@example.com (JCG) Great job! Thanks a lot for 1.3 Final! Upgrading (from 1.2.1) was very smooth. Like always. :-) Wed, 19 Mar 2008 15:30:11 +0100 http://blog.s9y.org/archives/192-guid.html#c2390