Welcome to the blog section of PHP programmist Sergey Emelyanov

In this section you will find useful information regarding programming with Vtiger CRM and Laravel.

Showed blogs by tag: SQL

Blog of private php programmist Sergey Emelyanov

I like to write how I solved certain difficulties and share interesting features with the developer community. Here you will find solutions to various tasks in Vtiger CRM and Laravel. If you have any questions - ask!

Create custom data types in PostgreSql
SQL

Create custom data types in PostgreSql

PostgreSQL supports various types of data that are stored in the database and processed using SQL. Different data types are used in a wide variety of situations: for optimal use of data types when describing table attributes, for processing data using standard functions, for creating logical constraints in accordance with the business logic of the project.

Optimizing PostgreSQL Database Performance
SQL

Optimizing PostgreSQL Database Performance

In practice, any developer or system administrator encounters a terrible problem - the database slows down. The server is running slowly, something strange is happening, users are complaining, the client is angry. It was not for nothing that I wrote that the problem is terrible, first of all because the solution here will not be obvious and it does not lie on the surface. Many parameters can affect database performance.

PostgreSQL - insert or update row
SQL

PostgreSQL - insert or update row

In this article, we will take a closer look at the data insertion process. Including how to avoid errors when inserting duplicate data. We will perform all operations on the PostgreSQL test database, you can download a dump of this database at the link

PostgreSQL - cheatsheat for most popular commands
SQL

PostgreSQL - cheatsheat for most popular commands

Recently, more and more people have to deal with PostgreSQL in their work. And comparing this database with others, you come to the conclusion that the syntax of SQL is slightly different from the generally accepted standards. Faced with such a problem, I decided to write a mini-cheat sheet for the most common commands that any developer will need.

Popular Posts

My most popular posts

Maximum productivity on remote job
Business

Maximum productivity on remote job

I started my own business and intentionally did my best to work from anywhere in the world. Sometimes I sit with my office with a large 27-inch monitor in my apartment in Cheboksary. Sometimes I’m in the office or in some cafe in another city.

Hello! I am Sergey Emelyanov and I am hardworker
Business PHP

Hello! I am Sergey Emelyanov and I am hardworker

I am a programmer. I am an entrepreneur in my heart. I started making money from the age of 11, in the harsh 90s, handing over glassware to a local store and exchanging it for sweets. I earned so much that was enough for various snacks.

How to set higher priority for Yes
Business

How to set higher priority for Yes

I see how many bloggers write about how important it is to say "No" and then often see comments such as "Excellent", "It is very important to set priorities correctly." An interesting point for me is that when someone writes that he learns to say no, this means that he already knows how to say yes.

Latest News

Developed an interesting application for learning foreign words using flashcards. You can download it for free, deploy it on your server and use it. Made with Laravel + Vue.js. Create your own vocabulary list or import list of popular words. Learn words anytime, anywhere. You can watch a video by clicking on image

Hire Professional CRM developer for $25 per hour

I will make time for your project. Knowledge of Vtiger CRM, SuiteCRM, Laravel, and Vue.js. I offer cooperation options that will help you take advantage of external experience, optimize costs and reduce risks. Full transparency of all stages of work and accounting for time costs. Pay only development working hours after accepting the task. Accept PayPal and Payoneer payment systems. How to hire professional developer? Just fill in the form

I usually get a call back within a few hours. But if I have a heavy workload, I may call you back the next day. So please be patient. Or if you have an urgent question, you can call me directly. I will do my best to help you.

Or just call: +79876757777

Telegram: @sergeyem