Freelance programer's notes

I have tested several open-source embedded DB engines for .Net to find which one is the best for my purposes. My choice for testing was: FireBird 2.5 .Net Provider with patch applied sqlite-net r.71 with patch applied System.Data.SQLite 1.0.74.0 (3.7.7.1) x86 Test application I wrote does following actions (and measure consumed time): Prepare DB: Recreate DB & tables (3 tables, 2 non-PK indexes) Create DB: Insert ~500 records to the DB Read All: sequentially read 400 records from the only table (no joins) Read Random: read random 400 records from the only table (no joins) Read / Write All: sequentially read & update 400 records from the only table (no joins) Read / Write Random: read & update random 400 records from the only table (no joins) Results you may see here . FireBird is ~30 times slower on read operations than SQLite but 10-20 times faster on write operations. Overall time wins FireBird. It is 7 times faster. As for SQLite .Net adapters System.Data.DQLite is f...

EzMute & EzPTT for Skype 1.0 is released. It creates visual button always on top of windows to mute Skype and allows to configure keyboard keys for mute and push to talk.

Using in CakePHP custom behavior (like LinkableBehavior ) or aggregated fields (sql count, max, min , etc queries) or virtual fields in model breaks sorting with PaginationHelper . Trying to sort on field that does not explicitly defined in the model or directly associated models leads to loosing all sorting information. To fix this you need to correct Controller->paginate() method. To do so create file app/app_controller.php if it doesn't exist and define AppController class there. Add paginate() method to it and copy it's content from the same method from cake/libs/controller/controller.php file. After that replace $value = $options['order'][$key]; unset($options['order'][$key]); if (isset($object->{$alias}) && $object->{$alias}->hasField($field)) { $options['order'][$alias . '.' . $field] = $value; } elseif ($object->hasField($field)) { $options['order'][$alias . '.' . $field] = $value; } with $v...

To fulfill previous post I want to provide my research on free online issue and bug tracking systems available on the Internet. Surprisingly there are very few of them matching my criteria: 5 users minimum, 10000 tickets minimum, closed for public. Here they are: The only totally free & unlimited is defectr.com . It has limited functionality and funny UI but has no users nor projects limitations. My choice #1 for not complex projects. w3spt.com offers 10000 messages/5 users/100Mb-limited complex integrated project tracking system . It has a lot of custom views and reports such as FAQ, Forum, Feedback zone, Knowledge base . I would recommend it for complex but not huge projects. And the last one I want to mention is teamatic.com . It provides simple tracker for 5 persons with 5Mb attachments storage and nice interface . It may be used for small simple projects.

I spent a lot of time to choose high-quality online software project tools for free . Some of them are not so "free" other ones have a lot of ads or have low quality. Trying different solutions I chose following: Instant public chat : there is an options. You may create IRC channel on efnet.org or maintain public chat with Skype (BTW Skype supports up to 150 chat members now). Collaborative documents authoring : Google Docs have no competitors in this area. FAQ service : personally I prefer bravenet 's one. Mail list / discussion group : again Google Groups is the best one. Project management : unfortunately I was unable to find any wholly satisfactory project management online service. If you know one please let me know.

In previous post I called opensvn.csie.org one of the best free SVN repositories for closed source . Now I want to show how to configure integrated Trac initially. First of all go to "Manage Your Project" tab and login. Go to "trac" tab and click "interface to trac-admin" link. Enter " permission add username TRAC_ADMIN ", where "username" is your login, to text field and press "Execute" button. After that you may visit your Trac (https://opensvn.csie.org/traccgi/username) and configure it using " Admin " web interface.

For small non-profit or freelance projects I used free assembla SVN repository and admin page before. After it became paid for closed-source projects I spent a lot of time to find the replacement. Here are my best findings: opensvn.csie.org - the best one. One repo, unlimited space, unlimited users, Trac & Trac admin. svn.xp-dev.com/app - another "the best" one. Unlimited repos (5 initially), unlimited space (300 Mb per repo initially), custom tracker (not very comfortable), unlimited users. unfuddle.com - has both free & paid plans. Free one is 200Mb for 2 persons Git or Subversion repositories, tracker. Unfriendly interface. codespaces.com - only 50 Mb for private repo for 2 users, wiki + tracker. Hope this will be helpful.