Please add support for MongoDB

[garawaa]

Please add support for MongoDB

[gerdwagner]

SQuirreL is a client for SQL databases. MongoDB is not an SQL database. As far as I see there are two approaches:

1. To write a Plugin for SQuirreL that allows to view and modify MongoDB-Data.
2. To find a JDBC driver for MongoDB that translates MongoDBs data structures to those of SQL databases. There exist several approaches of this kind. Three examples are:
   • https://github.com/mongodb/mongo-jdbc-driver which works for MongoDB Atlas only. Note: According to my tests this driver requires the database to be specified in the driver properties instead of the JDBC-URL, see attached screenshot.
   • https://github.com/wise-coders/mongodb-jdbc-driver which in my tests allows SQuirreL to connect to an MongoDB instance but which turns out to work on MongoDB Atlas only, too, see https://dbschema.com/jdbc-driver/MongoDb.html
   • Already some time ago the driver https://unityjdbc.com/mongojdbc/mongo_jdbc.php was discussed at our Sourceforge site, see https://sourceforge.net/p/squirrel-sql/feature-requests/499/

In case you'd want to write a MongoDB Plugin for SQuirreL I'd much appreciate it and would be looking forward to your patches. In case you find a MongoDB JDBC driver that works well for you please let me know and I'll add it to SQuirreL's drivers definitions.