Antville Project

Update to new Database-Schema

I've finished the new database-schema and updated Antville in CVS. Basically the following has changed:

  • There are now three SQL-scripts for creating the Antville-database: for mySQL, for Oracle and for hsqldb (the latter is currently outdated because it creates the old db-schema). Due to some special features in mySQL (id-autoincrement and the timestamp-columntype) the Oracle-script will also create a sequence and two triggers (on the table AV_ACCESS). I also included a template for db.properties if you want to use an Oracle-database. (for details reg. the new database-schema, have a look here. There is also a db-patch that will convert an existing mySQL-database to the new schema (see below!)
  • some of the protoypes were renamed to match the names of the database-tables: weblog -> site goodie -> file goodiemgr -> filemgr member -> membership membership -> membermgr this also changes the macro-handlers, eg. the macro <% weblog.title %> is now called <% site.title %>. the default-skins have changed too according to this (same with goodie). For consistency-reasons i've also renamed some macros and functions.
  • Most of the stuff that 'til now was defined in app.properties can now be defined via a setup-page. Antville will check if it has been setup'ed and redirect you to /manage/setup if not. It's now also possible to change the language of the whole Antville-Installation, to define a "system title" that will be used instead of "Antville" (mostly in page-titles and confirmation mails).
  • It's not possible anymore that an admin of a weblog can "degrade" himself to a lower permission-level. this means that there will always be at least one membership with admin-rights.

IMPORTANT: Due to the new database-schema i do not recommend you to update antville now if you are seriously using Antville. If you already have some weblogs in your database they will throw some errors because the macro-handlers have changed. And most likely the skins that are stored in the database will do so too. We will soon come up with some scripts that will do the update of your data. For testing this version of Antville you should use a newly created database.

I hope this update works fine, but if you encounter bugs please report them here in the project log.

comment    

 
hns, June 27, 2002 at 1:13:26 PM CEST

cool

we're getting close.

link  

 
tobi, June 28, 2002 at 4:15:05 PM CEST

yes, cool

and congrats, robert.

so, how and when will we update our current antville installations...? (or will there be another update before?)

link  

 
robert, June 28, 2002 at 5:40:12 PM CEST

thanks, tobi

nice that you like it. reg. update: we need the update-scripts before (depending whether we switch to file-based skins or stick witch db-stored ones, see my comment below). unless we haven't done that nobody who wants to use existing contents/skins in an antville-db can update without getting a bunch of errors.

link  

 
tobi, June 28, 2002 at 5:57:45 PM CEST

you mean

some javascript functions that will be run from within the scheduler to change e.g. weblog macros to site macros and the like? that's right. could we do that next week?

link  


... comment
 
hns, June 28, 2002 at 4:41:41 PM CEST

I just installed it locally

And the new system settings via browser interface are very very cool!

One thing I noticed though is that almost nothing of the user interface is actually localized - only the user feedback messages. So we have still a long long way to go until we reach full internationalization, and the most important thing to localize are actually the skins.

If that's ok with you I'll merge the XML-content very soon now.

link  

 
robert, June 28, 2002 at 5:34:25 PM CEST

yes

of course it's ok if you merge the xml_content-branch in the main branch. just one minor question: what about using a ":" as separator in input-names instead of "_"?

localizing skins is the biggest part of it, the application messages were just the first step. i could think of the following:

  1. finalize the default-skinset (with all the xhtml-compatibility-stuff, if there is any left)
  2. choose a directory-structure for storing skins (also those custom-skins of weblogs; i still think that we should switch to file-based skins and drop those db-stored skins)
  3. create a default-skinset for each language (most of the skins have at least some parts in them that should reflect the chosen language).

what ya think about?

link  

 
tobi, June 28, 2002 at 5:55:12 PM CEST
  1. and 2. sounds good.

but would the creation of a default skinset for each language as described in 3. not lead to a maintenance work almost impossible to handle for us? (if i see it right, we need to update each language skin if there is a change in html code or structure!?)

how about putting all of the messages in the message files you just created for the user messages?

link  

 
robert, June 28, 2002 at 6:21:46 PM CEST

yes

that would mean a whole lot of maintenance work. on the other hand: if we move all localized parts of the default skin-set into the message file

  • some skins will contain only macros (which isn't what i would call easy to modify); skins would be harder to understand for users.
  • some macros contain prefixes and suffixes that also should be localized, but that would mean that we need to embed macros in macros, which i personally would like to avoid due to increasing complexity.

but maybe there's another possibility that i've missed (thinking about application structure is hard when you're carrying furniture from a to b ;-)

link  

 
hns, July 1, 2002 at 2:16:25 PM CEST

I'm in favor of

using just one skinset and including any messages and texts via a macro. Otherwise we'll just multiply the effort of modifying any skin by the number of translations we have, and if translations are maintained off-site it'll even increase the problems.

People wanting to modify messages in skins will get used to the fact that they're replacing a macro instead of the text itself.

link  


... comment


The Antville Server Fund has been a great success. Thanks to everybody who contributed!
online for 8550 Days
last updated: 1/4/11, 10:22 AM
status
Youre not logged in ... Login
menu
November 2024
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
July
recent
zfuture's house here is zfuture's
house
by zfuture (7/31/03, 2:59 AM)
i understand your concerns however,
i hardly can think of a solution. certainly, if the...
by tobi (7/29/03, 9:47 AM)
Found several more similar sites
listed This is getting to be quite a concern to...
by cobalt123 (7/27/03, 7:56 PM)
Second Post Alert on Referrer
bug livecatz I put this into "help" and now here:...
by cobalt123 (7/26/03, 7:14 PM)
well it's not easy to
find from here, anyway. think we should include a link,...
by tobi (7/24/03, 11:25 AM)
So finally I found
the helma Bugzilla - stupid me.
by mdornseif (7/24/03, 10:28 AM)
clock not that it's particularly
earthshattering but the antclock is running slow by about 15...
by kohlehydrat (7/23/03, 8:25 PM)
but blogosphere.us isn't can't really
be rated as spam can it?
by kohlehydrat (7/23/03, 8:08 PM)
More referrer spam www.webfrost.com
by Irene (7/23/03, 7:55 PM)
How to log skin names
I accessed to console?? Hi, I would like to know...
by winson (7/23/03, 4:12 PM)

Click here to get an XML version of this weblog.

Made with Antville
powered by
Helma Object Publisher