Monthly Archives: January 2016

NetBeans Plugin for Couchbase Part 2 – Coffee on Couchbase

January 30, 2016couchbasecouchbase, netbeansarungupta

This is part 2 (part 1) of Coffee on Couchbase series where we will build a NetBeans plugin for Couchbase. This multi-part webinar series is a discussion with Geertjan Wielenga (@GeertjanW) and Eben Haber (@ebenhaber).

As part of this series, you’ll also learn how to build a NetBeans plugin from scratch and learn the awesomeness behind NetBeans platform.

The recording from part 2 is now available:

Unfortunately, Geertjan’s voice is not correctly captured in this one!

Part 2 covers:

Show NetBeans users how to install Couchbase and configure it with a sample bucket
Run a simple Java EE application that queries the documents stored in Couchbase sample bucket
Migrating the NetBeans plugin from Ant to Maven
Show a message in popup help menu
Double clicking on the Couchbase node connects to Couchbase server and displays a message in status window

All the code is evolving at: github.com/arun-gupta/couchbase-netbeans-plugin.

For now, the plugin can be built and reloaded in a new or current instance of NetBeans. You’ll see:

Let us know by filing bugs on features that you’d like to see in this plugin.

Enjoy!

Couchbase Weekly Jan 25, 2016

January 26, 2016couchbasecouchbase, weeklyarungupta

Starting a new weekly blog to share all the cool things that are happening in the Couchbase Community.

Let us know if we missed anything at @couchbasedev, @couchbase or #Couchbase.

Transition from Relational to NoSQL

January 28: Moving from Relational to NoSQL: How to Get Started (EMEA)
January 28: Moving from Relational to NoSQL: How to Get Started (US)

News

InfoQ: Getting Ready for IoT’s Big Data Challenges with Couchbase Mobile
TechBeacon: Mobile Dev 2016: Hot Technologies, Dangerous Assumptions
ComputerWeekly (UK): Take Care When Reaping Rewards of Open Source
DZone: JSON Gene in SQL: How SQL Extensions are Helping SQL Adapt to Flexibility of JSON
Globes (Israel): Israel’s Redis Labs Rides the Database Wave
DZone: Contributing to Open Source Projects and Code
DZone: A Primer on Open-Source NoSQL Databases
IoT Journal: IoT News Roundup
EnterpriseTech: How NoSQL Maximizes Hardware and Enables Scale like We’ve Never Seen
Application Development Trends: Oracle Named DBMS of the Year 2015
DZone: Query JSON Using SQL with Couchbase Query Workbench
Information Management: Data in 2016: 10 Shocking & Surprising Takes

Blogs

Moving SQL database content to Couchbase — Laurent Doguin
PowerBI & Couchbase Server 4 – Reporting over JSON Data with native connectivity through N1QL REST API — Cihan Biyikoglu
JSON+SQL: How SQL Extensions are Helping SQL Adapt to Flexibility of JSON — Cihan Biyikoglu
How to Authorize Users in Sync Gateway— William Hoang
Create an AngularJS Web Application that Sync’s with Couchbase using PouchDB — Nic Raboy
NetBeans Plugin for Couchbase Part 1 – Coffee on Couchbase — Arun Gupta
NDP Episode #1: NoSQL in the Perspective of Industry Leaders — Nic Raboy
Couchbase and Apache CouchDB compared — Matthew Revell
How to: Create a copy of your bucket with a single statement. — Cihan Biyikoglu
Augment your Sync Function with Roles in Couchbase Sync Gateway — James Nocentini
Couchbase .NET SDK 2.2.4 now Available! — Jeff Morris
Test the Latest Couchbase Features with a Docker Image — Laurent Doguin
Query JSON using SQL with Couchbase Query Workbench – Coffee on Couchbase — Arun Gupta
Dealing with cultural divide and advocating your team internally at NDC London — Laura Czajkowski
Storing Blobs in Couchbase for Content Management — Cecile Le Pape

Upcoming Events

