Call $entityManager->persist() and pass the object to save. And then $entityManager->flush(). use Doctrine\ORM\EntityManagerInterface; class QuestionController extends AbstractController { public function new(EntityManagerInterface $entityManager) { $entityManager->persist($question); $entityManager->flush(); } } Yes, you need both lines. The persist() call simply says: Hey Doctrine! Please be “aware” of this Question object. The persist line does not make any queries. The INSERT query happens when we call flush(). The flush() method says: Yo Doctrine! Please look at all of the objects that you are “aware” of and make …
Dealing with giant tables in Postgres using Partitioning
Operation towards very large tables takes too much time in database. To overcome this problem, Postgres introduced partitioning using pg_partman extension. Steps to implement 1. Install extensionCREATE EXTENSION pg_partman; 2. Create tableCREATE TABLE events; 3. Create parent index tableSELECT create_parent(‘public.events’, ‘created_at’, ‘time’, ‘daily’); 4. Run partitioningSELECT run_maintenance(); Reference https://blog.heroku.com/handling-very-large-tables-in-postgres-using-partitioning
Hasura
The Hasura GraphQL engine makes your data instantly accessible over a real-time GraphQL API, so you can build and ship modern apps and APIs faster. Hasura connects to your databases, REST servers, GraphQL servers, and third party APIs to provide a unified realtime GraphQL API across all your data sources. Introduction To use the Hasura …
TypeORM
TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7, ES8). Its goal is to always support the latest JavaScript features and provide additional features that help you to develop any kind of application that uses …
Migrate Mongo
migrate-mongo is a database migration tool for MongoDB running in Node.js https://github.com/seppevs/migrate-mongo
Unexpected behavior of PostgreSql
When you sort data in PostgreSql, using `order by` clause, its behavior is special. When there are null values in the column data, `order by column DESC` puts null values first. For example, there are only 4 rows with values ‘1’, ‘2’, ‘3’, null for column ‘A’, if developer uses `order by A DESC`, row …
Localstack – AWS cloud services in local env, faster development
Developing AWS cloud based applications, like serverless based apps normally require too much effort on non-development related things. LocalStack provides an easy-to-use test/mocking framework for developing Cloud applications. LocalStack builds on existing best-of-breed mocking/testing tools, notably kinesalite/dynalite and moto, ElasticMQ, and others. While these tools are awesome (!), they lack functionality for certain use cases. LocalStack combines the tools, makes them …
Tokenex – Secure Any Sensitive Data as Token
Tokenization is the process of turning sensitive data into nonsensitive data called “tokens” that can be used in a database or internal system without bringing it into scope. Tokenex is a enterprise grade service to tokenize any data including credit card numbers, identification numbers of customers.
OData – power your RESTful API resources manipulation
In computing, Open Data Protocol is an open protocol which allows the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way. Microsoft initiated OData in 2007. Shortly said, OData is similar to GraphQL, has more history and being used by large companies, when GraphQL is new and used by …
Hackolade
Hackolade is pioneering the field of data modeling for NoSQL and multi-model databases with its unique ability to represent deeply nested JSON objects in Entity Relationship diagrams. A well-designed, dynamic database schema is like a solid foundation for a house: if you want an application that will scale, perform well, and be able to support …