All database tips and tricks, installation, setup, configuration, optimizations tutorials
To calculate number of session per username with status and detail source address, original OS user in Oracle database, you can use this command.
SELECT USERNAME, STATUS, OSUSER|| '@' || MACHINE AS SOURCEINFO, COUNT(*) AS NUMOFCONN FROM v$session WHERE TYPE = 'USER' GROUP BY USERNAME,… Read the rest “How to check number of sessions of a user in Oracle”
By default, MariaDB not allow you access as root from anywhere but localhost. In order to allow remote root access to MariaDB, follow these steps.
Use this command
sudo mysql -u root
In my cars_positions database and positions collection I have this kind of data :
db.positions.find()
{ “_id” : ObjectId(“536a5cd9e9df25cd8609d286”), “car” : { “type” : “sport”, “ref” : “nameOfTheCar1” }, “position” : { “dateTime” : “2014-05-06T06:42:10”, “latitude” : “0000.1111”, “hemesphere” … Read the rest “Use distinct in php MongoDB query”
It has been a few days I have started learning Node JS.
My Node JS application has a get api which fetches the books information from the MongoDB database in json format … Read the rest “How to implement a cron job (using node-schedule) in a Node JS application”
I am new to MongoDB and learning to write mongodb queries. I need help for below problem:
Input data is a collection student having five records:
[
{
“_id”:0,
“name”:”Maxy”,
“results”:[
{
“subject”:”maths”,
“score”:1.46
},… Read the rest “Find count and percentage of students failed in a subject”
I have collection with thousands of documents, in document there’s field named Rate, problem is currently its type is string, so when it’s not available, the old developer set it to “N/A”. For now I want to change the type of this field … Read the rest “Custom deserialization”
so I have a spark code that fetch some documents from mongodb, does some transformation and tries to store it back to mongodb.
The problem happens when I try to persist a List object using … Read the rest “How to persist a scala list to mongodb using spark”
The credentials of a newly deployed app are rejected by MongoDB with “Authentication failed”. The MongoDB Ops Manager is stuck on “AdjustUsers” for a few hours already.
Verified by:… Read the rest “App fails to connect to MongoDB Enterprise with “Authentication failed” and Ops Manager stuck in “AdjustUsers””
I’m using that latest version of morphia (1.3.2) and I’m trying to replicate the following succesfull mongodb aggregation stage in Java:
{
_id: null,
pv: { $push: { t: ‘$_id’, c: ‘$c’ }}
}
example input to stage … Read the rest “Morphia aggregation stage group with object push”
This question already has an answer here:
lookup in mongodb aggregation
1 answer
Up to last version of spring i have seen lot of stack over flow questions which shows there is no … Read the rest “how to use $lookup stage in java with spring data mongodb? [duplicate]”