» tagged pages
» logout

sorted by: recent | see : popular
Content Tagged with database + Web

Drizzle - What If There Was A MySQL Version Optimized For The Web

For the last 2-3 years, Brian Aker and I have had many discussions about how to refactor MySQL. Brian has been the one driving these discussions by asking why some things in MySQL were done in a certain way and in a true "what if" manner asked what would happen if we would do things in another way.

technology: dzone.com: tech links

persevere-framework - Google Code

Persevere is an open source set of tools for persistence and distributed computing using an intuitive standards-based JSON interfaces of HTTP REST, JSON-RPC, JSONPath, and HTTP Channels.

opensource: del.icio.us tag/opensource

persevere-framework - Google Code

Persevere is an open source set of tools for persistence and distributed computing using an intuitive standards-based JSON interfaces of HTTP REST, JSON-RPC, JSONPath, and HTTP Channels.

json: del.icio.us/tag/json

Day 1 of OSCON Begins, and More Tips for Conference-goers

I got an early start. Too early. But I’m from the west coast, so my body thinks I slept in. I wandered around a bit, took a few pics which you can see at my Flickr OSCON set, and I discovered a couple of things that might be of interest:

  • The starbucks in the conference center charges over $2 for a small cup of joe. There’s a starbucks right across the street (you can see it from the breakfast area - seriously, it’s 5 seconds away), and they charge less than $2 for a medium (grande). That’s less than I pay at home.
  • The ATM outside the starbucks charges $3 for cash. I’ll report back when I find a cheaper one, but most places seem to take plastic here.
  • Every computer involved in this conference, from registration to the video screens that dot the common areas, are running Windows XP. Just sayin’.
  • The light rail system is free to go just about anywhere except for the airport, so there’s no excuse not to get out and see Portland and take in the food and beer and stuff.
  • For beer-lovers, not only is there the Oregon Brewers Festival starting at the tail end of this conference, but there’s apparently another festival that we missed *last* weekend!! Keep that in mind when you’re planning to come to OSCON next year.
addthis_url = 'http%3A%2F%2Fwww.protocolostomy.com%2F2008%2F07%2F21%2Fday-1-of-oscon-begins-and-more-tips-for-conference-goers%2F'; addthis_title = 'Day+1+of+OSCON+Begins%2C+and+More+Tips+for+Conference-goers'; addthis_pub = 'jonesy';

MySQL: Planet MySQL

SQLiteDBMS - Free OS Linux/OSX

SQLiteDBMS is a database management server for SQLite. It allows an sqlite3 process to be accessed via a TCP/IP network. It provides Extended SQL, SSL, basic authentication, prepared statement, query cache, WebDAV and table level access control. It includ

XML: del.icio.us/tag/xml

A close look at three Rails 2.1 bugs

Rails 2.1 introduces three annoying bugs. Let's fix them.

technology: dzone.com: tech links

SQL Speed Test: IN vs OR

Speed and efficiency are key factors when running a website. All code needs to be optimized, whether it is PHP, ASP, Python, or SQL. This post provides a speed comparison between the "IN" and "OR" statements of SQL.

technology: dzone.com: tech links

Cloud computing hype overload

I’ve been working with what I used to call “utility computing” tools for about 6-9 months. However, for about the past 2 months, I’ve been seeing the term “cloud computing” all over the place, and there is so much buzz surrounding it that it’s reaching that magical point best described using Alan Greenspan’s words: “Irrational Exuberance”.

When Alan Greenspan used those words to describe the attitudes of investors toward the markets, what he was basically saying was that there were people who didn’t really know what they were doing, putting more money than they ought, into things they knew relatively little about. Further, he was saying that the decisions people were making with regards to where to put their money were a) bad, or at least b) not based on sound reasoning, or the ‘facts on the ground’.

This, I think, is where we are at with “cloud computing”. The blog post that put me over the edge is this one, for the record. I read Sean’s writings often enough, but this one strikes me as being a little off, a little sensationalistic, not based in reality, and a little misleading.

Maybe he just didn’t put enough qualifiers in there. His post might make more sense if he limited its scope and provided more facts, but I guess it’s just an opinion piece so he decided not to go that route, and that’s his prerogative I guess.

By limiting the scope, I mean he should’ve realized that there are millions of web sites currently scaling quite nicely without the use of cloud computing. In addition, some of the new ones that are having issues are also not using cloud computing, and when they hit bumps in the road, they make it through, and the great thing is that they also share their stories, and those stories indicate that a cloud (or, the current cloud offerings) wouldn’t have helped much (there’s lots of other evidence of that too). What would’ve helped is if they had paid more attention to:

  • monitoring
  • initial infrastructure design
  • their own app code and app design
