UniTextus.net: A work in progress!

Full-database draft #4

Freak — Wed, 30 Jan 2008 00:27:59 +0000

After having had the hard start-ups after the holidays, we gathered our strength, and got back working on this project. For those of you who are looking for a download that provides a fully functional wiki, blog & forum, we’ll have to disappoint you: There is none ATM. All we’ve done so far is thinking of some database-design.

Of course we’d like to elaborate the current draft, but most of it speaks for itself (at least we think it does). If you have any questions, feel free to ask (leave a comment, that is). There’re two files attached, one is a PostScript containing a visual representation of the proposed database, the other file is a plain/text file, containing the sql-statements of the design.

For those who were involved in #3, but were not involved in draft #4, that may be right. I just noticed a couple minor mistakes in #3, and decided to fix those myself (1:15 am, pretty quiet on IRC).

- Full-database draft #4 (PostScript)
- Full-database draft #4 (SQL)

Entries database design

Freak — Wed, 26 Dec 2007 12:48:56 +0000

For now the biggest point of disscussion is the database design. Because the entire application is based on a database, it would be a huge mistake to scamp this design. The idea is simple, every piece of text is essentially the same, this is why we (plan to) have a table with two rows only, an identification-row, and a row with the text. Depending on the kind of entry (blogpost, wiki-page, etc) other data needs to be saved that’s what we use the table metadata for. For this, you could think about title, order (forumcategories e.g.) and the type
of contents (forumthread, forumcategory, blogpost, etc). We’ll also support tagging, because
it will happen most often that tags are used more than once,
we’ve chosen to use a many to many relationship for these with the entries. Then there’s the table what it’s all about, the table that defines the relationship
between 2 or more entries here

Someone also wondered why have fixed ‘types’ for each entry. We basically don’t because you can add just as many type-metadata’s per entry as one wants.

The proposal

So how about WordPress?

Freak — Tue, 25 Dec 2007 23:13:15 +0000

Today we got some questions about WordPress. “Are you going to fork WordPress?” one asks, someone else asks: “Why do you use WordPress if you’re going to write your own publishing system?”. These questions make sense, by the end of the day you’re now looking at a Wordpress blog . The only reason why we installed this blog is because our publishing system is far from finished - we don’t even have a (definitive) database design - and people want to keep track of our progression. We chose not to fork WordPress because it would simply be too much hacking and using workarounds, remember,
WordPress is meant for web-logging, and for web-logging only.

Sorry if the line-endings are wrong, WP is a pain in the ~~ass~~ bottom

UniTextus

Colin Helvensteijn — Tue, 25 Dec 2007 15:04:48 +0000

UniTextus, from the Latin words universi (all together) and textus (web), will be a new type of web publishing system. Instead of focusing on one type of content (blog, forum, wiki), the goal of UniTextus will be to have one system doing all that. In the end, each of those are simply entries in a database. It’s just a matter of how those entries are presented to the end user.

For more information, see the About page.