Network icons
Lovely network icons
Explore Posterous
Search posterous
Search all posts and users. Type a name, type a favorite song title, whatever! See what comes up.
More posterous blogs
Here are posterous posts filed under database...
Untitled
Music Catalogue Master 5.21: Automatically catalogs CDs, MP3s and vinyl records into a searchable database. http://bit.ly/1uutBq
via Ping.fm
Untitled
Stockroom Organizer Deluxe 3.2: Inventory database system for a small warehouse or storage facility. http://bit.ly/4k1f13
via Ping.fm
Generating Database Schema With SQL and GraphViz
Documentare la base dati con GraphViz. Un altro strumento che utilizza la descrizione DOT dei grafici.
Untitled
Password Agent Lite 2.6.0: Store all your sensitive data in a secure, compact and easy to navigate database http://bit.ly/3qU6C
via Ping.fm
Announcing Amazon Relational Database Service, plus Amazon EC2
This is going to be huge!
From: Amazon Web Services
Date: October 27, 2009 1:25:00 AM PDT
To: scot
Subject: Announcing Amazon Relational Database Service, plus Amazon EC2 price drop and High Memory Instances
Dear Amazon Web Services Customer,
We are excited to announce the public beta of Amazon Relational Database Service (Amazon RDS), a new web service that makes it easy to set up, operate, and scale relational databases in the cloud. Amazon RDS gives you all the features and capabilities of a MySQL database, while managing time-consuming database administration tasks and providing the cost-efficiency of running in the AWS cloud. We're also excited to announce lower prices for Amazon Elastic Compute Cloud (Amazon EC2) instances and a new family of Amazon EC2 High-Memory Instances, tailored for customers wanting to run their own large databases and other memory intensive applications. To get started using Amazon RDS, High-Memory Instances for Amazon EC2, and other Amazon Web Services, visit http://aws.amazon.com.
Amazon RDS provides a fully featured MySQL database, so the code, applications, and tools that you use today with your existing MySQL databases work in Amazon RDS without modification. The service automatically handles common database administration tasks, such as setup and provisioning, patch management, and backup. You also have the flexibility to scale the compute and storage resources associated with your database instance through a simple API call. Like all AWS infrastructure services, Amazon RDS is easy to deploy and simple to manage. Here are some highlights for Amazon RDS:
- Simple to Deploy - Quickly create a new production-ready relational database with a simple API call.
- Managed - Amazon RDS handles generic, time-consuming database management tasks, such as patch management and backup.
- Compatible - All of your existing MySQL database tools, applications, and drivers will still work.
- Scalable - With a simple API call you can scale the compute and storage resources available to your database to meet your business needs and application load.
- Reliable - Amazon RDS runs on the same highly reliable infrastructure used by other Amazon Web Services. Amazon RDS also gives you additional peace of mind by providing an automated database backup facility.
- Inexpensive - You pay very low rates and only for the resources you actually consume. There are no long-term contracts or up-front commitments to use Amazon RDS.
For more information on Amazon RDS pricing and features, please visit http://aws.amazon.com/rds.
We are also pleased to introduce a new family of High-Memory Instances for Amazon EC2. This new instance family further expands the available selection of computing configurations for Amazon EC2, helping you choose the CPU capacity, memory resources, and networking throughput that your applications require. High-Memory Instances are designed to be used with memory-intensive workloads such as databases, caching, and rendering, and are optimized for low-latency, high-throughput performance. The instance specifications are:
- Double Extra Large: 34.2 GB memory, 13 ECU (4 virtual cores with 3.25 ECU each), 850 GB storage, 64-bit platform
- Quadruple Extra Large: 68.4 GB memory, 26 ECU (8 virtual cores with 3.25 ECU each), 1690 GB storage, 64-bit platform.
Please visit the Amazon EC2 page for additional information on these High-Memory instances.
Finally, we are also lowering prices on all Amazon EC2 On-Demand compute instances, effective on November 1st. Charges for Linux-based instances will drop 15% -- a small Linux instance will now cost just 8.5 cents per hour of computing, compared to the previous price of 10 cents per hour. For more details by instance type and region, please visit the Amazon EC2 page.
Sincerely,
The Amazon Web Services Team
The return of the prodigal daughter
The biblical reference is entirely unfair. Katherine is in no way lost (at least in any way relevant to our nuclear family) or wasteful. Really, its the opposite. Her visit is celebrated as one would expect, not in spite of expectation.
She woke me up today with the volume of excitement and scorn to force me into a dog walk with her. It was short on account of her injuries. These injuries are also what afforded her the trip home (and saved her from initiating newer rugby players this weekend at Stony Brook). With disappointed dogs home, we ate as a family: Dad, Kat and I. Stake for them, and mashed potatoes for the three of us. Kat's favorite meal.
Citing absent navigation skills and memory, Katherine dragged me into taking Joker and Chance to Sarah. An hour driving to play with the dogs inside a closed tennis court for thirty minutes. After killing the hour and a half, we found mom and dad on the couches watching TV. Neither of them have been anywhere besides the bedroom and the kitchen in as long as I have. Months. Natural, Katherine was soon in front of the TV wearing in her spot on the couch as well.
I descended to the basement and completed the last real nagging part of the website. I left the spot of nagging feature vacant long enough to view it as a whole. Disgust followed. It needs to be rewritten. With this in mind, I drew out what I'd expect the database to look like so I could imagine the server calls would be so I could tailor the javascript. I am totally clueless on how to store and fill enumerated qualifications. I am also shaking on how to store multiple choice question data. Hopefully andrew will be able to give me some database structure insight.
Tonight, I also finally made an effort to play the song I was aspiring to before leaving for Georgia. C E7 Am F. How hard can that be!?
UPDATED - SQL: Parsename Replace RTRIM LTRIM
Attached in the [DOWNLOAD SECTION] is a script titled "FourPartStringParse_v0.01.sql" that will parse out an address. It has limitations though. See the file comments for details. Thanks to @MarlonRibunal for the help!
I tried this route, but the problem with this script is that it counts every space. So if there happens to be a double space between two words then it gets added to the total count.
DECLARE @String NVARCHAR(100)
SET @String = 'How many words are there in this big string?'
SELECT @String,(1 + LEN(@String) - LEN(REPLACE(@String, ' ', ''))) AS WordCount as you can see in the illustration below.
The following method worked better, but I still had some issues with it as I mentioned before.
Untitled
Database Workbench Pro 3.4.1: Cross database engine developer IDE http://bit.ly/3nImsb
via Ping.fm
Amazon delivers the golden egg - RDS
was only a matter of time for the mysql db to be in the cloud properly.
Amazon RDS provides a fully featured MySQL database, so the code, applications, and tools that you use today with your existing MySQL databases work in Amazon RDS without modification. The service automatically handles common database administration tasks, such as setup and provisioning, patch management, and backup. You also have the flexibility to scale the compute and storage resources associated with your database instance through a simple API call. Like all AWS infrastructure services, Amazon RDS is easy to deploy and simple to manage. Here are some highlights for Amazon RDS
can i get a 'yay' - now if only they had custom versions of a really really lightweight hypertuned OS image. like a really custom nginx, memcached, php, zend image the dream would be complete. really good news thou to have something like this now in the cloud.
