We have all experienced the limitations of the relational model and the operational burden of running a large fleet of databases. At PlanetScale, our vision is to build a database developers love without compromising on any of the database features required to run an application that can scale up as needed. To achieve this, we knew we needed a database engine with a track record of powering companies that deal with humongous amounts of data and traffic. That’s why we chose Vitess.

Najmniejsza (minimalna data) w Oracle Czasami zdarza się, iż musimy porównać datę faktyczna do jakiejś mniej „rzeczywistej”, aby na przykład mięć pewność, że nasze zapytanie zwróci dane dla całego zakresu dat. Można tu skorzystać z minimalnej daty dostępnej w bazie Oracle którą jest 1 styczeń 4712 BC. Datę tą można odczytać w prosty sposób korzystając z funkcji TO_DATE.

Alternative #2: PDO – PHP Data Objects
The PDO extension supports twelve drivers, enabling it to connect to a variety of relational databases without the developer having to learn a number of different APIs. It does this by abstracting the database interaction calls behind a common interface, enabling the developer to utilize a consistent interface for different databases. This of course gives it a major advantage over both the MySQL and MySQLi extensions who are limited to only one database.

Last time I wrote about a few tips that can make you more efficient when using the command line on Unix. Today I want to focus more on pager.
The most common usage of pager is to set it to a Unix pager such as less. It can be very useful to view the result of a command spanning over many lines

MySQL Proxy transparently passes information between a client and a MySQL server. The proxy can audit the information flow in both directions and change it if necessary, which could be useful for protecting the MySQL server from malicious queries or for altering the information clients receive without actually making changes to the database. The proxy can also do load balancing between MySQL servers, and perform flow optimization by directing SELECT statements to read-only slave servers, which enhances MySQL scalability by allowing you to add more servers for read operations.

Jeżeli w swojej pracy bądź pasji tworząc nową aplikację trafiliście na konieczność współdziałania php z bazą mssql i do tego na serwerze opartym o debian/ubuntu na pewno trafiliście na problem braku sterownika do połączenia.

Aby móc połączyć naszą aplikację php z serwerem mssql konieczne będzie zainstalowanie i skonfigurowanie freetds.
Można zrobić to w kilku szybkich krokach – oto one:

Daniel Nichter przedstawił na łamach InfoWorldu listę 10 opensource'owych narzędzi dla administratorów baz danych MySQL, które powinny im znacznie ułatwić życie. Przytaczamy poniżej tę interesującą listę – wielu z tych programów wcześniej nie znaliśmy.

The pg2mysql converter is an online tool to convert/migrate existing PostgreSQL databases into MySQL. Simply dumping from Postgres and importing to MySQL does not work because of differences in syntax and data types. To use this converter, just create a postgres SQL dump (pg_dump -U username -s dbname > dbname.sql), and copy and paste it into the text area below. Click the Convert to MySQL button and the page will re-load with your new MySQL code that you can copy out of the textarea into a text editor to save and import into your MySQL database.

Ostatnio wiele mówi się o bazach danych NoSQL (NotOnlySQL). Jako, że nie zauważyłem nic w polskim światku PHP na ten temat, stwierdziłem, że pora wypełnić tę lukę i zagłębić się w temat.

We all know that working with phpMyAdmin can be tedious, because we are working on the browser and have to wait for every post back. Therefore, if we are working frequently with MySQL, we should have a desktop application as an alternative to working with phpMyAdmin. Whether you are developing a desktop software or a web based application, there is a pretty good chance you will consider MySQL for data storage. Due to its popularity and open source business model, numerous tools and utilities are available that will help you easily design and manage your MySQL databases. We at Admix Web have put together a list of really useful free tools and utilities for MySQL that can help you improve your productivity in the design and development world. I hope you find them useful!