Make your data beautiful again.
monsterCLI is used to start a database server, connect to a database server or run a loadFile process, the commands are detailed below
java -jar monsterDB.jar -s -p -a ============================================ Starting the MonsterDB thread pool server... ============================================
To increase the java memory available for the server use the following syntax:
java -Xmx3G -server -jar monsterDB.jar -s
Where 3G in this case represents 3GB of maximum main memory, if this isn’t available when the process needs it then it will still fail, to reserve this memory from the startup you can also use:
java -Xms3G -Xmx3G -server -jar monsterDB.jar -s
In the even the server cant allocate this amount of memory it will not start the monsterDB server
Your authFile should look like this:
{ identifier: "robert", password: "123", accountType: ""} { identifier: "robert2", password: "123", accountType: ""}
java -jar monsterDB.jar -?
Produces the following help:
java -jar monsterDB.jar
Is the simplest form of connecting to the server running on the same machine at the default port setting:
Connected to localhost monsterDB>
To be more specific over where to connect to:
java -jar monsterDB.jar -p 27018 -h myhost
-p specifies the port and -h the server to connect to
To specify the user and password to use (when authentication is activated)
java -jar monsterDB.jar -u dave -pw password123
java -jar monsterDB.jar -d database -c collection -r "command"
Connect to the server, use the database and collection specified (collection is optional) and run the command, will return the result to stdout and stderr and return when completed.
An example
java -jar monsterDB.jar -d newdb -r "db.fuzzy2.count({})" Connected to localhost Database is switched to newdb {"Number":180000}
java -jar monsterDB.jar -h host -p port -u username -pw password -d aDatabase -c aCollection -f file -r recordType -o options
For more information follow the link below.
Once connected, simply type help or help db, help collection or help load, each command is documented on the website here.
monsterDB> help help db -Database help help load -Data Loading help help collection -Collection commands help listDatabaseNames -List Databases connect [host] [port] [username] [password] -Connect/Reconnect session use dbname -Connect to a DB drop dbname -Drop a DB create dbname -Create a new DB quit -Leave monsterDB> help load loadJDBC collectionName connectionString SQLStatement [RecordType] -Load a Collection from a JDBC Connection loadFile collectionName filename/url RecordType {quote: "Quote Character to use", delimiter: "Delimiter ie ,|t :", fileType: "Type ie csv,xls,xml,zip", httpheader: "Authentication Header", httpusername: "HTTP Site Username", httppassword: "Sites Password", rootNode: "XML root node name", encoding: "Character Encoding of File", sheetno: Number of sheet (0 based), extractPattern: "Wildcard pattern to extract from a zip", ftpusername: "FTP Site username", ftppassword: "FTP Site password"} -Load a Collection from a file/url monsterDB> help db db listCollectionNames -List Collections for current DB db close -Close current DB db createCollection name -Create new collection in DB db createFuzzyCollection name definition.json ruleSetDir -Create a fuzzy collection DB, using a definition file and a directory containing ruleset map files db dropCollection name -Drop a collection db.collectionName.command() -Run a command against the collectionName in the current DB monsterDB> help collection db.collectionName.deleteMany({filter: "value"}) -Delete Documents matching filter document db.collectionName.find({filter: "value"}) -Find Documents matching filter document db.collectionName.insertOne({....}) -Create new Documents
© 2021 monsterDB. Built using WordPress and Mesmerize Theme.