MySQL ::
Think MySQL in the cloud
Posted on :: Oct 29
Amazon on Tuesday launched a public beta of a service dubbed the Amazon Relational Database Service (RDS). The main appeal: Allow customers to operate and scale database clusters while leaving pesky tasks like patching and administration to Amazon Web Services.
Adam Selipsky, vice president of Amazon Web Services (AWS), said the goal was to make it easy to scale MySQL clusters. He noted that “MySQL code and developer tools today will work with RDS.”
Think of it as MySQL in cloud computing...
Optimizing and Backing-up a MySQL Database in Coldfusion
Posted on :: Oct 15
If you're working on databases and want to either Optimize of Backup your Database, you should automatically optize all the list of tables and then back it up.
Spectral Core, great product, even better Service!
Posted on :: Jun 17
For a While now, I've been contemplating and evaluating a plethora of Database Conversion Scripts, ranging from ESF Database Express to Spectral Core Full Convert Enterprise and everything inbetween.
Of all the products I tried, Spectral Core was indeed the best one I had used. After Exiting my Trial Version, there's a nice little comments form asking for your feedback. Well I filled out, stating tha tI had no problems with the product, and that I'd buy it, just that it was too Expensive (I just didn't have the $300 for it...but I did have a small budget to work with) for me to Purchase.
Well, within 10-20 minutes later I have this email in my mailbox from them, asking me what price range would I be suitable with to purchase the system, I nearly insulted him with the Price I had recommended to him (I later discovered that the Person with whom I was commnicating with was the owner), however I have to say that he did indeed agree with me that the price that I was quoting (which was the MAXIMUM of MY Budget for said software type) was indeed somewhat disagreeable.
Well, an email later I was offered a substanital discount (nevertheless still out of my budget).
All things aside, we worked out an arrangement for a suitable and agreeable price, and the owner of the Company has been very very responsive to my emails.
Now, onto the product itself...
Update one table from another using a join
Posted on :: Jun 2
SQL: Data Types
Posted on :: Apr 29
This is probably a little late in the coming, however I've included the following which is a list of general SQL datatypes that may not be supported by all relational databases. I know however that MySQL and SQL Server support these datatypes.
Are MySQL stored procedures slow?
Posted on :: Apr 15
Slow stored procedure performance is one of the reasons why it usually isn’t wise to implement computationally expensive business logic in the database. With networks not being the bottleneck they once were it is often better to extract the data to the application layer and process it in the programming language of your choice, even if that takes a few extra round trips to the database. There are exceptions where those extra round trips are too numerous and prohibitively expensive. With something as complex as a database there are always exceptions.
This example is a bit too simple, but, based on experience, it is representative of the general performance of stored procedure logic.
How can MySQL get away with such poor performance? Well, the equivalent code in MS SQL Server took 80 seconds on the same hardware, which is also two orders of magnitude slower than C# or Java code.
MySQL Stored Procedures and Functions
Posted on :: Apr 15
Over the past few years one major advantage that some databases, such as Oracle and Microsoft SQL Server, have had over MySQL is their ability to use stored functions and stored procedures. Well, that was before MySQL 5; with MySQL 5 a database developer can start adding in their own bespoke functionality.
Using ColdFusion's CFDBInfo to Dynamically Output Database Columns and Tables
Posted on :: Mar 23
The ColdFusion tag CFDBInfo was introduced in ColdFusion 8. I finally got around to playing with it and thought someone other than me might find this useful. I was thinking of using it for creating a dynamic SQL dump for some of my projects I'm currently writting, and thought I should share it with the world.
There are a ton of uses for this excellent CF Tag, and I've included a few samples below.
When will cfqueryparam NOT protect me?
Posted on :: Mar 23
Guess what, Using CFPARAM in your ColdFusion code, may not always save you from SQL Injection.
"How?", you may ask. Let me give you an example of an SQL injection attack that's not caught by cfqueryparam.
SQL injection can occur any time cautions are not taken to completely separate your SQL code from its parameters and the parameters being passed in are allowed to flow into the SQL statement itself. SQL injection can also occur when building the SQL statement's table and column names dynamically.MySQL Database Backup .MYI and .MYD
Posted on :: Nov 17
This article is about how to restore a backup to MySQL from a .MYI and .MYD file that you may have. Our dedicated host backs up only these files and does not use the mysqldump utility to create a full SQL backup of our database. This is fine, but makes a bit extra work. So let us get started.
Determine Your Version
First we need to determine the version of your server's MySQL database. Mine was 3.23, old I know. I do not know if you can mix and match .MYD files so I just downloaded that and installed it on my local computer. I would suggest doing the same, this way you are messing with copies of the actual database instead of the real thing.Preventing SQL Injection
Posted on :: Nov 17
Most web applications interact with a database, and the data stored therein frequently originates from remote sources. Thus, when creating an SQL statement, you often use input in its construction. A typical SQL injection attack exploits this scenario by attempting to send fragments of valid SQL queries as unexpected values of GET and POST data. This is why an SQL injection vulnerability is often the fault of poor filtering and escaping, and this fact cannot be stressed enough.
I'm going to explains SQL injection by looking at a few example attacks and then introducing some simple and effective safeguards. By applying best practices, you can practically eliminate SQL injection from your list of security concerns.
Preventing SQL Injection in PHP & Coldfusion
MySQL or SQL Server?
Posted on :: Nov 6
Look beyond politics and hype when deciding which to use.
Takeaway: MySQL may be free, but what if money isn't the only determining factor? Find out how these two database heavyweights stack up against each other and how to decide which one to use as your database system.
Two of the most popular back-end data stores Web developers work with today are MySQL and SQL Server. They are fundamentally similar in that both are data storage and retrieval systems. You can use SQL to retrieve data with either because both claim support for ANSI-SQL. Both database systems support primary keys and key indices, so you can also create indices used simply to speed up queries and for constraining input. Further, both provide some form of XML support.
Aside from the obvious difference of price, what distinguishes these two products from each other, and how do you choose between them? Let's take a look at the core differences between these two products, including licensing costs, performance, and security.MySQL :: The Myths of MySQL
Posted on :: Nov 6
I have heard many a shop discuss the old argument of SQL Server or MySQL, and generally the System Admin somewhere always sqashes MySQL as it has always appeared to me that they don't fully understand the capabilities of MySQL versus SQL Server. This is genrally because of outdated information on the Internet, and with the end result often being that antiquated views and opinions are quoted or otherwise recycled without the end users of such information ever knowing that the data either no longer applies or perhaps was never correct to begin with.