January 30 – 31: FOSDEM, Belgium
February 4: Couchbase Day Santa Monica
February 8 – 10: Jfokus, Stockholm
Feb 15 – 17: DevNexus, Atlanta
February 18: Couchbase Day Seattle
February 18: Couchbase Day Reston

Webinars

January 28: Moving from Relational to NoSQL: How to Get Started (EMEA)
January 28: Moving from Relational to NoSQL: How to Get Started (US)

Couchbase Meetups

January 27: Couchbase Meetup — Paris

Other People Meetups (OPMs)

February 10: JavaMug, Dallas
February 12: UmeJUG, Sweden

Learn how Amadeus, Google and Couchbase took on the 1,500 cores challenge across 3 data centers http://ow.ly/XtUkP
Only #Couchbase can support the complexity and scale of today’s #BigData. Learn why enterprises are moving off RDBMS http://ow.ly/XcMJB
#Couchbase is hiring — join the team and transform the #database world. #BigData #NoSQL #Startup: http://ow.ly/WYBpp
Enterprise #NoSQL adoption is growing & companies are paying great salaries to #developers that know #Couchbase: http://ow.ly/WLqqr
Discover how #Couchbase will disrupt #BigData in 2016 – more enterprises are replatforming their systems to #NoSQL http://ow.ly/WCXDr

Originally posted at: blog.couchbase.com/2016/january/couchbase-weekly-jan25-2016

20 Ways to Connect with Couchbase Community

January 25, 2016couchbasecouchbasearungupta

Couchbase Community is growing and thriving well. There are many ways to connect, learn, engage, and meet with them.

Ask your questions
- Couchbase Forums
- Stack Overflow – couchbase, couchbase-lite, n1ql
Learn
- Developer Portal
- Webinars
- Virtual and In-class training
- blog.couchbase.com
- Couchbase Community Newsletter
Engage
- @couchbasedev and @couchbase
- #Couchbase
- Gitter
- Contribute Code
- File issues
Meet and Learn
- Couchbase Meetups
- Couchbase Days
- Events & Conferences
People around the world
- Couchbase Experts & Champions
- Couchbase Partners

What is your preferred means of connecting with the Couchbase Community?

Are there any other places where you’d like to see us?

NetBeans Plugin for Couchbase Plugin Part 1 – Coffee on Couchbase

January 15, 2016couchbasecouchbase, netbeans, pluginarungupta

NetBeans simplified out-of-the-box experience is really nice and intuitive. That’s why it continues to be my favorite IDE!

This morning started a new Coffee on Couchbase webinar series. It will build a NetBeans plugin for Couchbase. This multi-part webinar series is going to be a discussion with Geertjan Wielenga (@GeertjanW, my esteemed friend and NetBeans PM) and Eben Haber (@ebenhaber, Couchbase Tooling Architect).

As part of this series, you’ll also learn how to build a NetBeans plugin from scratch and learn the awesomeness behind NetBeans platform.

The recording from part 1 is now available:

Part 1 covers:

GitHub repository for the plugin
Started a new NetBeans plugin – discussed Ant vs Maven approach for starting a plugin
Couchbase node configured in NetBeans

All the code is evolving at: github.com/arun-gupta/couchbase-netbeans-plugin.

For now, the plugin can be built and reloaded in a new or current instance of NetBeans. You’ll see:

NBMs will be released going further.

Let us know by filing bugs on features that you’d like to see in this plugin.

Enjoy!

Query JSON using SQL with Couchbase Query Workbench – Coffee on Couchbase

January 11, 2016couchbasecouchbase, json, n1ql, nosql, sqlarungupta

You’d like to query JSON document database using SQL-like syntax?

Couchbase has N1QL for you.

N1QL is a declarative query language that extends SQL for JSON. You can query data via native framework and language integration, a fluent API, or the JDBC/ODBC drivers.

