PostgreSQL is one of the most popular databases around the world. A lot of companies have decided to build a business around that.
Running a database without a disaster recovery process can result in loss of business continuity, resulting in revenue loss and reputation loss for a modern business.
We just released FerretDB v1.19.0, which includes support for creating an index on nested fields in SQLite and some important bug fixes.
A database infrastructure setup will certainly impact the success of your business, or any business for that matter. You definitely don't want to wake up at 2 AM because your database went down, transactions stopped going through, and customers are angry.
We are starting the new year with a major feature addition! The latest version of FerretDB v1.18.0 has just been released with support for basic OpLog functionality, along with other exciting features.
OpLog (operations log) functionality has been one of our most requested features, and it would make it possible for developers to build real-time applications using the Meteor framework. We made this a priority in the last quarter and are super excited that it's now available. We can't wait to see what you build with FerretDB!
In addition to OpLog functionality, we've also added support for capped collections and tailable cursors.
FerretDB is on a mission to add MongoDB compatibility to other database backends, including Postgres and SQLite. All the new features in this release will help us improve compatibility with more applications，and use cases.
In this release, we've added support for capped collection, along with max and size parameters.
For example, to create a capped collection testcollection with a maximum size of 512MB, run:
db.createCollection('testcollection', { capped: true, size: 536870912 })
This release also includes support for tailable cursors; both tailable and awaitData parameters are included.
Most importantly, we released support for a basic OpLog functionality. We've had many requests for this feature especially for Meteor OpLog tailing and we're thrilled to have it finally available for our users.
At the moment, only basic OpLog tailing is supported. Replication is not supported yet.
The functionality is not available by default.
To enable it, manually create a capped collection named oplog.rs in the local database.
// use local
db.createCollection('oplog.rs', { capped: true, size: 536870912 })
You may also need to set the replica set name using --repl-set-name flag / FERRETDB_REPL_SET_NAME environment variable:
docker run -e FERRETDB_REPL_SET_NAME=rs0 ...
To query the OpLog:
db.oplog.rs.find()
To query OpLog for all the operations in a particular namespace (test.foo), run:
db.oplog.rs.find({ ns: 'test.foo' })
If something does not work correctly or you have any question on the OpLog functionality, please inform us here.
None of this would be possible without all the support we've received in the past year from our growing community and the open source community at large. In this release, we had two new contributors: @yonarw and @sachinpuranik. Thank you for your support!
Last year was an amazing one for everyone at FerretDB, and we can't wait to see what the new year unfolds. We will continue on our goal to provide an open source MongoDB alternative that enables more database backends run MongoDB workloads. Work is still ongoing on adding support for MySQL and SAP Hana backends, and we hope to have more information for you soon.
If you have questions or feedback on FerretDB, contact us on our community channels.
We just released FerretDB v1.17.0, which now makes it possible to build FerretDB without PostgreSQL or SQLite backend, among other new features.
FerretDB is an open source document database that adds MongoDB compatibility to other database backends, such as Postgres and SQLite. By using FerretDB, developers can access familiar MongoDB features and tools using the same syntax and commands for many of their use cases.