Database Schema online

Finaly I finished the Database Schema.

I tried to achieve 3N to all relations (What is 3N? See Wikipedia).

Especially for the Taging schema I choose this approach, called “toxi”, because it is the most scalable and reliable I found. It might not be the fastest way to do this, but in future if there is a need for there could be a hybrid between toxi and the Mysqlicious approach with fulltext which is also used by del.icio.us. A Hybrid in that manner would start both strategies as individual queries and then uses first comes first serves.

To visualize the Database I installed SQL Designer on the sample Platform. You can find it here.

With this tool you can see the current DB Design and even Modify it. So if you have any proposals for improving the database design or find some major flaws you can post it as a comment here or just draw a picture with the tool

If there are some questions for using the tool visit the Website mentioned above or just write me an email or comment.

Please save it under a new keyword if you modify it so I can see all the different proposals. If some of you just don’t care and overwrite it anyways, you others dont fear:

If there are some problems (like someone deleted or overwrote the Schema) or the Database has changed but you still want to see or improve the Database Design, here is a XML file with which you can recreate this version. Just click Import from XML in the SQL Designer and paste the XML data.

Don’t worry no matter what you do you won’t affect the real database in any way.

I also made an Snapshot for archiving reasons.

So long…

- – -

In case you wondered:

FK = Foreign Key

PK = Primary Key

Activity Ranking

Today ContactR also scored 57.89% Activity.

See it in the Forge.

The Complete Statistics were:

Activity Percentile: 57.89
Activity Ranking: 25.00
Register Date: 2007-11-21 21:56

I finally also completed the data on the forge and started the Task Tracking system as well as the source control.

-> https://forja.rediris.es/projects/csl2-contactr/ 

If you want to checkout the current version of Contactr (0.3.0.0) use this commandline:

svn checkout https://forja.rediris.es/svn/csl2-contactr

or if you prefer to download it as tar.gz file:

-> https://forja.rediris.es/snapshots.php?group_id=299 

Development Status + Newest Version uploaded

So here comes the current status. For the ones which didn’t test ContactR yet, and the ones which want to test it again (username and pw changed):
- location: http://contacts.shdev.de/
- user: admin
- pw: 1234

In the actual version didn’t change too much, at least not noticable. I have moved the user handling into a MySQL Database and implemented an login/logoff mechanism provided by the phpUserClass.

Further I started the Database-Design for the rest of the data. Right now there is a XML-MySQL hybrid used.

But before I continue telling what is planned to implement here the current feature list:

Server:

• Login user
• Logoff user
• Register user with email for activation Link
• Activate user
• Remember User per Session
• Remember User per Cookie
• Load contact data from XML file
• Load contact data from LDIF file
• Load contact data from VCF file
• Save contact data to XML file
• Save contact data to LDIF file
• Save contact data to VCF file
• Create contact
• Read contact details
• Delete contact
• Read list of contacts
• Read list of groups
• Read relation between contacts and groups
• Interface for converter plugins
• User Roles not yet used

Client:

• Login user
• Logoff user
• Show list of groups
• Show list of contacts in current group
• Show list of contacts in all groups
• Remember user per Session
• Remember user per Cookie
• Import LDIF file
• Export LDIF file
• Create contact
• Show contact details
• Delete contact
• Refresh data on command
• Search incrementaly and instaneously in current contact list
• Show contact detail region
• Hide contact detail region

So far the features. If you find one I missed tell me

I promised to post the time line with the milestone for the feature as well as the approximated times for the milestones in the next days.  Of course there will be a complete feature list with all todos and dones.

So long…

Blog online

Hi to all of you out there.

I finally brought online the blog for ContactR. Here I will post news depending the development of ContactR.

If some of you are not sure what ContactR is or will be, here is the short description:

ContactR is a social Adressbook. That means you can manage your contacts, list your phone numbers, sort your emails or import and export them to and from clients like Thunderbird or Outlook. Furthermore you can use everything from your Handy, out of your Browser with the sleek websurface, as Gadget on your favorite Dashboard (e.g. iGoogle, Netvibes, …) or from your Windows Vista Sidebar.

It is developed for a contest in Spain called “II concurso de software libre“. I’m proud to participate with so many others. There is a list of participating project on the page of the contest (here)

I hope that explains it so far if there are more questions read the longer description in the forge, leave a comment or write an email to contactr@shdev.de.

Test Development Snapshot of ContactR: http://contacts.shdev.de