From 0 to 1! Dynamic and static agent

trace back to To learn a technology, we need to know why it comes into being, so that we can have the goal and motivation to learn and understand it better First of all, why should there be an agent? There is A common requirement: how to add and enhance some functions when calling methods of class A without modifying class A code? Without co ...

Posted on Thu, 21 May 2020 11:59:19 -0400 by Dollar

xorm operation PostgreSQL database (add, delete, modify and query instances)

1, Introduction to xorm Xorm is a simple and powerful ORM Library of Go language. It can make database operation very simple. The goal of xorm is not to let you not learn SQL at all. We don't think SQL will be replaced by ORM, but ORM will solve most of the simple SQL requirements. Xorm supports a mix of two styles. characteristic Support ...

Posted on Wed, 20 May 2020 12:10:59 -0400 by phpfreak

MySQL + +: Liunx - MySQL master-slave replication

Objective: build two MySQL servers, one as the master server and one as the slave server to realize master-slave replication Environment: virtual machines Main database: 192.168.211.101 From database: 192.168.211.102 For MySQL installation, please refer to: go for a walk 1) : main library configuration steps 1. Configure master database: ...

Posted on Wed, 20 May 2020 01:01:25 -0400 by void_function

Let's talk about this open source project, how to make GitHub popular step by step!

At the beginning of 2010, influenced by foreign saas suppliers such as salesforce and zoho, more and more enterprises began to invest in CRM research and development. In order to find its own brand direction, Wukong team took openerp (odoo) as the benchmark, began to explore on the road of open source, and invested in it for nearly ten years. F ...

Posted on Tue, 19 May 2020 05:37:34 -0400 by JNettles

SQL Server 2008 delete large amount of data

1, Write it in the front. - it's not easy to say love you In order to upgrade the database to SQL Server 2008 R2, an existing PC was used for testing. The database was restored from the official database (the size of three databases is exaggerated to 100G +), and the machine memory is only 4G, so it not only has to assume the role of DB Se ...

Posted on Tue, 19 May 2020 03:59:16 -0400 by [L3]sPARTAN

Oracle RAC 12.2.0.1 Patch 30920127(Apr 2020)

Oracle RAC 12.2.0.1 Patch 30920127(Apr 2020) Environment introduction: Oracle RAC version: 12.2.0.1 (two nodes) Operating system version: CentOS 7.4 64bit 1, Patch environment preparation 1.1 upload installation package p6880880_122010_Linux-x86-64 p30920127_122010_Linux-x86-64 1.2 ensure the ipatch utility version Patch 30920127 requires ...

Posted on Mon, 18 May 2020 12:04:03 -0400 by zrocker

[Oracle] about database character coding modification

String encoding is not uniform, which will lead to import exceptions, display garbled code and other problems. Here is the solution 1. Query oracle server character code select userenv('language') from dual ; select * from V$NLS_PARAMETERS; select * from sys.nls_database_parameters; 2. Query oracle client character encoding select * from sys ...

Posted on Mon, 18 May 2020 10:54:23 -0400 by curb

Search interface optimization scheme -- basic use of elastic search distributed search engine

preface: In general, there is a search function in development projects. If it is a search function for the C end, it often tests the performance. For example, the commodity search in the general mall system or the website search of some resources. Perhaps the previous approach is to do a fuzzy query by name or product description on the prod ...

Posted on Sun, 17 May 2020 02:26:17 -0400 by Dasndan

Failure handling of Oracle database startup report ORA-00600 [kkdlcob-objn-exists]

*Author's introduction*****Original Creator: Lose SeriouslyContact number: 18081072613WeChat, QQ:18081072613Reprint to indicate origin 1. Failure PhenomenaToday, a customer's database started with an ORA-00600 [kkdlcob-objn-exists], [37] error, the database could not be opened, along with a good ORA-00704, requesting emergency rescue.Error st ...

Posted on Sat, 16 May 2020 15:17:23 -0400 by abbe-rocks

MySQL query duplicate data

Suppose there is a user table, user. The data is as follows: 1. Duplicate uid data in query table SELECT id, uid, name FROM USER WHERE uid IN (SELECT uid FROM USER GROUP BY uid HAVING COUNT(uid) > 1); 2. Duplicate data in the query table, excluding the minimum id SELECT id, uid, name FROM user WHERE uid IN (SELECT ...

Posted on Sat, 16 May 2020 11:25:22 -0400 by dyconsulting