Archive for the ‘Uncategorized’ Category

New project, new opportunities

Starting own software development consultancy & outsource company, check it out at


Seedcamp is going to Kyiv!!!

I’ve received unexpected message where Seedcamp announced their event in Kyiv. I’m really excited about new opportunity for startups in Ukraine. It will be nice to start internet entrepreneurship in Ukraine!!!

I’d like to say guess a good luck for every participant!!!

Do world need a new Web Application development framework?

I’ve started to work for a new company 1 month and a half and a few days ago (1st of march). Company name is Componence ( We have started new office in L’viv, Ukraine with a new great team. I’m working in position of team leader here.

Componence works on bringing power of enterprise portals to big companies. We have own product and it’s named PortalSuite. It’s a set of portals for a WebLogic Portal server. It’s good enough to sell it. But now it’s time to build a new product for rapid portal development to respond for a new times coming.

CEO of our company wrote on his blog post about choosing a framework for our new product. And a lot of guys have responded to his posts on LinkedIn and other sites. All of them said about existing frameworks, their props and cons, but no one said it’s time to develop new framework.

All of existing and famous framework has been designed years ago. And goal for all of them was to provide easier way to build web applications, separate different kinds of logic and help to build UI more effectively. Sometimes ago they added some AJAX support (2 years ago or so). But now we have new big players on market of UI development frameworks for web applications – ExtJS and a Yahoo! UI. Both of them bring new way of abstraction for a building of web-based UI. And no one server framework consider on that.

So … I’m wondering is it a time to build a new server-side framework which will be integrated with ExtJS to bring new wave to web applications (portals) development?



SQL bug (or a feature) which allows to combine both assignment of value to a variable and retrieval data operation in the same query

I’ve found interesting issue today. Everyone knows “A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.”

So it’s impossible to do something like:

declare @a int

select @a = 1, 1

If you will do so error is raised. But interesting thing is if you will combine assign operation with another assignment in union query you will get no error. Here you have code for an experiment:

declare @a int

select @a = 1

union all

select @a = @a where 0 = 1

With this query you will have 1 displayed J I don’t know what it can be used for, but it’s funny.

And I’ve noticed – minimal variable name which can be declared in SQL Server is no symbol. Following query will work just fine: declare @ int. So you can assign values to @ and do whatever you want.

Try to parse XML (similar to Integer.TryParse).

I’ve facing following problem during my current project. We have a lot of automation here. We have plug-ins architecture inside. Plug-ins are simple classes which inherits our special interface off-course. But main issue for plug-in is to persist his status. It’s possible with properties. So plug-ins are classes with properties which are processed automatically. Under processing I’m talking about setting/getting values and storing in our system. But plug-in can contains not just properties with simple types but complex types as well. Here complex type is some class which can easily be serialized/deserialized to/from XML. So we should be able to store complex types in properties. BTW: all values are storing as strings in our system. If can’t then I’m trying to convert value to a type of property. During conversation I’m checking if the passed value can be deserialized to complex type if yes – then it’s deserialized and value successfully set. If not I’m looking for a converter if no converter found I’m trying to set value directly.

    So my actual problem is that I can’t check that string can be parsed by XML processor. For example if we have in the string special symbols it can’t be processed. So I need to do try … catch to handle errors during deserialization. So I’m wondering why haven’t Microsoft add TryParse method to XML processor.