-
-
11:31
»
Open Source Web Development Tutorials - RSS Feeds
When working with MySQL, there will probably come times when you need to grant privileges to certain user accounts. This task is executed using the appropriately named GRANT statement. In addition to the statement's ability to grant user privileges, the GRANT statement functions as a way to declare specific characteristics related to an account. Among these are any limits when it comes to accessing certain server resources, as well as the use of secure connections, just to name a couple. Before using the GRANT statement to assign privileges to user accounts, you should know that you will ne...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
The various topics we are covering in this tutorial are far from advanced. They are as basic as they come, but they are important if you are new to MySQL. With that being said, let us jump into the first part of the tutorial, which is how to create a new database in MySQL. How to Create a Database in MySQL It is rather obvious that if you are planning to work with databases in MySQL, that you must know how to create one first. This, of course, applies if you have no other pre-existing databases to work with and want to begin with a fresh slate. Luckily, creating a database in MySQL is quit...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
You do not have to be a genius to create a table in MySQL. In fact, it is a rather simple process. Once you have your database created, you have plan out and implement its structure. In other words, you must begin to answer some questions, such as what tables do you want your database to have? What information do you want those tables to store? What columns do you want each table to have? Answering these questions can get a little tricky, depending on the data you are working with. You want to be as descriptive as possible with your columns, but you do not want to overdo it. This tuto...
-
-
11:56
»
Open Source Web Development Tutorials - RSS Feeds
Before we jump into the specifics, we should look at why we should go over the topics of MySQL data and table types first. In terms of MySQL data types, knowing how to differentiate between them will help you implement them effectively into your future designs of database tables. As for MySQL table types, knowing how to manipulate all of their variations will come in handy when you want to get the most out of your application's performance. So, now that you have a bit of an introduction to the importance of MySQL data and table types, it is time to break down each topic even further. Let us...
-
-
22:09
»
Open Source Web Development Tutorials - RSS Feeds
Ideal for small and medium-sized businesses, but also valuable for larger organizations, the MySQL audit plugin allows users to collect comprehensive activity audits from their databases that offer in-depth detail and help to satisfy audit requirements. The way in which McAfee addresses database security allows the company to provide solutions to organizations that often face troubles when trying to properly secure their databases. McAfee's successful approach is demonstrated in the MySQL audit plugin's full set of features, which begins with total visibility into the status and vulnerabiliti...
-
-
10:12
»
Open Source Web Development Tutorials - RSS Feeds
Continuent CEO Robert Hodges commented on the new partnership with SkySQL in the official press release: We are very excited about the opportunity to work with SkySQL, another leader in the MySQL ecosystem. High availability and scaling with automatic resource allocation provide real benefits to database applications of all sizes, and Tungsten Enterprise provides industry leading solutions for database management, continuity and data backup and recovery. We closed our first joint customers in 2011 and look forward to working with SkySQL to solve important data management problems across a wi...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
Customers seeking flexibility get that and more with MySQL Cluster 7.2, as its new Memcached API offers both SQL and NoSQL access. This gives customers the best of both worlds, so to speak, allowing them to conveniently execute key value operations and complex queries all from the same database. Scalability has been enhanced in various ways, beginning with enhanced active/active replication that makes it easier for developers to detect and resolve conflicts across multiple clusters and eliminates the need for timestamp columns in applications. MySQL Cluster 7.2's multi-site clusters allo...
-
-
9:18
»
Open Source Web Development Tutorials - RSS Feeds
Forrester's report described why it chose Cloudera as the leader in the enterprise Hadoop market: Cloudera is a well-established startup among pure-play vendors in the emerging Hadoop solution market. Its core open source product, Cloudera's Distribution Including Apache Hadoop (CDH), has strong uptake among many early adopters and is popular with cloud/SaaS providers that have built Hadoop-based services. Cloudera has software, cloud/SaaS, and appliance offerings, and a substantial and growing professional services force focused on Hadoop training and consulting. While the free Cloudera Dis...
-
-
8:52
»
Open Source Web Development Tutorials - RSS Feeds
Xeround Releases Free Version of its Popular Cloud Database for MySQL Applications Xeround, a provider of database software for public and private clouds, recently announced the availability of Xeround FREE, a no-cost edition of its elastic and highly available cloud database solution for MySQL applications. With Xeround FREE, MySQL users can employ the cloud database solution's functionality with ease, as no installation, configuration, or maintenance of a MySQL database in the cloud is required. Regarded as the only true native cloud database, Xeround FREE was developed specifically to avo...
-
-
10:57
»
Open Source Web Development Tutorials - RSS Feeds
The Oracle PartnerNetwork Specialized program supplies partners with a host of resources to help develop, implement, and sell Oracle products. Over time, the program has been enhanced through the addition of Specializations that allow partners to differentiate themselves from competitors once they demonstrate an outstanding level of competency, expertise, and success. Tomas Ulin, Oracle's MySQL VP of engineering, commented on the new specialization: Oracle continues to innovate across the MySQL product family to address the evolving needs of both our end-user and partner community. MySQL co...
-
-
9:45
»
Open Source Web Development Tutorials - RSS Feeds
Specializing in online marketing through email, surveys, social media, and more, Constant Contact's customer base extends all over the globe. With so many customers depending on the company for their online marketing needs, Constant Contact was in need of the proper support to accompany its move towards open source with MySQL. SkySQL was eventually selected for a variety of reasons, and has helped Constant Contact with building and deploying a sturdy MySQL database architecture. In addition, SkySQL has aided Constant Contact with training 10 database administrators over the course of severa...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
Being by far the most popular open source RDBMS available to date, MySQL offers a wealth of engaging facilities that make it stand out from its closest competitors. A stable, reliable performance, solid support for ACID transactions and multiple storage engines, foreign keys handling and cascade operations are only a small part of the tremendous menu of features that the database server offers for free. These have, not surprisingly, contributed to extending its existing popularity even further over time. Among other features, MySQL includes a powerful privilege administration module. It lets y...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
Let's be honest: unless you're a multifaceted, good-at-everything web developer, with skills that go beyond the boundaries of (X)HTML, CSS, JavaScript and the server-side language of your choice, most of the time you'll be reluctant to deal with the oddities of MySQL. With lots of frameworks and libraries that will do the leg work for you and handle the interaction with the database server, you'd rarely need to spend your valuable time diving into its lower-level features. After all, that's what systems administrators are for, right? While the actual tasks you'll be performing with MySQL will ...
-
-
23:26
»
Open Source Web Development Tutorials - RSS Feeds
Cashton Coleman, SuccessBricks' President and CEO, as well as creator of ClearDB, said: We are pleased to now offer ClearDB as a powerful add-on for Heroku customers. It has been a pleasure to work with the Heroku team, and we're excited to bring our game-changing MySQL database service to Heroku customers. quot; The result of over four years of research and development by the SuccessBricks team, ClearDB allows its users to maintain a database connection in the event of sudden and widespread internet outages, which alone should attract many Heroku developers. SuccessBricks claims ClearDB is...
-
-
10:30
»
Open Source Web Development Tutorials - RSS Feeds
Let's face it: building a full-featured ORM in PHP (or in any other programming language) is a challenging and difficult process that requires careful planning. You'll need a solid background in some popular data persistence patterns, such as Active Record and Data Mapper. That's a tall order, especially since this kind of package must be able to handle all of the possible relationships between the objects that compose an application, not to mention the validation that must be performed on them. Fortunately, there's a healthy variety of ORMs available that will do the hard work for you. What's...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
As its name would suggest, TroSQL Free 1.10 helps to boost productivity for both small businesses and large organizations at no cost. It's also a useful tool understanding and learning how databases work. The release is just another in a line of products from TROSYS that gives clients the power to maximize efficiency in the realms of MySQL database and server management, product development, debugging, resource optimization, and more. Besides its distinction as a free tool, TroSQL is highlighted by a plethora of features, beginning with compatibility. The program ships as a small EXE that i...
-
-
9:33
»
Open Source Web Development Tutorials - RSS Feeds
What's more, if you've already read the first installment of this tutorial, you're probably familiar with the functionality that I plan to add to this custom ORM. In that first part, I implemented the ORM's data access and mapping layers. And as you'll surely recall, the entire implementation process was pretty straightforward and easy to follow. Of course, in its current state the ORM is still far from a fully-functional structure. We need to add some additional components to it, such as a domain model and the classes responsible for handling collections of entities (remember that the ORM rel...
-
-
23:20
»
Open Source Web Development Tutorials - RSS Feeds
There's no shortage of options when it comes to picking a PHP-based ORM. The current variety of options satisfies a broad number of tastes and palates, even the pickiest ones. Similar to some other utility packages available, the prolific nature of ORMs brings with it a healthy effect: whether you use a popular third-party MVC framework like CodeIgniter Reactor, CakePHP or Kohana (only to name a few) or employ your own MVC masterpiece, chances are that you can add the functionality of an ORM to your applications with only minor hassles. Don't let the large number of ORMs fool you, though; the ...
-
-
9:44
»
Open Source Web Development Tutorials - RSS Feeds
Jelastic's data is based on the four major open source databases it supports: MySQL, MariaDB, MongoDB, and PostgreSQL. Results taken for October 2011 show an open source database distribution that is led by MySQL with a 46 percent global market share. MongoDB comes in second with 21 percent, and PostgreSQL and MariaDB come in third and fourth place with 19 percent and 14 percent, respectively. The term global market share refers to the sum of the percentages found in North America and Europe, which are the only locations where Jelastic is available at this time. A closer look into the n...
-
-
12:30
»
Open Source Web Development Tutorials - RSS Feeds
Despite the status of the releases as DMRs, Ulin noted that their quality should not be questioned. He explained how Oracle's complete shift in its development philosophy has MySQL moving forward on a positive note into the future. A year ago we changed our development model. We decided to go to more incremental, quot; he said. quot;With each milestone, what we strive to do is bring in only a few features and make sure they're of highest quality. We could go out today and say, this is a release candidate or this is a GA [general release candidate], Ulin said. MySQL 5.6 is expected to rece...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
SQL injection attacks are nothing to sniff at, and Imperva reported that they have accounted for 83 percent of successful hacking-related data breaches since 2005. According to statistics from Privacyrights.org, such hacking resulted in serious losses during that time period. There were 312,437,487 data records lost due to hacking with about 262 million records from various breaches including TJMax, RockYou and Heartland, all of which were SQL injection attacks, noted Imperva's blog post. For its report, Imperva monitored a collection of 30 different web applications over the last nine mon...
-
-
7:00
»
Open Source Web Development Tutorials - RSS Feeds
The product is said to be the industry's only SQL server defragmentation solution that simplifies the process of pinpointing fragmentation of hotspots through automation. It gives users the power to defragment indexes automatically or when needed, thus helping to improve SQL Server's overall performance. Index fragmentation is one of the major causes of lethargic SQL Server performance. By keeping indexes defragmented, SQL defrag manager v3.0 keeps SQL Server applications running at optimal performance levels. This frees database administrators from having to waste precious time on manual d...
-
-
23:30
»
Open Source Web Development Tutorials - RSS Feeds
Not that I want to sound pessimistic, but using SQL without understanding the basics of joins is pretty much like trying to drive a car that has only three wheels - you're not getting the most out of the language! That being said,joins are fairly easy to master -at least at a basic level.To prove this,in the course of the introductory part of this series, I developed a few easily understandable examples, which showed how to perform FULL and INNER joins using a couple of sample MySQL tables. If you missed that article or need a refresher, you can find it here: http://www.devshed.com/c/a/MySQL/U...
-
-
7:30
»
Open Source Web Development Tutorials - RSS Feeds
It's hard to admit, but sooner or later we have to face the facts: most web developers (including myself) are reluctant to write SQL queries from scratch. To be honest, this happens for a logical reason: having so many languages and technologies to deal with at the same time on the client and server-side, it's perfectly understandable that we don't want to waste our valuable time hard coding boring SQL commands that in most cases have been neatly wrapped inside a framework or a library. Having such an evasive attitude with SQL is simply to defer an unavoidable fact: even if you use a framew...
-
-
9:00
»
Open Source Web Development Tutorials - RSS Feeds
If you develop MySQL-driven applications on a frequent basis, you'll know that steering clear of record duplication issues is a must, especially when it comes to maintaining the integrity and consistency of the data manipulated behind the scenes. While the problem can be the origin of a huge variety of serious issues, it's possible to solve them in a pretty simple manner. If you're a skilled programmer (regardless of the language of your choice) you can tackle the issue at the application level, even though this approach may lead you to write several chunks of boilerplate code, breaking down t...
WebDevelopment
(3842 unread)
ASP.NET Daily Articles
(262 unread)
