We invite you to Voronezh Game Dev Meetup

We invite you to Voronezh Game Dev Meetup October 17 in the Voronezh office Mail.Ru Group will be held a game development mitap. The developers of Mail.Ru Group will tell you about the interesting methods and tools they have worked with, and you will have time to discuss all the presentations and share experiences.
 
 
Participation is free, registration is required.
 
 

Program of the meeting


 
"The experience of migrating highly loaded game projects from MySQL to PostgreSQL"
 
Mark Lokshin, programmer Mail.Ru Group
 
 
Mark will talk about his experience ...[/h]
+ 0 -

Acquaintance with SOCI - C ++ library of access to databases

Introduction
 
The library itself is still mature, - the first release on the githaba
 
dates back to 2004. I was surprised when Habr was searching for
 
He did not give me a single reference to articles in which
was mentioned.  
about this wonderful library.
 
SOCI
supports ORM , through the specialization type_conversion.
 
In
SOCI
there are backends for:
 
 
Firebird
 
MySQL
 
Oracle
 
PostgreSQL
 
SQLite
 
 
I will not translate the manuals or give here the code from the examples,
 
but I'll try to adapt (with a change in the structure of the table, and other simplifications)
 
code from ...
+ 0 -

The eternal theme with PHP and MySQL

Hello! Surely everyone who writes a lot and constantly writes on PHP faced with the issue of optimizing and simplifying queries in databases MySQL . Someone wrote already convenient classes /procedures for themselves, someone found something on the expanses of the network.
 
 
Because I have scripts on PHP more and more they start to minimize to one task - a sample from the database and transfer of this data to client Java scripts, I made it easier for myself by creating a convenient (for me, of course) class on working with databases MySQL .
 
 
Immediately make ...
+ 0 -

Development of databases in Dropbox. The path from one global MySQL database to thousands of servers &lt;{short}&gt; &lt;{full}&gt; <div class="post__text post__text-html js-mediator-article"> When only Dropbox started, one user on Hacker News commented

Development of databases in Dropbox. The path from one global MySQL database to thousands of servers    When only Dropbox started, one user on Hacker News commented that it can be implemented by several bash-scripts using FTP and Git. Now this can not be said at all, it is a large cloud file storage with billions of new files every day, which are not just stored somehow in the database, but so that any database can be restored to any point within the last six days.    
    
 Under the cut the transcript of the report  The glory of Bakhmutov  (    When only Dropbox started, one user on Hacker News commented that it can be implemented by several bash-scripts using FTP and Git. Now this can not be said at all, it is a large cloud file storage with billions of new files every day, which are not just stored somehow in the database, but so that any database can be restored to any point within the last six days.    
    
 Under the cut the transcript of the report  The glory of Bakhmutov  (<{full}>
When only Dropbox started, one user on Hacker News commented that it can be implemented by several bash-scripts using FTP and Git. Now this can not be said at all, it is a large cloud file storage with billions of new files every day, which are not just stored somehow in the database, but so that any database can be restored to any point within the last six days.
 
 
Under the cut the transcript of the report
The glory of Bakhmutov
( <{short}>When only Dropbox started, one user on Hacker News commented that it can be implemented by several bash-scripts using FTP and Git. Now this can not be said at all, it is a large cloud file storage with billions of new files every day, which are not just stored somehow in the database, but so that any database can be restored to any point within the last six days.  Under the cut the transcript of the reportThe glory of Bakhmutov( When only Dropbox started, one user on Hacker News commented that it can be implemented by several bash-scripts using FTP and Git. Now this can not be said at all, it ...
+ 0 -

ThinkingHome.Migrator - version migration of the database schema on the. NET Core

ThinkingHome.Migrator - version migration of the database schema on the. NET Coreplatform.Hello! Today I released a new version of ThinkingHome.Migrator - a tool for the versioned migration of the database schema to the .NET Core platform.  Packages are published in NuGet , written detailed documentation . You can already use a new migrator, and I'll tell you how it came about, why it has version number ??? (although this is the first release) and why it is needed when there is EF Migrations and FluentMigrator . Migrator.NET . The migrant proposed a new idea for that time - to set changes to the database as migrations. Each migration contains a small ...
+ 0 -

How to prepare mysql binlog from go

How to prepare mysql binlog from go  
 
My name is Artem, I work for Rambler Group in the Potok project as a Go lead developer.
 
We spent a lot of time taming mysql binlog. In this article, a story about how quickly and with a minimum of pitfalls to implement the mechanism of working with the bin on Go.
 
here or here .
 
 
The article has two parts:
 
 
1. How to quickly start the processing of records that come to the log.
 
2. How to tune and expand what's under the hood.
 
 


Part 1. We start as soon as possible.


 
To work with binlog we will use the library github.com/siddontang/go-mysql ...[/h]
+ 0 -

How to copy data sources to the IDE on the IntelliJ

How to copy data sources to the IDE on the IntelliJplatform.Hello! In this tutorial, consider a few popular scenarios.  - Copying the data source within a single project. - A common data source for different projects within the same IDE. - Copy the data source to another IDE, to another computer, to another galaxy.  export settings . But you do not always want to transfer all the settings, and the data sources - global ones, too, are not always :)  So it will be useful to know that the data source can be copied: on the shortcut menu, selectDatabase tools → Copy data source to clipboard. This will work with several at once.    The clipboard gets the ...
+ 0 -

DevConf 2018 already on Friday, May 18

This Friday, May 1? will be a professional web developer conference DevConf 2018. We invite you to participate. Very briefly about the program:
 
 
DevConf :: BackEnd : Aggregate thinking, rewriting the project from Drupal 8 to Yii ? Yii 2.? PHP and frameworks, Service Oriented Architecture, sending notifications, sample profiling, open tracing, Business Intelligence.
 
 
DevConf :: FrontEnd : HOC in React, WebRTC: video calls from the browser, Headless Chrome, architecture of the big legacy of the project, JSON API, Framework for individual design, Test it, Node.js and ...
+ 0 -

Go: speed up the selection of large tables from MySQL

I've been using Go to write an ad network for almost a year now. The development I lead on the server Intel i7-770? 16Gb RAM, 256Gb SSD. And in the script that runs once a day, the task appeared to select all the impressions for the past day and to count on this basis statistics for the day at once on several objects (site, campaign, banner).
 
 
According to Go's idioms everything is quite trivial:
 
RawBytes which ensures that the bytes from the database driver will be transferred to the user without copying. What. We will try to extract Scan into the intermediate structure with the sql.RawBytes ...
+ 0 -

DevConf: promising databases for highload

DevConf 2018 already next week! Last year Yury Nasretdinov conducted an interesting survey of promising data storage systems for highload. Video with the report is available at page of the report . And for habra-readers I offer a brief retelling.
 
 
DevConf: promising databases for highload In the beginning I'll tell you how to approach the choice of technology for a highload project.
 
 
 
First of all, there must be an understanding of how it works. Not only strong, but also weak points.
 
Knowing how to monitor and backup. Without good tools for this, this technology is early to use in production.
 
Sooner or later the systems ...
+ 0 -