|
On most websites, content is stored in a database and served to visitors upon request. Databases are very fast, but there's lots of things that you can do to enhance its speed and make sure you won't waste any server resources. In this article, I have compiled 10 very useful tips to optimize and speed up your website database. Link: http://www.catswhocode.com/blog/...Labels: database, development, mysql
Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers. Link: http://net.tutsplus.com/tutorials/...Labels: database, development, mysql
Oracle Corporation is to buy Sun Microsystems for $9.50 a share in a deal valued at approximately $7.4 billion, just a few weeks after a deal by IBM to buy Sun fell apart. It looks like Oracle will pay a premium of $2.81 a share, or 42%, over Sun Micro’s closing price of $6.69 a share on Friday.
Oracle said the deal is valued at $5.6 billion excluding cash and debt. Oracle is calling Sun’s Java “the most important software” it has ever acquired. The deal, which is expected to close in the Summer and was unanimously approved by Sun’s board of directors, has massive implications for the future openness of Java and MySQL. What's going to happen to MySQL? Link: http://www.techcrunch.com/2009/04/20/...Labels: database, mysql, open source
Making schema changes or adding indexes to a database with more than 10 - 20 million rows completely locks the database for hours at a time. Removing old indexes takes just as much time, and not removing them hurts performance because the database will continue to read and write to those unused blocks on every INSERT, pushing important blocks out of memory. There are complex operational procedures you can do to circumvent these problems (like setting up the new index on a slave, and then swapping the slave and the master), but those procedures are so error prone and heavyweight, they implicitly discouraged our adding features that would require schema/index changes. Since our databases are all heavily sharded, the relational features of MySQL like JOIN have never been useful to us, so we decided to look outside of the realm of RDBMS. Link: http://bret.appspot.com/entry/how-friendfeed-uses-mysqlLabels: database
 Password-protected online file storage. Always available where you need it. Offers:- 5 GB of free online storage, available from any computer with Internet access.
- Create personal, shared, and public folders -- you decide who has access to each folder.
Personal- Use personal folders to back up important files that are only for you.
- Get to your files from any computer with Internet access by signing in with your Windows Live ID.
Shared- Shared folders make it easy to collaborate with coworkers or classmates.
- You decide how much control each person has over each shared folder. Some can just read what's there: others can add and delete files.
- Everyone who is sharing uses their own Windows Live ID.
Public- With public folders, anyone on the Internet can view your files, but they can't change them.
- Want to show your public files to others? Just send them a link! Each folder and file has its own web address.
Link: http://skydrive.live.com/welcomemoreinfo.aspxLabels: database, live, microsoft, website
Among the advances in 5.1 are partitioning, events scheduling, row-based replication and disk-based clustering. They are fairly standard features already offered by rivals IBM, Oracle and Microsoft, but they should help MySQL compete in environments where performance and the ability to scale are critical.
"One thing we're really most proud of is, frankly, we fixed a lot of outstanding bugs in 5.0," Urlocker said. "So 5.1 has not only greater reliability, but a performance increase of 20 percent. It will be more in some cases and less in others, but there's a significant performance boost and scalability enhancements." Link: http://www.cio.com/article/333613/...Labels: database, development, open source
 myLittleAdmin for SQL Server 2005 is the first web-based management tool specially designed for MS SQL Server 2005.
