Utilitaires
Scripts
Divers
Jeux
Rechercher
Quillevere.net
Computer science thoughts

Databases

Auto-assign the last modification time of a row (PostgreSQL/MySQL)

PostgreSQL

Depending on the DBMS, the way to automatically assign the date and time on the modified lines differs.

Compile pgModeler on Windows

PostgreSQL

pgModeler is an Open Source software allowing to model a database, that is to say to schematize everything related to the construction of a base (tables, fields, relations, constraints ...) and oriented towards the...

Obtain SQL Server port

SQL Server

To obtain the TCP / IP port of a SQL Server database, several solutions are possible. Via a request on the server. Using the following query: SELECT DISTINCT local_tcp_port FROM sys.dm_exec_connections WHERE...

Avoid too large MySQL logs

MySQL

You can quickly have your hard drive flooded with files mysql-bin.xxxxxx (mysql-bin.000001...). These files are MySQL logs which trace all the modifications to the database.It is best to disable them by modifying...

Search in this website

fr en rss RSS info Informations