₦airaland Forum

What are the benefits of Postgresql over mysql database?

dueal:
Among the other things your project is about. Folks I refer to are the...Hey, here's a form, fill it, submit and query back.

Hope that's clearer now.

Yeah

dueal:
A key point of #6 is; happen to ONLY be web related CALLING upon an sql database.

Somehow, someone missed that.

details such as user profiles, geospatial data and statistics information are stored in a database

dueal:
Don't classify yourself a programmer if;
1: All you know is the intricacies of a programming language.

2: You have never ventured into any other area but UI's.

3: You don't understand what a tree data structure is and how it relates to a computer file system.

4: Efficiency sounds like an old movie

5: You hate books.

6: The only apps you've ever made happen to only be web related calling upon an sql database.(no offense here)

My thoughts

Hi, I do agree with you 1-5 point, especially 1 because i believe the focus is supposed to be on good architectures and design patterns, but your 6th point of web developers not being programmers is from a limited view. Though i don't deem myself as having arrived but at least I'm working to get better everyday, Take example of a project that I'm working on, it's web based, app that has to do with video streaming which includes a lot of things, some part has to be written in erlang and Go for concurrency issues, I have to extend a queueing system such as RabbitMQ, the app consist of various microservices built in Nodejs talking to themselves. I have to write various algorithms to test the internet capacity of the client and then stream the video resolution as required, adequately handle buffering and many more things which i can't go into detail here.

FrankLampard:
Yes sure, I recently collaborated in building a School Portal, so I was given the task of creating the Rest for the Web Platform. I started writing the REST with Phalcon, but some requirements was changed, so I switched to Laravel.

For me developing RESTful API is more simpler than otherwise.

I have also developed, RESTful services too with Spring Framework, but not on a serious note.

That's cool. You're also good yourself. Keep it up. In btw Have you participated in google codejam or topcoders competition before.

FrankLampard:
Depends on what I'm working on. Generally I use Algorithmic Strategy, when designing an Application.

Do you develop api's (restful webservices)?

May The Good Lord bless your organization for this work. I wl'd love to contribute but i'm n't yet a full fledge android dev.

FrankLampard:
I don't know the category I will place myself that is why I asking.

I'm presently without job, doing freelancing, but the economic crunch is not helping matters.

I have solved 20+ Project Euler questions (Not Sure, I will check). Done few project, not online tho.

Off course, I'm a fan of Design Patterns, I keep security and performance in mind when developing.

I am presently looking for any opportunity.

That's nice. What design patterns do you use?

dhtml18:
I have met quite a number of programmers in Nigeria, yet, I am less than impressed with what I have seen so far. There are awesome ones mind you, and I am opportune to have worked with some of them (some even from Nairaland), but the greater majority are mouth-programmers, while yet a very large percentage are SCAMMERS - who dont even know the ABC of web development.

There are the ones that are HAZARDS to web developers. This thread is not meant to expose anyone sha, I am just RAMBLING.

what is the way forward for our country?

What about you @op tell us about yourself.

Dermie:
Just jump into your Wordpress file directory. As a programmer, you should be able to locate where to edit/add the necessary HTML, CSS and Javascript commands you need your blog/website to follow.

You don't necessarily need to reinvent the wheel, unless Wordpress won't be of help to you. But, once you get comfortable with Wordpress, you can make it function to your taste.

Business-wise that would be very good as you save time and energy. But if your aim is to be a very good software engineer, it would be very detrimental to your growth.

isaanyoha:
Okay... Currently there are two distinct parts of Arena's server: the unrealtime part and realtime part. For the unrealtime it uses Apache tomcat server and for the realtime it uses ejabberd im server (a server writing in erlang) and then I used JavaEE for the backend programming, and MySql for the database.
Is there another thing you wish to know about Arena?
You can read the blog http://arenaapp..com

Thanks!

That's nice. Keep it up.

FrankLampard:
Thanks for your response.

What are the criteria to say you are an intermediate?

Contribute to opensource projects. Able to successfully build apps of a median complexity from scratch to finish using good practises.

DanielTheGeek:
First of all, the title is misleading... I thought you were having issues with SQL queries, it is related to database design.

The second approach seems to be okay but will be messy and costly as you expand if you don't scale, you can use the approach tho. (Not all sites will be as big as Fb, twitter or even Konga).

The best method (I stand to be corrected) would be to add an extra column for the product category then you can easily search for products WHERE product_category = user_input instead of having another table to house the categories. Remember your database has to be flexible and not hard-coded.

