Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 5

Displaying posts with tag: crud (reset)

MySQL Document Store -- The NoSQL Zipcodes
Employee +1 Vote Up -0Vote Down

The MySQL Document Store functionality allows developers to use a relation database with or without SQL (structured Query Language), also known as NoSQL. The example in this blog is hopefully a simple look at this new feature of MySQL. The example data used is from JSONStudio.com and is a JSON formatted data set for US zip (postal) codes (656K compressed). So download your copy of this data set and lets get to work.

Create a collectionCollections are tables and below we create a collection name 'zip' in the test database in the …

  [Read more...]
Is the new MySQL Document Store and JSON data type cheating?
Employee +1 Vote Up -0Vote Down

Is it cheating? Is using MySQL without Structured Query Language (SQL) or putting all your data into one column proper? Impossible a year ago and probably thought as a poor/crazy practice until recently, this is a new type of MySQL usage. NoSQL has had a big impact in the SQL world with several relational products from vendors like MySQL, Microsoft, Postgresql and others offering NoSQL interfaces and JSON data types to their databases.

Several old timers have come to me asking if putting lots of data in a JSON column is cheating? After all data normalization is part of relational databases and the way to efficiency and speed is well …

  [Read more...]
Performing Inserts, Updates, and Deletes (CRUD)
Employee +0 Vote Up -0Vote Down

Hi all,

Today I'd like to continue a blog series in which I highlight Web application tutorials for NetBeans 6.5. A few changes have been made to tutorials, among which is the featuring of MySQL as the database of choice.

This sixth entry in the series will cover the tutorial, "Performing Inserts, Updates, and Deletes (CRUD)".

This tutorial shows you how to use NetBeans IDE 6.5 and JSF 1.2 (Woodstock) components to build a web application that can create, retrieve, update, and delete database rows. The application …

  [Read more...]
Building a Tree From Database Data
Employee +0 Vote Up -0Vote Down

Hi all,

Today I'd like to continue a blog series in which I highlight Web application tutorials for NetBeans 6.5. A few changes have been made to tutorials, among which is the featuring of MySQL as the database of choice.

This fifth entry in the series will cover the tutorial, "Building a Tree From Database Data".

This tutorial shows you how to dynamically build a tree structure from data in a database. Using NetBeans IDE 6.5, you build a two-page application, the first page of which includes a JSF 1.2 (Woodstock) Tree component. You …

  [Read more...]
Using Databound Components to Access a Database
Employee +0 Vote Up -0Vote Down

Hi all,

Today I'd like to continue a blog series in which I highlight Web application tutorials for NetBeans 6.5. A few changes have been made to tutorials, among which is the featuring of MySQL as the database of choice.

This fourth entry in the series will cover the tutorial, "Using Databound Components to Access a Database".

In this tutorial, you use NetBeans IDE 6.5 to create and deploy a web application that displays master-detail data from a database that is packaged with the IDE. In the application, you select a person …

  [Read more...]
Showing entries 1 to 5

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.