₦airaland Forum

dhtml18:
[s]Even trolls (like me) avoid topics like this for obvious reasons.[/s]
Somebody like dhtml18 needs to break the ice before other commenters can talk. . . .but alas, my goat has gone missing again

I see, you mean without your goat you are not contributing?

Wow, its so unusual for all to avoid this topic or is it that we no longer use database in our project.

Nmeri17:
Oga I need your help on some small stuff abeg. How can I reach you? Guru01 if you're free please indicate. Simple Ajax stuff

Can't use nl pm, email me josiahaccounts x gmail.com
Replace the x with @

Nmeri17:
Oga I need your help on some small stuff abeg. How can I reach you? Guru01 if you're free please indicate. Simple Ajax stuff

Oh yes am free.

If you are happy with the performance, scalability, and high availability of your current traditional SQL database system (the likes of Oracle, SQL Server, MySQL), then there is no reason to read further. However, if you have growing pains in any of these areas, then a NoSQL or NewSQL offering may be right for you. So how do you choose between them?

Choosing the right tool for the job at hand is 80% of getting to a solution; the other 20% is really understanding the problem you’re trying to solve. Here’s a rundown of the advantages and disadvantages of traditional SQL databases (affectionately called OldSQL in this article), NoSQL and NewSQL that can help you focus your data store choices.

OLDSQL

Traditional SQL databases have been around for decades and serve as the core foundation of nearly every application we use today. If you have a deployed application and it is behaving and performing acceptably, that is fantastic; there is no need to change your data store. Realize that porting or replacing your database not only introduces work, it introduces risk. It is rare that a database replacement candidate is feature-for-feature, as well as bug-for-bug, compatible with the database you are replacing. Beware any vendor who suggests otherwise! Here are some of the typical patterns of a traditional database application:

THE OLDSQL ADVANTAGES:

Proven disk-based database technology and standard SQL support, hardened over several decades.
Compatible with ORM layers, such as Hibernate or ActiveRecord.
Rich client-side transactions.
Ad hoc query and reporting.
An established market and ecosystem with vast amounts of standards-based tooling.
THE OLDSQL DISADVANTAGES:

Not a scale-out architecture. Transactional throughput is often gated by the capacity of a single machine. Scaling out requires application-defined and managed sharding (or partitioning) of the data.
Traditional SQL systems were built for “one size fits all.” They are good for general purpose applications with modest performance requirements, but struggle as needs grow.
Complex tuning parameters often require deep expertise to get the best balance between performance, data safety, and resource use.
NOSQL

First, realize that the term NoSQL is about as descriptive as categorizing dogs and horses as “NoCats”. In truth, NoSQL is a broad category collecting disparate technologies beneath an ambiguous umbrella. The term offers little help to the developer trying to decide on the right tool for the right job.

So let’s break it down with an eye on what we really care about as software engineers: what problems can I solve with NoSQL? Equally important, where is NoSQL a bad fit? Where do the different technologies show their strengths?

SOME NOSQL SYSTEMS PUT AVAILABILITY FIRST

Say you have gigabytes to petabytes of data. New data is added regularly and, once added, is relatively static. A database that archives sensor readings or ad impression displays is a good example. You want to store this in a cloud and are willing to tolerate the programming challenges of eventual consistency (made easier because most updates are idempotent anyway) for distributed access, multi-datacenter replication, and the highest possible availability.

Your application-to-database interactions are simple “CREATE” and “GET” patterns that don’t require traditional transactions. The most important consideration is that the database is always available to accept new content and can always provide content when queried, even if that content is not the most recent version written. Such systems include DynamoDB, Riak and Cassandra.

SOME NOSQL SYSTEMS FOCUS ON FLEXIBILITY

Made famous by MongoDB and CouchDB, the Document Model expands upon the traditional key-value store by replacing the values with JSON-structured documents, each able to contain sub-keys and sub-values, arrays of value, or hierarchies of all of the above. Often described as schemaless, these systems don’t enforce premeditated or consistent schema across all of the stored documents. This makes managing schema different… less rigid, but also much messier. It is likely the benefits of this approach are more applicable for smaller development teams with simpler data needs.

Other systems expand upon key-value stores with organizational features. Redis is popular for creating many sorted lists of data for easy ranking and leaderboards. By adding more complex functions to order by and computer statistics on, its focus allows for functionality key to its specific use cases.

SOME NOSQL SYSTEMS FOCUS ON ALTERNATIVE DATA MODELS OR SPECIAL USE CASES

