[{"_1":2,"_153":-5,"_154":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_132":133},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_125":-5,"_126":11,"_127":17,"_128":11,"_129":-5,"_130":131},"canonicalUrl","https://hub.docker.com/r/fcoury/oxide/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","fcoury","reponame","oxide","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2022-07-28T03:37:14.593372Z","description","OxideDB is a tool that teaches your PostgreSQL database how to speak MongoDB Wire Protocol","is_private","last_updated","2022-09-24T18:23:24.524032Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",1551,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","![banner-small](https://user-images.githubusercontent.com/1371/184679510-4f455245-8580-4b00-809b-19f865dd0931.png)\n\n

\n \n \n \n \n

\n\n

\n “If it looks like MongoDB, swims like MongoDB, and quacks like MongoDB, then it probably is PostgreSQL.” :upside_down_face:\n

\n\n

\n Discord | Online Demo | Intro Video | Quickstart\n

\n\n# OxideDB\n\nOxideDB is a translation layer that works as a MongoDB database server while using PostgreSQL's JSON capabilities as the underlying data store.\n\n## Audience\n\nThis project might be something that you could be interested on if:\n\n- You spend too much time managing; or too much money paying for a MongoDB instance, while only using it as a simple\ndocument store, without any sharding features\n- You already have a running PostgreSQL deployment, or prefer to manage it over MongoDB\n\nOn the other hand, if your use-case leverages MongoDB as a distributed database, then unfortunately this project might\nnot be for you. At least right now supporting multi-sharding and scale-out deployments is not part of the roadmap.\n\n## Current status\n\nThe project was heavily inspired by [FerretDB](https://ferretdb.io) and is on its early days. The main difference is that\nthere is no intention to support any database other than PostgreSQL (FerretDB is also supporting Tigris) and it's written\nin Rust, as opposed to Go.\n\nIn order to translate the MongoDB Query language - which is based on JSON - to SQL I have ported [the mongodb-language-model library](https://github.com/mongodb-js/mongodb-language-model) that was originally written in Node.js and PEG.js to Rust and [pest.rs](https://pest.rs/). It was an excellent opportunity to learn how parsers work in a bit more depth.\n\nYou can check it out here: [mongodb-language-model-rust](https://github.com/fcoury/mongodb-language-model-rust).\n\nAt this moment, it's being developed as a personal project, but contributors are highly welcomed. If that something you'd\nbe interested on, be more than welcome to contact me.\n\n## Online demo\n\nThere's an online [demo of the Web Interface live hosted at Railway.app](https://demo.oxidedb.com/).\n\n## Quickstart\n\nDownload the [latest binary](https://github.com/fcoury/oxide/releases/latest) and run it. You will need to point it to a running PostgreSQL for Oxide to use as its backend.\n\n```\n> $ ./oxide --postgres-url \"postgres://postgres:postgres@localhost:5432/test\"\n[2022-07-13T02:57:46Z INFO oxide::server] Connecting to postgres://*****:*****@localhost:5432/test...\n[2022-07-13T02:57:46Z INFO oxide::server] OxideDB listening on 127.0.0.1:27017...\n```\n\nAnd with the database configuration set, you can use any [MongoDB](https://www.mongodb.com) client to connect to OxideDB, like [mongosh](https://www.mongodb.com/docs/mongodb-shell/):\n\n```\n> $ mongosh\nCurrent Mongosh Log ID:\t62ce3531d10f489bc82520c4\nConnecting to:\t\tmongodb://127.0.0.1:27017/?directConnection=true&serverSelectionTimeoutMS=2000&appName=mongosh+1.5.0\nUsing MongoDB:\t\t3.6.23\nUsing Mongosh:\t\t1.5.0\n\nFor mongosh info see: https://docs.mongodb.com/mongodb-shell/\n\n------\n The server generated these startup warnings when booting\n 2022-07-12T18:56:41.654-0300:\n 2022-07-12T18:56:41.654-0300: ** WARNING: Access control is not enabled for the database.\n 2022-07-12T18:56:41.654-0300: ** Read and write access to data and configuration is unrestricted.\n 2022-07-12T18:56:41.654-0300:\n------\n\ntest> db.col.insertMany([{ name: \"Felipe\" }, { name: \"Fernanda\" }]);\n{\n acknowledged: true,\n insertedIds: {\n '0': ObjectId(\"62ce3536d10f489bc82520c5\"),\n '1': ObjectId(\"62ce3536d10f489bc82520c6\")\n }\n}\ntest> db.col.find({ \"name\": \"Fernanda\" })\n[ { _id: ObjectId(\"62ce3536d10f489bc82520c6\"), name: 'Fernanda' } ]\n```\n\n## Quick intro\n\n[![Intro to OxideDB](docs/assets/video.png)](https://youtu.be/8TkcGV0TkgM)\n\n## Web interface\n\n![Web UI](docs/assets/screenshot.png)\n\nIf you want to perform quick queries on your database, you can use the built in web interface, just start oxide with the `--web` flag:\n\n```\n> $ ./oxide --postgres-url postgres://postgres:postgres@localhost:5432/oxide\n[2022-07-29T00:20:11Z INFO oxide::server] Connecting to postgres://*****:*****@localhost:5432/oxide...\n[2022-07-29T00:20:11Z INFO oxide::server] OxideDB listening on 0.0.0.0:27017...\n```\n\nNow just navigate to http://localhost:5432 and you'll be able to perform quick queries.\n\n## Running options\n\nYou can also set the `DATABASE_URL` environment variable or even use a `.env` file.\n\nBy default oxide will bind to 127.0.0.1 and port 27017. You can change those settings using the following parameters:\n\n```\n> $ ./oxide --help\noxide 0.1.6\nA database compatible with MongoDB Wire Protocol that uses PostgreSQL for backend storage.\n\nUSAGE:\n oxide [OPTIONS]\n oxide \n\nOPTIONS:\n -d, --debug Show debugging information\n -h, --help Print help information\n -l, --listen-addr Listening address, defaults to 127.0.0.1\n -p, --port Listening port, defaults to 27017\n -u, --postgres-url PostgreSQL connection URL\n -V, --version Print version information\n -w, --web Starts web interface\n --web-addr Web binding address\n\nSUBCOMMANDS:\n help Print this message or the help of the given subcommand(s)\n web Start OxideDB web interface\n```\n\n### Running with Docker\n\nAssuming you're running a local PostgreSQL instance, you can run OxideDB with Docker with the command below.\n\n```\ndocker build -t oxide .\ndocker run -d -p 27017:27017 -p 8087:8087 -e DATABASE_URL=postgres://postgres:postgres@host.docker.internal:5432/test --name oxide oxide\n```\n\n### Running from source\n\n```shell\ngit clone https://github.com/fcoury/oxide.git\ncd oxide\nexport DATABASE_URL=\"postgres://postgres:postgres@localhost:5432/test\"\nmake start\n```\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",142457269,"orgData","recentTags",[87],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",34489,"digest","sha256:ccce7035c65ab19dc3af97bcdf2db0b4a0406e98810937a5dc7b051d2a9803b3","full_size",58209736,"id",261777812,"images",[99],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},"architecture","amd64","features","","last_pulled","2026-09-18T01:30:24.538332316Z","last_pushed","2022-09-24T18:23:25Z","os","linux","os_features","os_version","size","variant","2022-09-24T18:23:24.391244Z","last_updater","last_updater_username","media_type","latest","repository",17697889,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":134,"_141":142,"_130":151,"_152":11},{"_36":135,"_38":136,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":137,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":138,"_75":11,"_76":140,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":139},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_143":60,"_144":-5,"_145":-5,"_146":147},"count","next","previous","results",[148],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":149,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[150],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

fcoury/oxide

Tags for fcoury/oxide