Coins catalog: over 14,000 coins

Quietly but surely, Colnect's coins catalog, being built by coin collectors for coin collectors, has surpassed 14,000 listed coins. It's freely available for browsing even without the need to register. Free registration to Colnect allows collectors to manage their personal collection.

Colnect's coins catalog is currently the world's biggest freely available resource for coin pictures and information.

Collectors premium services on Colnect

A few days ago, Colnect's premium services for collectors have finally opened up. Colnect has already been offering a respectable set of free services to collectors from around the world. These free services will continue to be offered for the benefit of the entire collectors community.

The announcement has been made:
"Premium membership gives you access to several features that will enhance your Colnect experience. If you regularly use Colnect, please consider supporting us by becoming a premium member."

Currently, not many premium services are offered but these will be added with time according to collector demands.

Happy collecting :)

Colnect's Alexa Rating Keeps Climbing

Since the last post about Colnect's ranking on Alexa, it has risen again, now standing at 144,039 whereas a month ago it was 184,627, ~4 months ago it was at ~360,000 and ~6 months ago ~500,000. More information on my previous post about the subject.
The ranking is coherent with Colnect's internal report, showing a significant increase in traffic during the last months.

3,500 collectors on Colnect

Yesterday Colnect has passed the mark of 3,500 registered collectors. This is an increase of over 17% during the last 2 months. Just before starting this year, Colnect had passed the 3,000 collectors mark. Considering the fact that ridiculously little marketing work has been done (~$50 spent on ads...), I see this as a very respectable achievement that continues the growth that started when Colnect V2 was released.

How do collectors learn about Colnect?

As Colnect allows collectors to manage their personal collection and semi-automatically manage swaps with other collectors from around the world, it's the collectors' own interest to have their collector friends join the site. Why would a collector go through the swap and wish lists of another collector manually when a match to his own lists can be done using a single click?

So what's next?

Colnect will expand to more collectible fields as requests come from existing members of the community. Some requested premium services are also planned.

BE CAREFUL when using both AdSense + AdWords by Google

Do you have a website and using both AdSense and AdWords? If so, this post will interest you. You may start by looking at the attached picture.

AdWords and AdSense are the different sides of the same coin and Google is in the middle, biting on the metal. AdSense allows website owners to show different ads from different advertisers on their website and receive revenues for it. AdWords allow you to advertise your website on many other websites running AdSense. Google takes its commission for providing both these services. Though many other competing programs exist on the web, Google's generally have good reputation.

Advertising my site on my site?!?!?!

This morning, I was amazed to see an ad to my website for collectors on the same site! Had I clicked this ad, my AdWords account would have been billed for the click while my AdSense account would have received some revenue. Obviously the latter would be lesser since Google get their cut. This is, of course, ridiculous and should be automatically prevented by Google. Apparently, it isn't. Just to ensure you that I'm not an idiot, the ad is for colnect.com and the website is on the same domain - colnect.com

I usually view my own site with ads disabled so I don't accidentally click an ad and violate the terms of service. This time I was at a friend's house and am quite happy to have stumbled upon the aforementioned bug/feature.

Quick Remedy

Both accounts allow you to use filters and I've now added "competition filters" for my AdSense account that will prevent showing ads for any of my domain. It's also possible to filter out sites on AdWords but this can seemingly be done only on the campaign level so if you're running many different campaigns, it'll become tedious. See the attached pictures.

Colnect's Alexa Ranking Keeps Going Up

Colnect's ranking on Alexa has risen again, now standing at 184,627 whereas ~3 months ago it was at ~360,000 and ~5 months ago ~500,000. I don't even know if it's linear or logarithmic although I guess the latter.

To those who may not know, Alexa ranks many (most?) websites out there of the big WWW. It does that by analyzing the traffic of (mostly unsuspecting?) users who install the Alexa toolbar on their browsers. This nice toolbar delivers the information back to their big servers, they crunch it whichever way they like and then rank the sites according to this information.

Why would anyone care about Alexa's ranking? Well, it has come to be relatively important in the WWW world. It allows you to have some (allegedly non-biased) objective information about how your website fairs on the Internet.

Are the results reliable? The short answer IMHO: no. The longer answer: perhaps, to some length. Since some website owners/operators/SEO personnel think of it as important, they are making an effort to get their ranking up. This isn't that hard, considering the fact the grand majority of users don't have the Alexa toolbar. There are many methods but they're basically about making people who use your site have the Alexa toolbar thus your site will have an improved ranking.