It lets you manage most objects of your databases and servers, including new objects such as snapshots, schemas, and credentials, etc. through a web browser. Faster than SQL Server Management Studio, its intuitive interface will seduce all users, from the DBAs to the webmasters, including the web-hosts. Link: http://www.mylittleadmin.com/enLabels: database
Sun Microsystems Inc. has agreed to buy open-source software maker MySQL AB for $1 billion, beefing up the server maker's database offerings with a company whose technology is used by some of the world's biggest Web sites. Link: http://www.physorg.com/news119696227.htmlLabels: database
Amazon SimpleDB is a web service for running queries on structured data in real time. This service works in close conjunction with Amazon Simple Storage Service (Amazon S3) and Amazon Elastic Compute Cloud (Amazon EC2), collectively providing the ability to store, process and query data sets in the cloud. These services are designed to make web-scale computing easier and more cost-effective for developers. Pricing:- $0.14 per Amazon SimpleDB Machine Hour consumed
- $0.10 per GB - all data transfer in
- $0.18 per GB - first 10 TB / month data transfer out
- $0.16 per GB - next 40 TB / month data transfer out
- $0.13 per GB - data transfer out / month over 50 TB
Link: http://www.amazon.com/gp/browse.html?node=342335011Labels: database, development, mysql
I read it here: http://cybernetnews.com/.../caution-online-md5-cracker-tool/Then went to the tool: http://md5.rednoize.com/I entered some hashes to common words to see what it will do. Of course common words were cracked without a problem. I then used HashCalc to make up some hashes to random letters and numbers and they failed like I expected them too. I then entered the characters and it supplied the hash, also like I expected. Go back to the site again with the hash to the random characters and the site will now be able to crack it. Basically learning by what you enter. This site will grow and more and more hashed values will be stored in their large database and therefore your password may be exposed in the future. Even more reason to have a string password. Grab a new strong password over at Make Password. Labels: database
 And that is to switch me 100% away from an application I have used for years. Navicat is a powerful MySQL database administration and development tool that is not only sophisticated enough for professional developers, but also easy to learn for new users. I did a post a few weeks back about some top tools for managing a MySQL database. From that post Navicat contacted my and offered me a free license to fully take advantage of their software. Usually I am weary about this but wanted to give it a try since a top developer I know that is in charge of DonationCoder.com also uses it. Why not give it a chance and use it for week to see if I like it - basically stop using the MySQL provided tools.  So glad I did as Navicat is an awesome application that is very well designed from a UI standpoint and provides all the functionality that one could need from a MySQL manager. So much better having all the features in a single interface instead of spreading them across several tools like MySQL Tools does. Quick Highlights:- Ability to drag and drop tables detween databases
- Ability to copy field(s) in a table design view and paste the fields into another table table design view. Makes copying part of a table definition easy
- Import wizard is very well designed and logical in its use and flow.
Wishes:- Query Editor. I like typing in queries and it would be nice if the Query Editor either provided intellisense as I typed a table/field name or let me drag and drop table/field names into the Query Editor without navigating back to the Query Builder window.
- Quick SQL selection: Basically allow me to select a table and press one button (or right-click menu selection) to generate an INSERT, SELECT, UPDATE and other SQL statements. Provide options of how the SQL statement is constructed: SQL statement on a single line, Lines based on SQL commands, or Seperate lines for each item.
Link: http://www.navicat.com/Labels: database, mysql, software
Just in case you have only touched the very basics of SQL this article can help to make sure what you are doing is at least correct, in the Author's eyes. Link: http://weblogs.sqlteam.com/jeffs/archive/2006/03/14/9289.aspxLabels: database
Data presentation can be both beautiful, elegant and descriptive. There is a variety of conventional ways to visualize data - tables, histograms, pie charts and bar graphs are being used every day, in every project and on every possible occasion. However, to convey a message to your readers effectively, sometimes you need more than just a simple pie chart of your results. In fact, there are much better, profound, creative and absolutely fascinating ways to visualize data. Many of them might become ubiquitous in the next few years.
So what can we expect? Which innovative ideas are already being used? And what are the most creative approaches to present data in ways we’ve never thought before?
Let’s take a look at the most interesting modern approaches to data visualization as well as related articles, resources and tools. Very cool article to scan through. Link: http://.../data-visualization-modern-approaches/Labels: database, development
A decent collection of some data lists that can be used in many database applications. The List: - United States Zip Codes with Longitude and Latitude
- Currency Codes
- Country Codes
- United States Cities
- States and Territories
- Domestic Airport Codes
- International Airport Codes
Link: http://...data-lists-to-add-to-your-toolbelt-of-awesomeness/Labels: database, development
|
Some pretty amazing data visualization techniques:
