In this section you will find useful information regarding programming with Vtiger CRM, Laravel and Wordpress.
Showed blogs by tag: SQL
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!
Choosing a database management system (DBMS) is one of the key decisions when developing applications. PostgreSQL and MySQL are two of the most popular open-source relational DBMSs, each with its own architectural features, strengths, and weaknesses. Let’s take a closer look at their main differences.
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 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.
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
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.
My most popular posts
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.
I have been working at a remote place for a long time - about 10 years. During this period, I implemented about 7 projects and provided dozens of consultations.
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.
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.
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
I will make time for your project. Knowledge of Vtiger CRM, SuiteCRM, Laravel, Vue.js, Wordpress. 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
