Medoo is extremely lightweight with only one file, easy-to-use, easy-to-learn, and optimized for high performance to increase the development experience and user experience for web application. It`s suitable for every PHP development project with SQL database needed.
Render a graphical representation of a MySQL or SQLite database from a mysqldump or sqlite3 .dump file.
This is a PHP, PDO and SQLite3 example, which demonstrates the SQLite3 databse usage with PHP-PDO. The PHP / PDO / SQLite3 example code demonstrates following things, and their us
One of the easiest ways to improve your application’s performance is by putting a caching solution in front of your database. In this tutorial, I’ll show you how to use Memcached with Rails, Django, or Drupal.
Memcached is an excellent choice for this problem, given its solid history, simple installation, and active community. It is used by companies big and small, and includes giants, such as Facebook, YouTube, and Twitter. The Memcached site, itself, does a good job of describing Memcached as a “Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.”
J’ai récemment du faire une comparaison des données entre deux versions de la base MySQL de mon blog. En cherchant comment procéder le plus facilement possible, je suis tombé sur le le freeware Toad for MySQL : Toad est édité par Quest et l’acromyme signifie Tool for Oracle Application Developers. La version Toad for MySQL propose les mêmes fonctionnalités, mais pour la base de données opensource MySQL.
DbNinja is an advanced web-based application for MySQL database administration and development. It's a must-have for those who wish to access their hosted servers remotely.
A document-oriented database is a designed for storing, retrieving, and managing document-oriented, or semi structured data. Document-oriented databases are one of the main categories of NoSQL databases. The central concept of a document-oriented database is the notion of a Document. While each document-oriented database implementation differs on the details of this definition, in general, they all assume documents encapsulate and encode data (or information) in some standard format(s) (or encoding(s)). Encodings in use include XML, YAML, JSON and BSON, as well as binary forms like PDF and Microsoft Office documents (MS Word, Excel, and so on).
For the past 40-some years, relational databases have ruled the data world. Relational models first appeared in the early 1970s thanks to the research of computer science pioneers such as E.F. Codd. Early versions of SQL-like languages were also developed in the early 70s, with modern SQL appearing in the late 1970s, and becoming popular by the mid-1980s.
I’d like to kick off this post with a thanks to the folks behind the PHP extension for MongoDB, who have done a fantastic job of matching the functionality of the Mongo shell client. This is important when you start to see how similarly the two function, and you might find that you can tweak your logic using the shell and quickly implement the same logic from within PHP.
A couple weeks ago I released mongly.com. The feedback has been great, but I've noticed that a lot of people still have some fundamental questions about MongoDB. Questions like, where does it fit and how do you model your data? I initially thought about writing a couple blog posts, but I felt that a short ebook might be a better format.
Vous n’avez jamais utilisé MySQL auparavant ? Commencez ici ! Cet article va vous guider à travers les principes mêmes des bases de données MySQL et SQL. Apprenez à installer MySQL, comment effectuer des transactions, et comment créer et utiliser des bases de données. Vous n’avez jamais utilisé MySQL auparavant ? Commencez ici ! Cet article va vous guider à travers les principes mêmes des bases de données MySQL et SQL. Apprenez à installer MySQL, comment effectuer des transactions, et comment créer et utiliser des bases de données.
Ready to get in and start learning about MongoDB, one of the coolest technologies for web developers?
In this new series, you’ll go from beginner to pro and be able to use Mongo just as easily as MySQL in your web apps. But first, let’s look at the basics.
We've covered PHP's PDO API a couple of times here on Nettuts+, but, generally, those articles focused more on the theory, and less on the application. This article will fix that!
To put it plainly, if you're still using PHP's old mysql API to connect to your databases, read on!
If you have played with the HTML5 version of the cut the rope, you will notice that it remembers your scores for each game when you return to the site. To achieve this in your own applications you can use localStorage which is part of the Web Storage Specification. Local Storage gives developers a way to to store data in the web browser, which will be available even if the browser is closed and returned to later.
The information stored in local storage is only visible to the domain that saved it, and so you can happily place information in the store knowing other, potentially malicious, websites will not be able to access it.
For any web application uploading an image is comman task. But what is the comman way to manage the uploaded files?
Generally what we do is place the uploaded file on specific folder and store the name of the image or some times path to image in VARCHAR field of the database table.
But this article is to cover the concept to store the image in mysql database. Later on we will discuss how to show the stored image from database to the web page.
This article is about to explain how you can manage database collation and character set of your database. If you are working on website which covers only one language which is english then you may not worry about these stuff.
But If you are dealing with the multilinguag website which includes various languages (chinese, hindi, gujarati, etc.) then you MUST need to take care of this stuff.
To make your database able to handle these characters of different languages you need to set proper Database Collation and Character Set for the database.
This resource starts with the basics of MongoDB and goes on to describe the query language, advanced clustering configurations, administration, and more. It also includes a thorough glossary and command reference.