N1QL enables you to query JSON documents without any limitations – sort, filter, transform, group, and combine data with a single query. That’s right. You can combine data from multiple documents with a JOIN. That flexible data model you were promised? This is it. You’re no longer limited to “single table” and “table per query” data models.

N1QL Tutorial is a great resource to learn the concepts of querying JSON documents using SQL-like syntax. Here are some examples:

SELECT children[0].fname AS cname
    FROM tutorial
       WHERE fname='Dave'

SELECT children[0].fname AS cname

FROM tutorial

WHERE fname='Dave'

SELECT fname, age, age/7 AS age_dog_years 
    FROM tutorial 
        WHERE fname = 'Dave'

SELECT fname, age, age/7 AS age_dog_years

FROM tutorial

WHERE fname = 'Dave'

SELECT relation, COUNT(*) AS count
    FROM tutorial
        GROUP BY relation
            HAVING COUNT(*) > 1

SELECT relation, COUNT(*) AS count

FROM tutorial

GROUP BY relation

HAVING COUNT(*) > 1

SELECT t.relation, COUNT(*) AS count, AVG(c.age) AS avg_age
    FROM tutorial t
    UNNEST t.children c
    WHERE c.age > 10
    GROUP BY t.relation
    HAVING COUNT(*) > 1
    ORDER BY avg_age DESC
    LIMIT 1 OFFSET 1

SELECT t.relation, COUNT(*) AS count, AVG(c.age) AS avg_age

FROM tutorial t

UNNEST t.children c

WHERE c.age > 10

GROUP BY t.relation

HAVING COUNT(*) > 1

ORDER BY avg_age DESC

LIMIT 1 OFFSET 1

SELECT
product.name, 
COUNT(reviews) AS reviewCount,
ROUND(AVG(reviews.rating),1) AS AvgRating,
category 
 FROM reviews AS reviews
JOIN product AS product 
 ON KEYS reviews.productId
UNNEST product.categories AS category
WHERE category = "Appliances"
GROUP BY category, product
ORDER BY AvgRating 
DESC LIMIT 3

SELECT

product.name,

COUNT(reviews) AS reviewCount,

ROUND(AVG(reviews.rating),1) AS AvgRating,

Couchbase Cloud Recipes – Pick your favorite!

January 1, 2016couchbaseamazon, azure, bigstep, couchbase, digitalocean, docker, jelastic, joyent, kubernetes, openshift, vagrantarungupta

Couchbase 4.x Quick Installation provide instructions to install Couchbase on your local machine.

Would you like to run Couchbase 4.x in cloud? There are plenty of recipes available!

Looking for detailed instructions on Couchbase Cloud Recipes?

Digital Ocean
Jelastic
OpenShift
Docker
BigStep
Vagrant
Kubernetes
Joyent Triton
Amazon Web Services
Microsoft Azure
CoreOS and Kubernetes

Read more about it in Couchbase Cloud Deployments. Are there any other cloud/hosting solution where you you would like to see Couchbase running? Did I miss one where Couchbase already runs?

How is your experience of running Couchbase in the cloud?

Couchbase partners provide a complete list of partners.

As always, talk to us using StackOverflow or Forums.

Miles to go 4.0 …

Arun Gupta is a technology enthusiast, avid runner, author of a best-selling book, globe trotter, a community guy, Java Champion, JavaOne Rockstar, JUG Leader, Minecraft Modder, NetBeans Dream Teamer, Devoxx4Kids-er, Docker Captain and works at AWS.

Monthly Archives: January 2016

NetBeans Plugin for Couchbase Part 2 – Coffee on Couchbase

Couchbase Weekly Jan 25, 2016

Transition from Relational to NoSQL

News

Blogs

Upcoming Events

Webinars

Couchbase Meetups

Other People Meetups (OPMs)

20 Ways to Connect with Couchbase Community

NetBeans Plugin for Couchbase Plugin Part 1 – Coffee on Couchbase

Query JSON using SQL with Couchbase Query Workbench – Coffee on Couchbase

Couchbase Cloud Recipes – Pick your favorite!