Tag Archives | Database

Updates on Razuna – open source Digital Asset Management

Just a short notice that a version 1.1 of Razuna – open source Digital Asset Management (DAM) with integrated Content Management (CMS) – is coming in about two weeks.

The major change for version 1.1 will be that it will feature an embedded database, meaning you won’t need to install any additional database. The embedded database performs very well and holds up in production environments as well. This just brings down the installation of Razuna to 2 minutes (downloading Razuna, unzip it and run the server)! Of course, support for the existing Oracle database is still available.

Also we ironed out a couple of bugs that sneaked in after the 1.0 release.

Razuna is a professional digital asset management/media asset management with an integrated web content management that delivers and makes management of your digital assets a simple task. Razuna is licensed under a dual-license (AGPL and commercial) and can be downloaded at http://www.razuna.com.

Comments { 12 }

Scalability is the key

Peter Van Dijck has a very good list of popular websites and how they manage scalability of their web application. He has presentations on scalability from websites like Twitter, Flickr, Slideshare and many others. Is it a very informative read and brings a lot of insight how it is done.

One thing that stood out is that the key lessons for most apps: Memcache like crazy, and optimize the database (the biggest bottleneck most of the time).

Looking trough the Memcache page I see that there are different API’s available for many popular languages. For CFML developers the Memcache Java API might be the most interesting one. Memcache goes beyond the cachedwithin of a cfquery and looks to be a solution for scalability. Else not all web apps would use it.

Another practive is “sharding”. Sharding is when you cut a really big table into pieces, so you can put those on separate servers.

All inall, a very good read and well worth your time.

Comments { 32 }

SQL Developer 1.5 available

Oracle released SQL Developer 1.5, latest version of Oracle’s free, powerful graphical database development tool, today.

SQL Developer provides a graphical interface so users can browse the database, run SQL, PL/SQL and SQL*Plus statements, execute SQL scripts, and edit and debug PL/SQL statements.

The latest release includes a new File Browser feature so developers can quickly and easily browse for files stored in the file system, and then open and edit them within the SQL Developer environment. They can then check out a working copy, then edit and merge changes back to their version control repositories, making team development easier.

Thought, SQL Developer is a Oracle tool, one can access MS SQL and MySQL databases as well. SQL Developer is a free tool and available here.

Comments { 14 }

SixSigns announces free open source Enterprise Media Asset Management

SixSigns is announcing today that we have plans to release our Enterprise Media Asset Management (MAM) as a free open source edition (based on ColdFusion). Our MAM system has been previously deployed as a licensed system and is currently in use by over 70 organizations. Our plan has always been to release the system as a open source solution, but it only made sense since New Atlanta’s announcement of releasing BlueDragon as open source last week.

As said, we are still in the planning of the open source edition, but here is a summary:

  • The MAM system will be released under the AGPL license. The GNU Affero General Public License is a free, copyleft license for software and other kinds of works, specifically designed to ensure cooperation with the community in the case of network server software.
  • A dual-license will be offered for customers that need it.
  • The system itself comes with a integrated Web Content Management (CMS) and can be tailored to fit any needs.
  • The current system is based on ColdFusion and the Oracle database. Currently all media assets are stored within the database and Oracle features special hooks for digital media assets. But users would have to have the Oracle database 10g R2 (at least in the standard edition one). We will change this to enable additional databases (especially MySQL) to really offer a complete open source solution (our system, Blue Dragon J2EE and database).
  • We will offer and provide different support packages to give organizations the level of support that they need.
  • We are planning to release the open source edition in about two month. As said we are rebuilding some parts of it to support different databases (thus rewriting search, indexing and handling of media assets) and have to rewrite some other code to suite BlueDragon’s CFML support.
  • BlueDragon J2EE edition will be released as a virtual image (VMWare), thus we will offer a fully installed version of our system on top of the virtual image as a free download as well.

We are in the middle of building a new website for the open source system and will make some more announcements on this blog in the near future. If you do have any questions or comments please leave a comment here.

Comments { 62 }