These aren’t issues that cloud computing takes away. What’s more, cloud computing is something of a moving target, many of the solutions aren’t as mature as you’d want them to be if you’re betting the house on them (EC2 only recently got “elastic IPs” and persistent storage is still not there, AppEngine only supports Python and has some rather severe limitations on functionality of your app), and they introduce a potentially large learning curve both in terms of how the individual services work, as well as how the heck to make your app fit into the cloud solution of your choosing. Think SimpleDB scales? Well, it does, but it’s also not a relational database, and doesn’t guarantee…. much of anything, including data integrity. You can’t interface with it using the drivers, interfaces, and language you’re used to using, either, because it’s not just a mysql wrapper or something - it’s a new beast entirely. Enjoy!
This is not to mention, of course, that some people have absolutely no choice but to scale without the help of the cloud, because corporate policy, common sense, or other forces mean that they can’t have their data passing through non-corporate-owned machines and/or networks. Also, Sean omits any mention of the cost factor, which is often a huge driver in getting startups to use these services, but may not really make the move “worth it” in some cases.
Anyway, in short, all I’m really saying is that it’s disingenuous to say that the future of web computing is “the cloud” because “only the cloud can scale”. That’s just silly. Non-cloud infrastructures can scale fine depending on the balance between the demands of the application and the funds available. The future of web computing will probably involve shared, utility computing architectures, but the future doesn’t depend on cloud computing.
addthis_url = 'http%3A%2F%2Fwww.protocolostomy.com%2F2008%2F07%2F07%2Fcloud-computing-hype-overload%2F'; addthis_title = 'Cloud+computing+hype+overload'; addthis_pub = 'jonesy';

MySQL: Planet MySQL

Linkrolls on del.icio.us

A way to grab code snippets from del.icio.us for display

json: del.icio.us/tag/json

Build Seamless, Fully Functional Forms with No Coding

This is a nice example of how to use the form-building service by Wufoo.

technology: dzone.com: tech links

Website Database Design and its Fundamentals

Any website that contains a database requires website database design in order to maintain it. Some websites are information based and have more databases, for example educational sites, online bookstore, scientific sites, etc. Web database management takes care of regular updates and additions of the latest information on the site. It supports easy access to online information, thus making day-today work smoother.

There are several companies that provide website database designing. They have a professional approach and a team of programmers that work on website database design. Knowledge of programming is essential to set up web databases. In addition, security measures need to be considered and integrated to prevent loopholes. These website database design companies provide suggestions and tips for setting up databases, as well as install the appropriate security measures.

A wide variety of database languages are available to choose from such as MySql, SOL server, Access and so on. MySql is the most widely used database language. It is an open source language. The selection of database design is dependant on the infrastructure of the company and its website.

The database management system is of two types: the server database and the desktop databases. The basic factor that differentiates these databases is their user applications. A server database is aimed at multi-user applications, whereas a desktop database is for single-user applications. Therefore it is important to have a clear understanding of your business type and its requirements, as the database selection depends on it. In summary you should discuss and evaluate the following points with the Website Database Design Company before selecting the database type:

• The availability of hardware and the budget available for additional purchase. • The frequency at which the online data would be modified and the source responsible for its modification. • Server selection is also dependant on who the data maintainer is. • The database users and the tasks performed by them influences the database type needed. • Who is the resource held responsible for giving IT support to the database. • It is to be calculated whether a data access facility is provided over the Internet, and the required level of access should be supported.

Always be aware to avoid some commonly made mistakes in database designs. Some of them include deficiency of testing, improper documentation, low quality of web designing, and no usage of storage process for accessing the data. These complexities are better taken care of by a good database management company so that you can concentrate on core issues of your business.

Spinx Web Design is a leading Web Design Company Los Angeles providing Web Database Development Services, Custom Website Database Design, Database Applications, Database Management & much more

The Benefits of a Data Abstraction Layer for SOA

Enterprises have complex information structures as a result of evolving applications and databases deployed through the years. In addition to modern databases, environments commonly include mainframes, outdated storage technologies and custom data sources.

technology: dzone.com: tech links

Scale Cheaply - Sharding

There are a lot of expensive ways to scale your database – all of which are highly touted by the big three database vendors because, well, they want to sell you all types of really expensive stuff. Despite what an “engagement consultant” might tell you though, most of the high-traffic websites on the web (google, digg, facebook) rely on far cheaper and better strategies: the core of which is called sharding.

technology: dzone.com: tech links

Page 1 | Next >>