SQL “flavour”
Is there a proper, up to date reference on the SQL that Ninox uses anywhere that doesn’t involve picking through sample apps? I’m a MySQL user mainly (I’ve used some MS SQL and ages ago, Access). This doesn’t look like any sql I’ve ever used.
10 replies
-
codycoder, You can find the language reference here...
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
-
The code used is also similar to JavaScript if that could be of any help....
-
I did read that the NX scripting language is based on JavaScript. How does that factor into the sql flavour Ninox uses ?
-
You've got me curious. When you say "flavour", are you referring to the database engine?
-
Sort of. This article says it better than I can:
https://www.quora.com/Why-are-there-so-many-types-of-SQL-What-is-the-difference-between-all-of-them
Ninox's SQL reminds me of somtnkbg called "linq" in Microsoft's work. It's an attempt to turn sql statements which are "string litterals" in programming vernacular into more an object oriented syntax. Even that isn't a great explaination.
Take this example from Ninox's documentation:
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
sum((Invoice where Status = 2).Amount)sum(Invoice[Status = 2].Amount)This shows two different ways to sum the invoice where the invoice Status is 2
In mySQL for example this would be expressed as:
SELECT SUM(Amount) as Amount FROM Invoice WHERE Status = 2The NX Script looks (to me) like a 'mashup' between Javascript and SQL
-
Here's a link that has a response from Ninox support...
I have to say I prefer the less verbose syntax that Ninox offers!
-
In order to make successful HP Wireless Printer Setup you need to connect router, printer as well as your system all together. You should also ensure that HP printer and your computer both are connected on the same network or same access point. If you don’t know the procedure to do the same or having problem while creating setup, then you need to take assistance from an expert. For this, you can make a call at our toll free number and get united with them. For sure, after taking their support you will be able to resolve all your queries within a promised time frame.https://www.hpprintersupportpro.com/hp-wireless-printer-setup
-
great post. you can go with https://www.avastsupportnumber.us
-
In response to Sean's earlier comment (ignoring the last 3 seemingly unrelated posts) I have to disagree. SQL is a very mature language and fundamentally understood by many thousands of database users and developers, becuase it is a standard. Sure there are additions and extensions for specific SQL products, but its core remains the same. It is very powerful and once you understand it, you can apply that to ANY SQL database - even SQLite that Ninox uses. Any simpler alternative WILL suffer in terms of ultimate power and flexibility. SQL can do EVERYTHING needed to manipulate a database. That is what it was designed for and subsequently improved over many years to what now exists.
On the other hand, JavaScript was never intended for such specific usage and will NEVER be as useful as a database command language. I don't really understand why Ninox had to try and re-invent the wheel. Why not simply use SQL as the data manipulation language. If nothing else, there would instantly be many thousands more potential users of Ninox, users who wouldn't have to learn a new language.
Content aside
- 2 yrs agoLast active
- 10Replies
- 3906Views