CategorySQL

December 18, 2017 — Most potential users will want to try out the software or service before committing any time and money. Often this is where the age-old demo account comes into play. However, anyone who has ever implemented a demo account can attest to the problems associated. In this article, James Pierce brings you a solution: SQLite. It’s commonly known that SQLite does not handle multiple threads since the entire database is locked during a write command, which is one of the reasons why you should not use it in a normal production environment. However, in his solution, a separate SQLite file is used for each user demoing the software. Read more…

September 28, 2011 — Ryan Olson gives some insight into setting up a local environment to work with WordPress: install MAMP, and configure, and install a WordPress platform to develop in, saving the need for purely online development tactics. Read more…

September 21, 2011 — In this article, Daniel Pataki will explain how to get started with the $wpdb class, how to retrieve data from your WordPress database and how to run more advanced queries which are tailored to your particular needs, in order to update or delete something in the database, and generally make your website more efficient. Read more…

December 21, 2010 — Building a beautiful design is a great experience. Seeing the design break apart when people start putting in real content, though, is painful. That’s why testing it as soon as possible with real information to see how it fares is so important. To this end, Web services provide us with a lot of information with which to fill our products. In recent years, this has been a specialist’s job, but the sheer amount of information available and the number of systems to consume it makes it easier and easier to use Web services, even for people with not much development experience. The problem with APIs is that access to them varies in simplicity, from just having to load data from a URL all the way up to having to authenticate with the server and give all kinds of information about the application you want to build before getting your first chunk of information. Read more…

March 25, 2009 — The most popular and best open source database is MySQL. Simple as that. It is consistently fast , reliabile and very, very easy to use. One of MySQLs main features is its cross-platform support, it will run on almost all operating systems, including Windows, OSX, Linux and many more. So, MySQL is the best database, and we all use it. The question now is which is the best MySQL Admin and Development Tool. Read more…