I am writing the query to show the data entries for a specific year. Date is stored in dd/mm/yyyy hh:mm:ss.(Date TIMESTAMP – e.g. 12/2/2014 0:00:00). I am trying to display the two columns(name, orderdate) filtered by a specific year(year from orderdate). The requirement is to enter the specific year(2010 or 2020 etc) not the entire date. I tried using date_format()
Tag: nosql
How to achieve generic Audit.NET json data processing?
I am using Audit.Net library to log EntityFramework actions into a database (currently everything into one AuditEventLogs table, where the JsonData column stores the data in the following Json format: Me and my team has a main aspect to achieve: Being able to create a search page where administrators are able to tell who changed what did they change when
Select * Except particular properties in Cosmos DB with SQL API
Consider the following, I have a document that looks something like this: I want to get everything from the document EXCEPT $metadata and $version The obvious solution would be to: However, my document may expand dynamically, hence why the above is suboptimal. I therefore figured that it may be better to exclude just $metadata and $version. I looked at different
Why to use NoSQL DB when we could scale out SQL DB by sharing?
I recently read that the NoSQL DB scale out more easily than the traditional SQL DB. But consider that I have a huge table in SQL DB then I could easily distribute rows among multiple servers based on some hash function. For e.g. – If I have 4 servers I could do (id%4) where id is the primary key of
Sharding a RDBMS (SQL) database
I am reading about sharding and I understood it upto some context. But most of the material I read says that sharding (horizontally scaling) RDBMS is a challenging task. But I don’t see why NO-SQL is easy to shard and RDBMS would be tough to shard? My understanding is: some NO-SQL provides inbuilt sharding support which makes it easy to
NoSQL or SQL for Data Structure [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 1 year ago. Improve this question I’m building an app, and this is my first time working with databases. I went with MongoDB because originally I
Flat file NoSQL solution [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations. Closed 2 years ago. The community reviewed whether to reopen this question 1 year ago and left it
Best technology for building race simulation application
I am trying to do something new, something I have never done before. I am looking for advice or point me into right direction how to choose technology. I am trying to build race simulation app that will have thousands of iot devices streaming data into central platform. While I understand that I can use some sort of IOT hub
What’s the best way to handle an ‘very large’ inventory with SQL? [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 2 years ago. Improve this question I am looking into building an online card game like that of Hearthstone. Players will have an unlimited inventory to store
Telecommunication app database design [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last year. Improve this question I would just like to ask or get a few expert advices/directions on building a database and architecture for a telecommunication app.