InfoQ Homepage Data Access Content on InfoQ
-
MySpace.com uses iBATIS.NET for persistence
Popular social site MySpace.com, which is the number 5 most trafficked site on the internet according to alexa.com is running a .NET backend and uses iBatis.NET for persistence. iBATIS is an open source data mapper framework that is commonly used when projects wish to control the SQL used instead of having it generated by an ORM framework.
-
SQL Server Hosting Toolkit CTP 1 Released
Microsoft has released the first CTP of its SQL Server Hosting Toolkit. This toolkit is designed to provide support for companies using a hosted SQL Server.
-
Preventing SQL Injection Attacks in .NET Applications
Back in September InfoQ reported on Michael Sutton's alarming study of SQL injection vulnerabilities. Fortunately Scott Guthrie shows us that preventing most of them in .NET is not that hard.
-
Upgrading SQL Server - xp_execresultset
SQL Server 2000 had a useful, though undocumented, function called xp_execresultset. Unfortunately for those currently using it, SQL Server 2005 has dropped this feature.
-
Hibernate 3.2 Released with Java Persistence Provider Support
The Hibernate team has released Hibernate 3.2 GA. This release is ready for production use and includes final releases of the Java Persistence provider, Hibernate Annotations and Hibernate EntityManager. The Hibernate Java Persistence provider has been certified with the Sun TCK.
-
Ruby Driver for HSQLDB Released
A Ruby driver for HSQLDB has been released on RubyForge by Jared Richardson. The driver relies on Java Bridge technology (quite different than JRuby) to interop with the Java-based HSQLDB (formerly HypersonicSQL) open-source database.
-
English Query Discontinued in VS 2005
English Query, a tool that translated queries written in English into SQL queries, has been discontinued.
-
Study Shows That 11% of Sites Are Vulnerable to SQL Injection Attacks
In an informal study, Michael Sutton of SPI Dynamics was able to demonstrate that 80 out of 708 tested web sites were susceptible to SQL injection attacks.
-
C24 Creates Process for XQuery over non-XML without intermediary XML
Financial integration tool vendor C24 has added a unique XQuery optimization to their Integration Objects product that allows full XML XQuery and XSLT capabilities on non-XML documents without the overhead of first converting those non-xml documents into instances of XML.
-
System.Data.SQLite to Support ADO.NET vNext
SQLite is a lightweight database engine written in C. Designed to be cross-platform, it doesn't have any external dependencies and only takes about 250 KB of disk space. Though it doesn't support all of SQL92, it is suitable for smaller projects, especially ones that need cross-platform support. And to top it all off, the source code is in the public domain.
-
SQL Server Everywhere: the Future of Lightweight Databases
What is a developer who wants a light-weight, file-sharing based database to do? The answer is SQL Server Everywhere (SSEv). Like Jet, it is an in-process, file-sharing based engine. Though it lacks the functionality of SQL Server, it is suitable for small end-user applications that run on the desktop.
-
H2 1.0 Database by Hypersonic Creator is Out
HSQLDB creator Thomas Mueller has released 1.0 final of H2, his pure Java database successor to HSQLDB. H2's focus is to be best database for the lower end (low number of concurrent connections, embedded usage). InfoQ spoke to H2 creator Thomas Mueller to find out more.
-
Spring and EJB 3 Compared
devx is hosting an article comparing Spring 2 and EJB 3 focusing on support for persistence, transaction management, and statefulness, concluding that support is mostly the same with but with EJB being slightly better at handling state.
-
LINQ Examples Posted
Scott Guthrie has posted the materials from his recent Language INtegrated Query (LINQ) talk at Tech Ed Australia. For those looking for detailed code samples to understand LINQ further, download these materials. LINQ is a set of extensions for .NET to provide a native query syntax for C# and VB, allowing developers to perform SQL-like queries against any .NET collection or drop down to raw SQL.
-
Ruport: A Ruby Report Builder and Reporting Library
Gregory Brown releases a free library and toolset for Ruby that makes building reporting applications easy.