sorted by: recent | see :
popular
Content Tagged with Other + Database
SQL Server Precision And Scale Problems
Many people are confused about SQL Server’s precision and scale. This is unfortunate because choosing the correct values for precision and scale is critically important when you perform math operations using the decimal/numeric data type
Difference between NULL and DBNull
I have always misunderstood the difference between NULL and DBNULL until recently while I was working on ASP.NET web application, and was talking to a Webservice and I found an exception coming from one of the web methods inside the Webservice which is using the SqlCommand.ExecuteScalar() method.
Polyglot Persistence
With things like Amazon SimpleDB, Google Bigtable, Microsoft SQL Server Data Services (SSDS), CouchDB, and lots more, it seems like we're now seeing the beginning of Polyglot Persistence in addition to polyglot programming.
Creating an ASP.NET Newsletter Application
A tutorial to create a newsletter application for your website. It allows users to subscribe and unsubscribe from the newsletter. A simple online administration interface (an ASP.NET page) allows the admin to create and send newsletters/emails.
Podcast: Writing LUA Scripts for MySQL Proxy - MySQL University
This session will introduce the basics of the Lua language, with particular emphasis on the features of immediate use with MySQL Proxy. The lecture will concludes with a few examples of growing difficulty, commented in depth.
The Evolution Of LINQ And Its Impact On The Design Of C#
I was a huge fan of the Connections series, hosted by James Burke, when it aired on the Discovery Channel. Its basic premise: how seemingly unrelated discoveries influenced other discoveries, which ultimately led to some modern-day convenience. The moral, if you will, is that no advancement is made in isolation. Not surprisingly, the same is true for Language Integrated Query (LINQ).Anti-pattern: Locator Variable
A funny anti-pattern that is found in the official Oracle PL/SQL User's Guide and Reference. Worst exception handling EVER.Google Open-Sources Data Exchange Language
Google has open-sourced its protocol buffers, the company's lingua franca for encoding various types of data, in order to set the stage for a wave of new releases, according to official company blog posts and documents.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
The Even Bigger News About Maglev
Maglev is a new Gemstone Smalltalk based VM for Ruby project. Ruby + Smalltalk + Gemstone is your secret nuclear development weapon.SQL Server Programming Hacks
This is a collection of SQL hacks, right now we there are 8 sections and between 70 and 80 hacks.MagLev: Gemstone builds Ruby runtime based on Smalltalk VM
OODB vendor Gemstone works on a Ruby VM called MagLev. Working with Seaside's and DabbleDB's Avi Bryant, Gemstone bases the Ruby runtime on their Smalltalk VM to offer performance and powerful persistence features. InfoQ talked to Avi Bryant and Gemstone's Bob Walker about the technology behind MagLev and the plans for it.Defining a Data Grid
Cameron Purdy defines In-Memory Data Grids with a focus on Oracle Coherence. In the process he touches on predictable scalability, eliminating bottlenecks, continuous availability, failover and information reliability.The Planned Security Model for CouchDB
A summary of the planned, but not yet implemented, security model for CouchDB. The author wonders whether this plan could, even without alterations, allow for a capability oriented model.Gravl: CriteriaBuilder
Criteria wraps Hibernate's powerful Restrictions API, and gives you a wealth of expressiveness. For the Gravl archive, I wanted a "by tag" archive option, so you could see just the "groovy-related" archive. Because blog entries have a many to many with blog tags, dynamic finders weren't going to get me there.21 Time-Saving Snippets for Any ColdFusion Developer
Web developers often do repetitive tasks, some of these tasks can be saved as snippets in IDE’s such as Dreamweaver, Eclipse and Homesite to name a few. Here are 21 snippets for ColdFusion developers that will save you time.The X++ Programming Language
X++ is Microsoft's object-oriented language with similarities to C++ and Java for MorphX, a platform for constructing complex accounting and business management systems. X++ includes a number of common SQL commands as an integrated part of the language. The memory management model is extremely simple: objects are created with a new operator. There are no explicit programmer-defined pointer data types, and there is no pointer arithmetic. X++ provides extensive compile-time checking, followed by a second level of run-time checking. The X++ garbage collector runs automatically; as soon as no references exist to a particular object, that object is deleted and its storage is reclaimed.How to connect to a Grails HSQL Database
How to connect to a Grails HSQL DatabaseReturn Random Records in MySQL
The ability to return random records from a MySQL table is invaluable.Returning random records is helpful when: featuring items without showing favoritism to one, testing different result sets in your PHP, and looking to display specific items in a non-specific order. The great part about selecting random records from your MySQL tables is that it's really easy.Accessing SimpleDB using Java and Erlang
Amazon has recently announced limited beta availability of a new web service SimpleDB, which is somewhat similar to Amazon’s Dynamo service can store key-value based data. However, Amazon’s Dynamo service is not publicly available. The SimpleDB web service provides both REST and SOAP based APIs, though the REST APIs are really XML over HTTP and use simple query and RPC style parameters to create or retrieve data.Amazon SimpleDB and CouchDB compared
An early, somewhat superficial comparison of Amazon SimpleDB to CouchDB. The major difference that the author forgot to highlight is that SimpleDB, as one of the Amazon Web Services, is hosted. CouchDB installation and configuration are up to you.The Sad State Of Programmers Part 1 : The Phone Interview.
The Sad State Of Programmers Part 1 : The Phone Interview.Groovy Database With Apache Derby
A tutorial that looks at Groovy's database functionality using the Apache Derby databaseCouchDB 0.7.0
The CouchDB development team is proud to announce CouchDB version 0.7.0Groovy Grails and the JPA
If you are using Grails 1.0_RC1 or later chances are the tutorials you've found for making EJB3 persistence annotated POJOs work with Grails don't match up exactly. If you're like me, probably need to be made aware of a few differences in configuration. They aren't big... but the little differences could trip you up.Get into data with Groovy
In the first part of this two-part series we looked at how Groovy provides a simple and intuitive approach to accessing MySQL. Compared to Java, Groovy is less verbose and more focused on what the developer wants to do with the database.
Additionally, things like opening and closing database connections, writing boilerplate code to handle exceptions and other house-keeping activities are hidden from the developer.Using DB2 with Grails on Windows
Grails comes set up with HSQL's in memory database by default.
You can see this in the %yourAppDir%\grails-app\conf\DataSource.groovyGroovy way to MySQL
In the case of database access, Groovy can be used both with the standard Java JDBC mechanism (which makes use of SQL) or with its own high-level SQL-less DataSet libraries. In this two-part hands-on tutorial we'll look at how you can use Groovy to quickly and easily interface with a MySQL database sitting on a remote server somewhere.Generate JPA (or GORM) classes from your database for Java and Grails
Whether you start with the database or start with code, no one wants to do the other one. Certainly by the DRY principle it is a waste of time and potentially a place where you could introduce bugs into your code. Today Dave and I are releasing a command-line utility that will handle the case where you start with the database and want to use JPA to access it. There are other utilities that do this that are generally built into IDEs, however this one fills the niche for those that want to do it in a more automated fashion and don’t want to edit the actual generated code. In fact, we used a previous version of this tool at Gauntlet throughout the development process to keep our database and JPA classes in sync with one another.Erlang: Mnesia performance basics
I thought I’d continue the whirlwind guide to Mnesia that I began in Getting started with Mnesia. I have no idea how many of the thousands of readers actually found the last part useful. At least one, judging by the comments, but more to the point it’s rather handy for me to write this stuff down as I’m flitting between various new (to me) things at the moment.Pure Haskell MySQL bindings in the works
I’ve spent a few spare hours here and there working on a pure Haskell interface to MySQL recently. On the principle that perhaps someone else might want to join in the fun, I’ve published a darcs repository already (see the link above for more details):Ten SQL Server Functions That You Hardly Use But Should
Ten SQL Server Functions That You Hardly Use But Shouldhow to display rows as columns SQL Tip
most of the time when we are using normalized form of a database we need away to show data in rows of a table as column holding other data.
this could be done easily with SQLGroovy MDA Code Generation Library
Groovy MDA 1.0 has been released. Now you can generate JPA entity beans from a UML model using the Groovy language. See User's Guide for details.Erlang's Mnesia - a distributed DBMS for highly scalable applications
... These attributes can be used to describe Mnesia , the Erlang distributed DBMS, that supports high scalability and fault tolerance through replication, with the ability to lookup records without the need for a traditional relational database join. Mnesia is part of Erlang/OTP and designed to be used with Erlang language applications running on the Erlang VM (there are interfaces available for C/C++ and Java).
In the white paper "Mnesia - A Distributed Robust DBMS for Telecommunications Applications ", published in 1999, the authors (Håkan Mattsson, Hans Nilsson, Claes Wikstrom) introduce the astonishingly prescient concepts and key differences in the database.Database Design: Choosing a Primary Key
Choosing the proper primary key is a critical task in modeling relational data. If possible, entities should have a unique identifier that has meaning rather than some obscure sequential integer. But the natural identifier need not be the primary key.