sorted by: recent | see : popular

Content Tagged with technology + Database

Unfortunately not a live feed - it's an archived database of recipes in a specif format - has over 140,000 recipes though.

Memcached's popularity is expanding its use into some odd places. It's becoming an authoritative datastore for some large sites, and almost more importantly it's sneaking into the lowly web startup. This is causing some discussion.

Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing. The following corollaries to Murphy’s Law relate this inevitability of something going “bump” in the night to data warehousing.

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code. In this case the query run time went from 24 hours+ to 36 seconds!!!

Information on the 3.3. release of hibernate

The term “database management” sometimes sends shivers of boredom down our spine. However, when combined with terms like “Ajax” it suddenly doesn’t seem that bad, now, does it? For many, phpMyAdmin was the only answer for creating databases and managing, editing, and optimizing their current database fields and entries. Along came a relatively unknown database manager named SQL Buddy and, with a little help from Ajax, blew the competition away.

David van Couvering, Database Architect for NetBeans, shares his enthusiasm for the NetBeans development process below.

JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you will get. As for any rules there are however exceptions

A simple MySQL configuration tip which may dramatically improve performance.

Netbeans, “the only IDE that you need” is undergoing a major overhaul and the new version is called Netbeans 6.5. Today after weeks of development and testing, Netbeans passed a few test criteria and has been decided to be stable enough by the Netbeans team to be called a Beta. Now begins the real stabilizing process and ironing out the bugs that remain.

Over the past several days, a significant number (in the thousands) of web applications, some of them well-known and well-used, have fallen victim to a distributed SQL injection attack that takes advantage of weak or non-existent input validation to inject malicious HTML code that then performs a drive-by malware attack on unsuspecting visitors. Since visitors to your site trust it, if your site has been hacked they are more likely to allow the malware to install on their computer (especially if, for example, the malware is delivered in the form of a browser helper object or something along those lines

How would you determine whether your website is being hacked or not? Read the way hacker steals the information and hacks your website. Moreover, how you can help preventing your website being hacked. IS YOUR WEBSITE HACKABLE? Some hackers, for example, will take advantage of web application vulnerabilities and may maliciously inject code within vulnerable web applications to trick users and redirect them towards phisphing sites. This technique is called Cross-Site Scripting and may be used even when the web servers and database engine contain no vulnerabilities themselves.

If you've got a few servers you are responsible for, check out these tips to keep yourself from accidentally causing problems. Good stuff!

In this demo, we quickly create a web application that uses Hibernate to read a database containing travel itineraries and displays the results in a JSP page using Woodstock JSF components.

At JavaRanch and JavaBlackBelt, we frequently see questions from developers trying to get their first job or advance to a higher level job. They wonder if getting certified will help them advance.

So I’m doing something that relies on MySQL a lot. Last night I had to test a rebuild process that we would use if there was a failure in our systems. Worst case secnairo would be we would have lost about a weeks data and need to reinsert the whole lot.

SQL::Translator is a group of Perl modules that manipulate structured data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams: GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel spreadsheets), serializing parsed schemas (via Storable, YAML and XML), creating documentation (HTML and POD), and more.

With all due respect to the technology and it's advocates (myself included), after a surge in articles describing the merits of using memcached I'm just pushing a thought breakpoint for developers to think whether they actually need it or not?