yuusaku

if not SQL, then NoSQL?

回復 4# rainbow-davie

et1984

Ya, but think in real application, they should not be FK to the same address 'cause what if o ...
ACC-HE 發表於 2012-2-10 17:19

    oh ya true!!!! ah ha!

et1984

In real application, it's 1:M.
Prelude 發表於 2012-2-10 17:15

    but as ACC-HE said...it does make sense though

et1984

if not SQL, then NoSQL?

回復  rainbow-davie
yuusaku 發表於 2012-2-10 18:50

haha...but anyways I'm still studying the I guess this is still called the theory part.  SQL starts next week but I have a project to hand  in

rainbow-davie

if not SQL, then NoSQL?

回復  rainbow-davie
yuusaku 發表於 2012-2-10 18:50

yes.. I'm using Mongo in few projects since a year ago.  Also looking into other NoSQL db.    and using node.js   

I already left SQL and php. LAMP is a past tense for me.  and I love the new technology.  It is extremely good for web development.

yuusaku

I've been looking into NoSQL out there, the one that I've paid attention the most is Cassandra, it was covered by quite a few sessions in a java seminar(NFJS)

the dba is still insisting that eventually-consitent won't fit our need, we are still stuck with rdbms so far.  and we need to tackle the scalability issue sooner rather than later

regarding node js, how do you like it so far? do you use library like socket io?

yes.. I'm using Mongo in few projects since a year ago.  Also looking into other NoSQL db.    an ...
rainbow-davie 發表於 2012-2-12 02:00

rainbow-davie

Cassandra is good when you work with multiple data centre.  however, the set up is not easy.  

Of course your DBA will say it.  Job security!! NoSQL doesn't require a DBA.  
for example, in my team, senior engineer (like me) can already handle the data design and programming (actually, it is inside the application already).   The infrastructure is handled by hardward Operation guy.   So, we don't need DBA to handle schema or normalizing DB.  lol   DBA is expensive~~~   oh. and scaling can be done by ops guy easily.  I can also do that too.  

Scale in rdbm is tough.  Vertical scaling is expensive in hardware.  Horizontal scaling is fxxking complicate and easily to crash.  

When I first use Mongo and node.js, my other coworkers have doubt but now, they like Mongo.   And I'm bringing people to try node.js.      

I recommend you to find a small (very small) project to use in your company.  more like caching json data, etc. and try with Mongo. of course, the project is best to be small in scope but high in traffic.   Then your PM will be impressed.   

I had a launch last year Oct and other PHP servers (15) were over 100% , and MySQL DB servers were crazy.  But my 5 node.js servers and a simple replicated MongoDB just sitting calm with no more than 40% usage.

i have done tones of load testing with Node & mongo, and I am very impressed by the performance and the non-blocking nature.

Well. nodejs.   I love it.  No more php.  Of course, doing node is very easily to start, but then tough to master it. Once you master it, it is very easy.   The challenge I find is that, instead of sequential programming, you have to think in Event & callback way.  Very careful in async nature.   Also, node.js is not for junior. You have to have understanding of web technologies and know what you are doing.   no lazy programming.  

I use tones of library...except socket.io.  haahh but I will use it soon.  Expressjs is a must to use.  I also recommend you to join the node.js facebook or google+ group.  

for mongo, recommend you to join any meet up nearby.  I went to the one in Seattle last year.  It was good, You will have directly contact with the Mongo creator and engineer.


Trust me or not... Node + Mongo will be the key technology for web development in next 3-5 years.

yuusaku

My company is still having similar stack like LAMP for front end, replaced MySQL with Postgres, on top of that, there is a memcache in front of it, for the http sessions.  We have been thinking to upgrade the PHP4 to 5, but new features always go higher priority than the system tasks.  We also tried Symfony, but I feel that it defeated the purpose of interpreted language like PHP, since it requires compiling.  

I am a senior developer on the back end team, my duty involves migrating from J2EE 1.4 to Spring and addressing scalability.  Recently we are looking into supporting push, desktop browser and mobile browser, unfortunately only the minority of browsers can do web socket yet.  From the prototyping we did on socket.io, it really impresses me that it supports the latest web socket, flash, long comet, or periodic ajax.  

I've been doing a lot integration across system using non-blocking events listener/callback/messaging, but don't deal them much at code level, like node.js.  

For the prototyping of node.js+socket.io, I'm trying to hook it up to ActiveMQ, if that works well...I can foresee that could greatly reduce our DB hit than our existing periodic ajax polling...

Alright, no more hi jacking this thread

Glad to see another LYK is in the same sector

rainbow-davie

By the way yuusaku, you can look into npmjs  for node package or github for any lib that can help you on ActiveMQ.

yuusaku

yup, npm is pretty handy, and i'm following the tutorial on express:

http://expressjs.com/screencasts.html