Another important disadvantage of Alexa is that ranking is on a per-domain basis. As such, this blog (which a few read) ranks the same as Colnect (which many frequently use). Personal websites on some free hosting all rank the same so you cannot tell them apart and so on.

Does Colnect try to improve its ranking? No. I did think about it for some time, since after all it may look better to some people, but have decided not to. The main two reasons would be not to spend my time on metrics that don't really matter and the second that since I wouldn't install it on my machine, I wouldn't ask others to do so.

Okay, let's hope this post won't cause Colnect's Alexa ranking to crash :)

Phonecard Puzzles

When a few items can be combined to a bigger one, it's a puzzle. A new and unique feature of Colnect shows the combined puzzle items together so that collectors may see the whole puzzle, even if they've not yet obtained the physical items. Puzzles are more common for phone cards but may sometimes be found with stamps as well.

Click here for an example Disney puzzle

or better
All phone card puzzles on Colnect

Usability

A good system doesn't only have to offer users worthwhile services but should be as easy and intuitive to use as possible. When people access so many websites, they expect everything to be natural for them. Rarely do people actually read long HELP sections. Frequently they simply play around with the application and what they can't see quickly would many times never be used.

Though these are old news, the user interface on Colnect V2 has initially not been properly designed and implemented. I admit this was a big mistake since it made the usage of existing users much more awkward and wasn't inviting enough for new users. Though Colnect did grow very nicely since V2 has been released, it's likely despite the user's interface rather than because of it.

So the good news is that in the recent days and upcoming days the user's interface will be added with many useful options to make the usage of Colnect as easy and intuitive as possible.

Here are two examples for recent additions:

CSS-only popup menus

Sorting collectors lists by clicking the column header

Colnect's Minor Contribution to World Peace

As Colnect embraces collectors from all parts of the earth and of different languages, it adds a small contribution to world peace. I strongly believe in promoting peace on the individual level. We are all people and though we may differ in our views and culture, we share so much in common. Getting closer to people of different backgrounds allows us to be more open minded and accepting of the differences. When collectors connect, they also make friends in distant places and learn about other countries and cultures.

Colnect's platform allows translation to any language so that people of different cultures can join us and enjoy sharing their hobby with others. Currently 25 languages are translated properly and 5 more are pending translation. All translations are done by volunteers and so any new language is welcomed.

Colnect does not promote political discussions since there are other, more suitable, sites for that. The lack of politics on Colnect allows all to join in and make friends without prejudices.

Though personally I come from a turbulent region, Colnect isn't and wouldn't be identified with any specific country or political stream. The English language is used as Colnect's base language only because it's the most popular language on the web world for now.

Happy collecting and peace to us all :)

Very happy holidays :) Over 3,000 collectors on Colnect

As 2009 is looming, Colnect has happily announced that its community now has over 3,000 members. Colnect's community growth rate has been on the increase, especially since the new Colnect V2 site has been launched during the midst of October. Since now Colnect caters to stamps and coins collectors, it has found a new crowd of people interesting in managing their personal collection easily and connect with other collectors from around the world.

Colnect's development relies on the assistance of its ~70 contributors who volunteer to translate Colnect, update its database with new collectibles and help with various tasks.

Though this blog has recently been quiet, a lot has happened on Colnect recently. The lack of a PR department in Colnect takes its toll and certainly Colnect would have bloomed much sooner with such. New features and fixes are added daily to the site and the contributors help update the catalogs on a regular basis. Colnect's collectors forums provide more detailed information about recent updates to the site.

iGoogle Collectibles Gadgets

Colnect has just released 3 iGoogle gadgets that you can see right here on the side of this blog. Read all about these cool collectibles gadgets.

Here's the description:

A cool gadget for collectors! See a new random collectible item. Click the picture to see complete information about the item: which memebers of Colnect Collectors Community have it on their collection, swap or wish list. You can easily manage your personal collection on Colnect and find swap buddies from all around the world. The huge catalogs on Colnect are created by collectors for collectors. Join Colnect now. It's fun, it's quick and it's free! Happy Collecting :)

50% increase in Colnect's growth rate - welcoming stamps and coins collectors