The most common examples are systems tuned for graph processing, such as Neo4j. Array databases are another such example; SciDB uses Python and R to access MPP array data for scientific research. Accumulo is a variation on the wide-column-store model popularized by Cassandra and BigTable, but with a focus on cell-level security. Systems like etcd are distributed datastores with a focus on storing configuration data for other services. Elasticsearch is a popular system for implementing text search within applications.

THE NOSQL ADVANTAGES:

Eventual-consistency algorithms allow implementations to deliver the highest availability across multiple data centers.
Eventual-consistency based systems scale update workloads better than traditional
OLAP RDBMs, while also scaling to very large datasets.
Many NoSQL systems are optimized to support non-relational data, such as log messages, XML and JSON documents, as well as unstructured documents, allowing you to skip specifying schema-on-write, and allowing you to specify a schema-on-read.
THE NOSQL DISADVANTAGES:

These systems are fundamentally not transactional (ACID). If they advertise otherwise, beware the over-reaching claim.
OLAP-style queries require a lot of application code. While the write-scaling advantages are appealing vs. OLAP stores (such as Vertica or GreenPlum), you sacrifice declarative ad hoc queries – important to historical analytical exploration.
NEWSQL

The term NewSQL is not quite as broad as NoSQL. NewSQL systems all start with the relational data model and the SQL query language, and they all try to address some of the same sorts of scalability, inflexibility or lack-of-focus that has driven the NoSQL movement. Many offer stronger consistency guarantees.

But within this group there are many differences. HANA was created to be a business reporting powerhouse that could also handle a modest transactional workload, a perfect fit for SAP deployments. Hekaton adds sophisticated in-memory processing to the more traditional Microsoft SQL Server. Both systems are non-clustering for now, and both are designed to replace or enhance OldSQL deployments directly.

NuoDB set out to be a cluster-first SQL database with a focus on cloud-ops: run on many nodes across many datacenters and let the underlying system manage data locality and consistency for you. This comes at a cost in performance and consistency for arbitrary workloads. For workloads that are closer to key-value, global data management is a more tractable problem. NuoDB is the closest to being called eventually consistent of the NewSQL systems.

Other systems focus on clustered analytics, such as MemSQL. Distributed, with MySQL compatibility, MemSQL often offers faster OLAP analytics than all-in-one OldSQL systems, with higher concurrency and the ability to update data as it’s being analyzed.

VoltDB, the most mature of these systems, combines streaming analytics, strong ACID guarantees and native clustering. This allows VoltDB to be the system-of-record for data-intensive applications, while offering an integrated high-throughput, low-latency ingestion engine. It’s a great choice for policy enforcement, fraud/anomaly detection, or other fast-decisioning apps.

THE NEED FOR SPEED: FAST IN-MEMORY SQL

Perhaps you have gigabytes to terabytes of data that needs high-speed transactional access. You have an incoming event stream (think sensors, mobile phones, network access points) and need per-event transactions to compute responses and analytics in real time. Your problem follows a pattern of “ingest, analyze, decide,” where the analytics and the decisions must be calculated per-request and not post-hoc in batch processing. NewSQL systems that offer the scale of NoSQL with stronger consistency may be the right choice.

THE NEWSQL ADVANTAGES:

Minimize application complexity stronger consistency and often full transactional support.
Familiar SQL and standard tooling.
Richer analytics leveraging SQL and extensions.
Many systems offer NoSQL-style clustering with more traditional data and query models.
THE NEWSQL DISADVANTAGES:

No NewSQL systems are as general-purpose as traditional SQL systems set out to be.
In-memory architectures may be inappropriate for volumes exceeding a few terabytes.
Offers only partial access to the rich tooling of traditional SQL systems.
SUMMING IT UP

As a general rule of thumb, consider evaluating NoSQL offerings if you favor availability or have special data model needs. Consider NewSQL if you’d like the at-scale speed of NoSQL, but with stronger consistency and the familiar and powerful SQL query language.

The froth in the data management space is substantial – and our tendency to talk in terms of categories (SQL, NoSQL, NewSQL) vs. problems makes it hard for software developers to understand what’s in the toolbox. The current offerings of new databases are not all alike – and recognizing how the DNA behind each helps or hinders problem solvers is the key to choosing the best solution.

dhtml18:
*Spreads mat* waiting for the maestros. . .

Your experience is highly required.

Raypawer:
hmm, this one oga d spread mat,