That third approach will possible dig the website's grave, funny to even think about it.. Third approach = Slower results (except you add more tweaks here and there)

Try using http://www.dbdesigner.net to visualize your concepts first or check for a previously existing design you can implement.

Exactly, and if you have attributes associated with the category entity, you can create a seperate table for categories and then add a refrence key t products table refrencing the categories table

DharkPoet:
I use the LAMP/WAMP/XAMPP Stack or specifically, Apache, MySQL and PHP. Would I say I love it? I don't have an answer to that, as it's the only Stack I have in my toolbox, so I can only comparison when I venture into another Stack Tech. So far, so good, I've been able to achieve a tangible lot with my current Stack Tech. Although, desiring to try something new like the highly acclaimed MEAN stack.

That's nice, do you have links to any of your projects online

FrankLampard:
How did you learn you current stacks?

How do you learn new concepts? Tutorials or Documentation or more?

What makes one to become an intermediate in a given stack?

what i do is that i pick an idea for a project and then learn all i need for that project. I don't just pick anything to learn without having a need for it. For example what i am currently using to learn NodeJs is to build a livestreaming webapp(which will soon be opensourced). I learn mostly just from Tutorials, Documentation and studing opensource projects. Study and build using good practises.

isaanyoha:
Yes I did

I'm quite impressed, keep it up and we will make Nigeria a giant just like US in the ICT sector. So what tech stack did you use?

Are there no software engineers here?

Disclosure: I'm still on intermediate level. I learn mostly by picking a reading pdfs and reading docs. I rarely use video tutorials.

Did you write the backend code for this yourself?

FrankLampard:
Yes, you can run Node App on shared hosting with heavy tweaking. Some shared hosts even have SSH access nowadays.

Most shared hosts also support Ruby not only PHP.

Ok thanks, I didn't know that. All the same I'm still biased towards Cloud hosting

KvnqPrezo:
Cloud hosting costs?

It's very cheap. Heroku has a free plan that you can start with.

FrankLampard:
You can run any kind of App on shared hosting. It is only on issue of performance and maybe type of database considerations that will make one want to move to vps or dedicated platform or the cloud.

I actually doubt that. Can you run a nodejs or a ruby app on shared hosting?

FrankLampard:
Yes, I agree, but I wanted him to tell me the kind of Apps.

I'm sorry, i thought it was an open question

FrankLampard:
Okay, what kind of App is shared hosting not good for?

shared hosting is very limited. As you grow in software development you would discover that there are times where you may need to setup some things yourself. For example most shared hosting uses apache server while you may need a more performant server like Ngnix. Consider that you were building a social network, then you would need a key-value storage system for stuffs like likes and shares which would make more sense to use a datastore like Redis instead of Mysql when handling much load, then for things like assigning jobs to various web apis workers and ensuring high availability especially while handling things like Picture and Video upload and streaming you would need a queueing system such as RabbitMQ which would be impossible on shared hosting. That's why i always suggest to go with cloud hosting like AWS and Heroku.

emazion:
pls what is nodejs all about?

Nodejs is a framework that let's you run javascript on the server-side.

Mysql is a database. So it's supposed to be php/mysql or Javascript(NodeJs)/any database(most popular would be MongoDb). What to learn and What not to learn depends on your goals. My advice would be to learn all

Since you do web then i assume you know javascript, if yes you can look at phonegap and iconic framework

I'm getting there

KvnqPrezo:
Thanks very much!
.
Would like to know about the to-do list...

it's just a simple web app that allows you to add tasks to do and sorts them based on time and priority

kingofthejungle:
is it possible to use node.js with a relational database like mysql

Yes

KvnqPrezo:
Am learning PHP with w3schools and with some Apps and Ebook.
,
I don't wanna wait till am an expert..
I wanna be working on my project and learning also..,
.
I'm still battling to know what a framework is and how it works... I even researched on bootstrap today but don't know what to use it for...
.
Yes I decided to use PHP because I heard that python hosting is cost..
.
So what's the step!

The step is to breathe deep, be patient and give at least 7 weeks to complete the tutorials you are following in which 3 weeks into the materials you can start working on little side projects like a to-do note app. Think of it this way, if you start now to build your social network when you haven't had a good grasp of your tools. You will spend a VERY LONG TIME on doing the wrong things while if you take your time to learn it the right way you will discover that you would spend a SHORT TIME and doing the right thing. Which do you prefer, to spend 9 months doing wrong stuffs because you didn't have patience to study or to study well and spend just 1 month building it the right way