background preloader

DATABASE

Facebook Twitter

Features - Chive. Chive is a modern Open-Source MySQL Data Management tool.

Features - Chive

With it's fast and elaborate user interface it is getting very popular especially by web engineers. Chive was created because of an disaffection with existing tools. They usually were hard to handle and very time-consuming while the daily use of an web engineer. Keyboard focused workflow for fast search and navigation Chive always puts your keyboard focus into the quick-search text box. Inline editing everywhere - for data, tables, indices and more With Chive the administration of new datasets, procedures, and tables is easy. Syntax Editors with colored accentuation Longer SQL inquiries can be confusing and complicated. Repeated administration of your SQL queries. PHP Web Services: After Getting Started. Applies To WSMessage Class In a Web services invocation, there are two messages involved for two way operations.

PHP Web Services: After Getting Started

One is the request message and the other is the response message. WSMessage class in the Web services framework for PHP is used to represent these messages. The str member variable of the WSMessage class can hold the message content, termed as payload, as an XML string. If you are sending a request through a client, you fill in the request WSMessage instance with the XML payload and send the request. Multicorn - Unified data access library - Contents. Overview. RestSQL is an open-source, ultra-lightweight data access layer for HTTP clients. restSQL is a persistence framework or engine in the middle tier of a classic three tier architecture: client, application server and database.

Overview

It may also be embedded in any middle-tier as a Java library. Recent news: restSQL version 0.8.13 released on Oct 20, 2018 If you would like to be notified of new releases, please subscribe to our mailing list. What it is an SQL generator with Java and HTTP APIs uses a simple RESTful HTTP API with XML or JSON serialization presents flat or hierarchical views of relational database tables organizes access through query-able and updatable database views called SQL Resources uses declarative authorization offers declarative and plugin mechanisms for implementing domain constraints and business logic a JEE web application or a Java library platform, JEE container and database agnostic What it is Not Where it could be Used Applications needing: Motivation For many apps:

Npgsql Design time support preview available for download! UPDATE2: For some reason, Blogger lost the original post.

Npgsql Design time support preview available for download!

I had to republish it.UPDATE: Jerónimo told me that you must use the Npgsql version which is inside the zip file in order to make it work. After so much time (more than I wanted it to take) Npgsql finally has a initial design time support for Visual Studio! This work was done by Jerónimo Milea. Jerónimo let me know he was working on DDEX support on this thread after I said I was working on DDEX support for Npgsql. He sent me his working copy and I started to play with it. You can download the project file from our downloads page. Open Source Projects. PostgreSQL, the world's most advanced open source database, is a powerful, open source relational database management system that excels at both Online Transaction Processing and Reporting and is the foundation for Server and Postgres Plus Advanced Server.

Open Source Projects

PostgreSQL is a powerful, open source relational database management system and the foundation of the Postgres Plus product suite. It has been in development for more than 20 years and has a strong reputation for excellent architecture and world-class reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX, and Windows. It is fully ACID-compliant and supports foreign keys, joins, views, triggers, stored procedures (in multiple languages), and most SQL92 and SQL99 data types.

It also supports storage of binary large objects, including pictures, sounds, and video. Ten Reasons PostgreSQL is Better Than SQL Server. Why would anyone want to use PostgreSQL instead of SQL Server?

Ten Reasons PostgreSQL is Better Than SQL Server

There are a lot of factors to consider when choosing how to store your data. Sometimes we need to look deeper than the standard choice and consider something new. If you’re starting a brand new project, where should you store your data? Here are ten reasons why you might want to consider PostgreSQL over SQL Server. Releases Every Year Let’s face it, waiting three to five years for new functionality to roll out in any product is painful.

Starting with version 9.0, the PostgreSQL release cycle has switched to a yearly cycle. True Serialization. Top 10 Techniques for Microsoft .NET Framework Database Developers. By Cary Jensen Jensen Data Systems, Inc.

Top 10 Techniques for Microsoft .NET Framework Database Developers

ADO.NET, the data access layer of the Microsoft .NET framework, provides developers with a powerful and rich set of classes and types for building database applications. Unfortunately, for most developers, ADO.NET also requires a radically different approach to database development. For example, a Delphi developer comfortable with the TDataSet API will find few familiar classes and concepts, making the transition to .NET development that much more challenging. This paper is designed to provide you with a collection of useful and interesting techniques designed to make you more productive with ADO.NET. If you are already an ADO.NET developer, you should find several examples here that will inspire you further, giving you additional ways to leverage this powerful environment.