I have a superb experience using MSSQL, but in case of a realtime app, going mean ( Mongo, Express, Angular, Node) is the way, as it spreads json all round, The none relational way of Mongo is amazing though hav not created any personal app with mongo

Thanks for your response, but its better you tell us what you know base on experience.
I like to know more about mssql. Can it be used with other language effectively (without limitation) and not just .net product.
How many thousand rows has your app gotten to so far, and how well does it perform.

God bless Nigeria.

Eze is not a criminal, he is a decent man.
#istandwitheze

This police man is not truthful.
These guys have been operating in that area for years now. Its not a new thing, them and the govt forces there are pals.

dhtml18:
And i hereby add that the aforementioned individual is responsible for his actions and whatever the e-counsequences of his actions may lead to.
In event of an e-war, dhtml18 claims not claim responsibility (and might resign immediately from being the master troll of nairaland programming).

Are you trying to create an e-war between .net and yourself?

pcguru1:
I will be honest i have only used SQL Server and MySQL and no experience with NoSQL so i don't really know the criteria for picking NoSQL it's hard for me to think in a non-relational relationship i guess.

Share your experience with sql.

@dhtml18
@pcguru1
@fincoapps
@raypawer
@javanian
@fulaman198
@dgurudoer
@fatimahzahra

refiner:
Please vote for me for miss Nairaland

I will vote for you if you tell me the difference between these technologies.

Hello masters and administrators of Database, please share your experience with these technologies for others to learn and make the right choice when shopping for database to use in developing various type of app.

If you are buying old emails you have to tell them what you plan to do with their email address which also contains other personal details.
Haven't you heard of privacy policy?

Learn both alongside.

@dhtml18 it seems you have found your goat.

I am officially closing the topic. No trolling pls.
Long live PHP, Java, C++, JavaScript, HTML5, Python.

This is fraud.
This is fraud.
You want to use the email for Yahoo yahoo abi.
Those who sell their old email address, also note that you are as well selling your contact details.

My best games are racing game.

dhtml18:
^^^Yes o, i agree. he is the PHP troll in this section. Me, i don divert to NOSQL things

This is not the discussion.

Scholar01:
But Baba guru01 nawa for you sef. You don too tey for this programming section to still be championing this PHP matter. Most of the folks wey be your mates for this section have since moved on to other technologies. Time to move on Bro

Move on to what?
And who said I don't know other technologies?

Hey guys take a view on some of this resources.
https://blog.famzah.net/2016/02/09/cpp-vs-python-vs-perl-vs-php-performance-benchmark-2016/

http://www.tiobe.com/tiobe_index?page=index

https://www.sitepoint.com/php-vs-ruby-lets-all-just-get-along/

http://1stwebdesigner.com/php-vs-ruby-vs-python/

https://benchmarksgame.alioth.debian.org/u64q/php.html

Also go through their comments.

FincoApps:
Lol not language...
More like mobile platform: BlackBerry.... but I'm recovering

Ok, I developed some mobile apps for bb 5/6/7 platforms. It was an amazing experience.

C++ is a low level language which java is the opposite.
C++ is good for building network app, cmd app, console games, etc
Java app can run on all platforms where JVM is present.

FincoApps:
hahaha exactly.

That same stuff of getting seriously hooked to a language or platform has happened to me too before

What language were you hooked to?

Raypawer:
can i shock you? wordpress is moving to javascript

You are a learner and a liar. Automatic is developing a new product on JavaScript called calypso.

omoelu1:
All these one na just story.
Php, java, whatever. Just use what ever you're comfortable with and gets the job done.
The reason for Google's success is not because it uses python or Java, Neither is facebook's success dependent on it's usage of PHP.

We are not talking about using whatever tools here, everybody knows that using whatever tools that get the job done fast is best.

jennyff:
So it hurts huunnn Am new here and I went over post in this section seeing you everywhere derailing serious threads. People would come looking for help, but you derail with some childish posts. I don't know you and don't care who you are, just thought, let me try on your thread to see how it feels. And guess it hurts, Please grow up.

And by the way, I saw you have something Africod, please know that ur site won't grow by killing nairaland's programming section. Black and flat heads mentality, I know you be one.

Let the e-fight begin.

dhtml18:
All i see is:



This is part of the thing we talk about, wordpress has been disgracing PHP since 1961.

Now how do i cross level 50 of candy crush saga? any takers?

So you are playing woman game, when real men are playing cok or mine craft.

Jregz:
WordPress is one of the projects giving php a bad name... It should die ASAP :facepalm;

True talk, that the result automatic is rewriting their wp admin in js.