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...
2015, Jan 05 — 1 minute read
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...
2014, Dec 31 — 1 minute read
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...
2014, Dec 06 — 1 minute read
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...
2014, Dec 03 — 1 minute read