SQLCE: How to execute complex scripts

For one of the side-projects I am working on, I needed a way to execute long SQL scripts to create some reports. I started the project using SQLCE because I didn’t wanted to bother with a full installation of a SQL server (even the Express one), so I wrote all...

1 minute read

AngularJS + MVC : how to pass model from server to Angular controller

Here’s a quick tip on how to pass a complex model from server side to an AngularJS controller. The idea is to serialize the model to json (I am using the majestic Newtonsoft library for that), store it into a javascript variable and then create a provider with it on...

1 minute read

Videum 2.0 is here!

After almost one year, yesterday we pushed to production the new version of Videum ! It’s a major milestone, this time we started the entire application from scratch, writing a brand new ad-hoc CMS and moving from MSSQL to MongoDB. The search engine instead is based entirely on Elasticsearch, with some minor...

1 minute read

Case-insensitive queries on MongoDB

Short version: you can’t. Long version: well…. you can’t 😀 Or at least you can’t NOW, based on what is stated here : https://jira.mongodb.org/browse/SERVER-90 . If you really need case-insensitive queries one option is to create another field with a lowercase representation of the text, put an index on it and run...

1 minute read