persist() and flush() – Symfony

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

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 …

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 …