Less than 2 weeks following the initial release of Colnect V2 and without any commercial advertising of Colnect, there are already ~90 active coins collectors from 35 countries and ~50 active stamps collectors from 25 countries on Colnect. Active refers to a collector who has updated his/her personal collection on Colnect.

The overall amount of newly registered members during the last week shows ~50% increase over the weeks before it. This achievement, enhanced by the facts that the new site experienced some downtime and that registration now requires email address confirmation, should probably be attributed to the collectors who already know Colnect. Some collectors collect more than a single collectible and so many phonecard+coin collectors would know other coin collectors and let them know about how useful Colnect would be for them.

To help motivating collectors the following news item has recently been published on Colnect:

Help Colnect and Win Free Phonecards!

Colnect now has a huge stamps and coins catalog. However, since it's so new, many collectors of stamps and coins have not yet heard about us. Now is your chance to help Colnect and win free phonecards.
How?

Simply tell your collector friends to join Colnect. Once they join and update their collection, they should Contact Us and tell us you told them about Colnect. Every friend that joined Colnect with your help entitles you to 10 points. Each friend your friend bring, gives you 3 more points.
Who will win?

The 3 collectors who has accumulated most points until the 30th of November.
What will you win?

First place: 50 Phonecards
Second place: 40 Phonecards
Third place: 30 Phonecards
BONUS: A Colnect T-Shirt.
Questions?

Visit the forum for answers.

What about commercial advertising

Though so far Colnect did not rely on any commercial advertising but rather 'word of mouth' and friendly reviews and backlinks, it may be a good idea to advertise it some more with AdSense or a similar program. For the time being, I prefer to see a steady growth while I'm fine tuning the system and perfecting it rather than a flood which will make Colnect buzzing and later endangered.

150 OpenSearch plugins for Colnect

"OpenSearch is a collection of simple formats for the sharing of search results" the official website says. OpenSearch makes interfacing a website in which you use a lot of search much easier since you don't have to navigate through the site's pages to see the results. You skip waiting for a new page and save yourself some time.

Colnect supports OpenSearch for the benefit of the collectors on the site who often search the huge catalogs for the items they're interested in.

In Firefox:

and IE7:


Yesterday I've tried to publish the plugins on Mycroft Project so collectors could easily install from there as well. It's probably the web's most notable directory for OpenSearch plugins. The problem is that Mycroft has no auto-submission feature to be found and so I couldn't add all the plugins.

"How many plugins have you made?" you might ask and the answer is quite simple. There's one plugin to search for a collectible item by name and another to search for a collector by username. Later I may add searching by catalog code. So what's the problem submitting 2 plugins manually? Well... that 2 turned into 150 since currently there are 3 collectible types on Colnect (coins, stamps and phonecards) and the site is supported in 25 languages. 2 times 3 times 25 gets to 150 and that's not so much fun to do manually anymore... I hope they'll come up with a solution. The best would be to use simply submit the site's URLs and let MyCroft use the auto-discovery link tags like the browsers use to allow you to add the plugin.

Happy OpenSearching...

Colnect V2 is now LIVE! :)

Following a long period of hard work, Colnect V2 is now up and running. It is a completely new version of the familiar Colnect. Its huge catalogs, from which any collector can easily manage his/her personal collection, currently include nearly 12,000 coins and over 120,000 collectible phone cards. As the catalog information is contributed by collectors, the catalog is expected to grow very quickly in the coming months.

Colnect V2 is available in 25 languages accommodating for the needs of collectors from all around the globe.

Go check out the site and register if you haven't so far. We're on the way to revolutionize the collectibles world.

Performance: MySQL, APC, memcached.

A highly important issue of any notable website is performance. You may have created the best website in the world but if it dies under load, you're gonna lose customers. User experience is very important today and having a slow website doesn't help at all.

Optimization is, however, not a trivial issue and requires expertise in different fields. There are so many different places where you can optimize that it's not always that easy to know what to focus on. Though this post will adhere to its title I'll still list here where optimization can occur in a website.

* Correct usage of HTTP headers to make client browsers request less information.
* Smaller responses (gZIP / more CSS - less HTML / use of Ajax to return instead of reloading complete pages).
* Optimization of your server machine(s) hardware AKA "I need more CPU, I need more memory and 'how much is another 1U?".
* Server software optimizations: Webserver (such as Apache) / Scripting engine (such as PHP) / DBMS (such as MySQL) / cache engines (such as memcached, APC) could and should be tweaked heavily. Failing to define an appropriate index in your DBMS or making some wrong choices on where and when the webserver saves user sessions, for example, could carry a heavy toll.
* Network optimizations: anyone said CDNs?

