SQL Developer is a GUI tool for working with Oracle Database. It’s available on many major operating systems, including Window, Linux, and of course, MacOS.
Here’s a quick rundown on the steps I took to install SQL Developer on a Mac.
Continue readingSQLcl is a command line tool for working with Oracle Database. It’s available on many major operating systems, including MacOS.
Here’s a quick rundown on the steps I used to install SQLcl on a Mac.
Continue readingIf you just installed SQL Developer on a Mac, but you’re getting an error when trying to launch it, try the steps below to fix it.
The error reads “The application “SQLDeveloper.app” can’t be opened because Apple cannot check it for malicious software“. It also mentions that “This software needs to be updated. Contact the developer for more information“.
Below are the steps I used to overcome this issue, and launch SQL Developer.
Continue readingIf you connect to MariaDB using the command line interface, you might sometimes find that your query results are too wide, due to the number of columns being returned, and the data they contain.
Continue readingAs of mongoimport version 100.0.0, you can delete documents in MongoDB based on an imported file. To do this, use delete mode.
When you use delete mode, if an imported document has the same _id value as an existing one in the collection that you’re importing into, the existing document will be deleted.
You can also specify another field or fields (other than the _id field) to be the matching field if required.
When using mongoimport, you can use the --jsonArray parameter to import an array of JSON documents.
When you use mongoexport to export documents in MongoDB, you have the option of “prettifying” them.
By this I mean, instead of the document being presented on one long line, it instead includes line breaks, indents, etc to make it easier to read.
To do this in mongoexport, use the --pretty parameter.
Here’s how to find out what version of psql you’re using.
Continue readingpsql is a terminal based interface for PostgreSQL.
psql enables you to administer PostgreSQL from the command line interface (CLI) as an alternative to using a graphical user interface (GUI), such as pgAdmin, Postico, Azure Data Studio, etc.
Continue readingMongoDB’s import utility – mongoimport – introduced a new parameter that allows you to import CSV data as an array.
The --useArrayIndexFields parameter interprets natural numbers in fields as array indexes when importing CSV or TSV files.