Taking the most of databases without SQL

Small Data still has a major role in company's day-to-day activities and databases are still here to stay. Database engines are more powerful than ever and handle really well calculations, so why should we not take the most of what they have to offer? fig 1 - a database schema with its tables and columns Viur has a feature that lets you perform advanced calculations and/or apply functions over your data without having to know any SQL or scripting language. You can use your table columns to create new attributes that are called “Formulas”. When composing a new Formula you can use mathematical operators: +: Addition -: Subtraction * : Multiplication / : Division ^ : Power and functions: ABS: Absolute COUNT: Count COUNTD: Count Distinct...

Read More »