The fun part is that all these parts are well entangled.

I've read an interesting post about prefering MySQL cache over the popular memcached in some situations. Though it was pretty much one-sided (ignoring the overhead of a database connection), it rose some interesting points and is well worth reading.

An advantage towards the DBMS that I consider relevant is greater flexibility. For example: you allow outdated information to persist (such as statistics). Say you want it updated about every 5 minutes. If you cache it for 5 minutes it'll expire and then you may face a situation in which a few threads query the database again to get this information. If you use a Memory table for this information you can read it and, if expired, set some writing lock that'll cause other thread to keep reading the expired information until it's well updated.

Another interesting older post about performance showed some interesting benchmarks. The biggest problem of relying on others' benchmarks is there can always be one single parameter different on your system that would mean the results for you would be totally different. For example:
* A new version of a product has just changed everything about it.
* A configuration option made a product completely flunk its benchmark tests.
* Your queries may not be similar at all to what is tested (though you may think it is).

So these were my 2c about performance for now. The bottom line is simple: there's always a part of your system that's not properly optimized. The best is to check the painful spots and remedy them while maintaining an overall look of what your system has to provide.

Colnect V2 alpha site is up for the Prague Fair

During 12-14/9/2008 a big international collectors fair is being held in Prague. To allow collectors to preview the new version of Colnect, which includes a vast database of stamps, the alpha site has been opened and is available here.

At the moment it is NOT yet considered stable and is meant only for the taste of how Colnect would be. Hopefully, it'll be ready by the end of the month and the current Colnect will be replaced by the new improved one.

There are many new things in Colnect V2 but perhaps the most important ones for current Colnect members are the addition of versatile filters to the system which allow collectors to easily find the items they're looking for and match them with collections of other collectors.

Updates to follow...

Doctrine v1.0 is finally out

Colnect V2 (including stamps and more collectibles) is now almost ready to be shown in alpha and that's why it's such good news that Doctrine v1.0 has been released.

Doctrine is a PHP ORM that is nicely integrated with Symfony. It allows defining your database schema easily with YAML files. The database and PHP classes can then be automatically generated to provide you will all the needed functionality of database interaction.

Although IMO some edges have not yet been met in Doctrine (most importantly the i18n support), I hope it'll be able to work properly on the new Colnect. Developing with an ORM is surely much easier to maintain than using raw SQL. I expect Doctrine to keep growing stronger and more stable in the near future as the ideas behind it are very useful and needed.

How many collectible phone cards are there?

I'm sorry but this blog post is not going to answer that question.

When I took over Colnect (previously known as Islands Phonecards Database) we've had ~30,000 collectible phone cards in our database. Less than a month ago I've written that "Collectible phone cards catalog has passed 100,000 items" but as of today I'm happy to announce that Colnect's catalog has just passed the 110,000 mark.

It seems that not only is the database growing, but that its growth rate is on the rise. So when will it stop? Obviously it'll start slowing down when most of the collectible phone cards in the world will already be listed on Colnect. Just how many are there? As I know we're still missing some tens of thousands of Brazilian and Chinese cards, my assumption ranges somewhere between 200,000 and 1,000,000 different collectible phone cards. The variation is great due to the unexpected nature of variants. A card may be listed once but then an expert collectors note that there were small variations between the different prints and one card becomes 20 different variants, all with different collectible value.

So when will this race stop? Let's wait and see...

A new blog post about Colnect

Israel on Blog has just published a post about Colnect that you can see here.

Following the Doctrine for Colnect Philately

Colnect Philately is now under rapid development and is planned to have a limited release in September. Colnect is written completely from scratch, using bleeding edge tools which provide really cool features but come with a price. Once such tool is Doctrine.
Doctrine is a PHP ORM that is nicely integrated with Symfony. It allows defining your database schema easily with YAML files. The database and PHP classes can then be automatically generated to provide you will all the needed functionality of database interaction.
Doctrine is not yet a completely mature project and that becomes when using it for some time. However, it's going in the right direction and yesterday's announcement that "Doctrine gets its first employee" is an important step for an open source project.
So yes, using bleeding edge tools is a bet but being an entrepreneur is about believing, isn't it?