₦airaland Forum

@Syma

I just wanted to note, since gender is either Male or female, why not use M/F i.e. char(1). Or, even why not use a bit field i.e. int(1) ? Just a thot ,

@my2cents
I'm not quite sure i know if there is a difference between char and varchar

I normally use ENUM for gender. Is Char better than this?


Also, I don't know when to use a foreign key. The database seems quite OK by letting the tables work or get updated individually.

Is this a bad practice?

Also, I don't use "join" when fetching data from multiple tables. I use lots of "And" instead.

Is this a bad practice?

Bossman:
I agree. char would be more appropriate for gender.

The char is a fixed-length character data type, the varchar is a
variable-length character data type.

Because char is a fixed-length data type, the storage size of the char
value is equal to the maximum size for this column. Because varchar is
a variable-length data type, the storage size of the varchar value is
the actual length of the data entered, not the maximum size for this
column.

For example a char varChar will always take up 4 spaces to store the name Mike. While a char(20) will always take up 20 spaces to store the same thing,

Well, I launched my first website on January 3 with a Nigeria host whose link I found here on nairaland.


The host seem good and I'm hoping to host another website with them soon.

Though they have changed server like two times.

They sent me a mail onetime like that that the server my website is hosted on is having issues (although the website was online) and they will migrate it to a new server which they did.

But the new server had direct admin panel and not popular ones like c panel and softaculous.

They later sent me another mail that they will migrate the site to c panels due to complaints from other users(I didn't complain since their support helped me find my way around direct admin panel and as a programmer, I easily understand my way around)

After this mail, they migrated the site to c panel although some php includes file become missing.

In short, I have used 3 different admin panel in the few months of hosting with them.



Apart from this, they are good and have a good support(although this might be based on the fact that they are not popular yet.)

Well, I'm working on some other projects and I plan to host them in Nigeria here.


Just the way we have bad hosts in Nigeria, that might have disappointed some people, we have the good ones as well.

And we also have bad foreign hosts. The same host some people are suggesting to you above is the same host some other people will urge you to run away from.


But its good to support Nigerian owned businesses.

Well, I guess poor or poorly dressed people don't abuse drugs.

Looks more like a party.


My views though.

Well.

What's the exact error you are getting?

gentlegenius:
I lost every hope in buhari's administration when I begin to notice his desperation to perpetuate himself in office. #powerdrunkleaders.

How can buhari budget 242 billion Naira for election??. When we know too well that his desperation to remain in power will override the fairness of the election.

Nigeria population is approximately 180 million.

Abeg We don't want election in 2019 again. Buhari pls Just share the money, 1.344m for each person, and continue your second tenure...

If you are with me pls Share...�

Do your calculation again, this time with a calculator.

DualCore1:
It came to my address.


Its the fastest way to withdraw your funds if you work as a remote developer on freelance sites or for employers who pay your through the freelancer sites.

Hi.

Do you receive a phone call before it gets delivered to you at home?

and do you know if someone can get it on one's behalf?

Facebook are doing everything possible to stay relevant in the social media market.

Azmodan:
So this guy couldn't buy data ?

He is using Facebook on free basics ?

Open your eyes

flexyrule:
What about BMC?

I kinda see that abbreviation here alot.

Buhari media crew

1 year plus wasted. Its good they were recalled though.


[quote author= post=69941334]Good judgement.
Give it up for Barrister Wisdom![/quote]They settled out of court. You can't classify it as "good judgement"

Iphone to is sold out

I just rechecked, the system has appeared but sold out

Bills2307:
I don’t think it’s restricted only to their app alone. Their thunder still Dey Borno Dey come..

You're right. I downloaded their app after this guys post

bamac:
It is better to use the app.

Also, you can only use category to filter, othes will not work for such promo.

There's nothing related to the treasure in that price range and that section.


Plus, the only one i have seen so far which is about or days ago(The Iphone), i actually saw it in a browser with the price filter, and its sold out already.

Bills2307:
I had to scroll ND scroll ND scroll and DOZED off. How can someone scroll down up to 50000 items in search one iPhone or washing machine. I had to filter, still no avail! I don delete the app. This thing requires time

Lol. what i simply do is type the price in the price filter. like 500-500. sort by newest in.

But i'm kind of believing the thing is scam.

They asked us to check for PC in men's shoe section between 10AM to 12PM. Its almost 1 already, nothing's up.

The same thing happened for yesterday's PS4.

I'm actually using a system to check. Is the product restricted to their app alone?

mrphysics:
1. Remove the image there, doesn't look professional. Replace it with an image of yours where you are wearing some smiles, or design a circular logo with short description of what you do.

2. Take your time to write your profile description.

3. You render some conflicting services. If you are doing data entry do it, if you are into programming, then do that. Don't join the two together.

3. In your skills, you didn't add some SEO skills. I can see physics and other skills that are not related to the service you render. Go through gigs of same service, check what they use as their skills, if you have it, kindly replace it with yours.

4. Go to your section, on the front page, you will see level one seller's gig on front page. Check their search tag, just below their reviews, and add it to yours to boost your ranking.

Take time to set your gig up.

Goodluck bro and happy selling.

Thanks bro.

mrphysics:
I went through your gig and it's clear you didn't set your account well.

1. You have only one gig which you offer basic services only. Create more gigs and use the basic, standard, and premium gig level. There's a Nigerian who is a Top Rated Seller in that your niche, his name is ollydave. Go through his gigs and see how you can improve account.

2. Your profile isn't well written. I have Passion for Designing, Animating and Editing
i have good experience in whiteboard animation, 2d animation,
Am also a Full stack Developer in an Advertising Agency. This is not well written. This is what buyers see when they visit your fiverr page.

3. You rushed your gig description. It isn't catchy. If you are not a writer, you can use the service on one on nairaland and get yourself a well written profile and gig description. Fiverr is a money making website, therefore, before you start, you must be prepared because the competition is so high. You don't seem to come prepared for the competition therein.

4. Create more gigs.

Please, help me review my profile https://www.fiverr.com/oloriirephilip


I get lots of impressions but "once in a while" Order.

for example, I have over 3,200 impressions in the last 60 days, 1,700 in the last 30 days and over 300 in the last 7 days but clicks and views is very low.

I reduced the prices of some of my Gigs yesterday after checking similar Gigs.

Other people can help me check as well.


Thanks.

Cyberl33t:
I have a Payoneer account that has received more than $300...u can request and send payment!!

Id verification has been approved...

Price 5k...

If interested call 0 eight 1 6 7 2 9 61 61

I pity whoever verified that account with his/her details. what if the buyer use the account for fraudulent activities?


I pity OP who wants to buy a ready made account. What if the seller decides to recover his/her account with your money still there?


But do whatever suites you guys.

There's a way to submit your blog for re indexing on Google Search.


Just do some research.

Please, how can one prevent a sow from attacking piglets during farrowing?


There's this sow we have, few months ago, it gave birth to 8 piglets over night. But we met all the piglets dead the following morning.


Just Now, The SOW has started giving birth again, but unlike the other SOWs, It takes a long time Interval between births to give birth to successive piglets. I witnessed it attack the first piglet and eat a part of it. Some mins(OR hour) later it gave birth to the second Piglet which seem healthy, Just like the first, It attacked this when the piglet approached it for milk.

So far, it has given birth to a third(After something like an hour or more of birthing the first), which we successfully separated from it(By freeing the SOW and locking up the PIGLET) before it can attack.


The SOW is aggressive, and on two occasions after releasing it, I witnessed the eyes turn Red for a brief moment.


Currently, It is sitting in front of the gate to another SOW's house. Can this help in anyway?(I don't want the other sow to learn killing its piglets)


Is there anything(like food) we can give to the surviving piglets? we don't currently have a nursing SOW.


My mum believe it still has 7 piglets it has not giving birth to as the sow's mother birthed 8 piglets first and 10 after.


What do you think we can do for this SOW to ensure the unbirthed Piglets survive?

And what can we do to ensure it won't kill them later?

we're based in Akure, In case you have something for us.


Thanks.

andivirus:
One that will be accessible on a Local Area Network using a browser.

Then you can get free PHP sorce code online.

You can search for something like "free PHP E Library Source Code"

OR use

"free PHP E Library Source Code Github"


You can download multiple source code to get an idea of what you intend to do.


You might still need to write yours though.

Boschh:
HP Elitebook 8470p..

4gb RAM.
320gb HDD..

You can upgrade if you want but that's what I use and it's efficient..

You just mentioned a system name without specifying the processor speed.

This type of system can also come with an Intel celeron processor while yours might be Intel core i5.


As for op, your choice of system depend on the type of programming you want to do.

Do you want to develop apps for android? Then go for a system with 8GB or more RAM and a good processor speed.

Is it web development? Then a system with 4 GB RAM might just be enough.


Is it just HTML and CSS? Then any system is good.

This is just like saying there should be a Union standardizing prices.


To me, this does not make any sense. Look at every aspect in Nigeria where we have Union influence, there's hardly development. And this is one of the main things dragging us back as a nation.

Simple fact is, everyone know their worth.

Plus this will be almost impossible in Nigeria because many people who earn through programming do it through freelancing sites like fiverr. If they refuse to accept the job, someone else will. If you have a fiver account, check buyers request section regularly, check the kind of projects some of the buyers want to do and their budget.

Check back in 2 to 5 mins time and see the number of people that have applied.


This also applies to freelancer.

So, will you say Nigerians should stop accepting jobs from this freelancing sites because of some of the ridiculous pay?

Even if you regulate the prices in Nigeria, people who are not willing to pay the reasonable amount will simply give the job to someone which will probably be a foreigner on one of this freelancing sites.

In short, forget about price regulation in this industry. But know your worth.

I think you can get free source code online that will give you idea of how to build it.

It also depends on what type of app you want to build. Will it be a desktop app? Or one that will be accessible through a browser.

I want to know

I don't even know what to say.

Same way the card reader fail to read Jonathan's card in 2015 election.

Tabbaz:
hi

Evening

promisedwealth:
goodmrning great pipul i have a problem i'll like my ogas to guild me throuh a buyer order my gig its was a 3days duration gig the work was so much that it need days because of the reguirements.on the last day of this order i got a new order of 24hrs i delivered the video not knowing i sent the wrong video before i could know whats going on this buyer toke me to cs the order was cancelled he dropped a very bad review were he called me a scammer i contact him and told him it was a mistake i told him to reorder same gig so i could deliver which he did i deliver and the disappeared with out reviewing his early statements i hav tried contacting him.he does not repl
y. i dnt know what to do i'm really hurt at that reveiw it could scare buyers and i can not even bid for jobs as my rating is low. so i was thinking of buying a review but i dnt knw the best way to handle this. thats why i bought it here for my ogas to help me thanks.

If he had initially cancelled the order, he shouldn't be able to drop a review.

lets wait for other people to respond.

Ayazor54:
President Muhammadu Buhari has rejected four bills passed by the House of Representatives.

Buhari communicated his rejection via a letter read during plenary on Thursday.

The bills include the Corporate Manslaughter bill, 2018; Agricultural Credit Scheme (amendment) bill, 2018; National Child Protection and Enforcement Agency bill as well as Courts and Tribunal Standard Scales of Fines and Financial Penalties bill

Speaker Yakubu Dogara, who read the letter, said Buhari rejected the corporate manslaughter bill because its provisions were inconsistent with the 1999 constitution.

He also read that Buhari withheld his assent to the agricultural credit scheme (amendment) bill on the ground of increase of the credit therein which was initially tagged at N100 million.

The president added that the National Child Protection and Enforcement Agency bill is a duplication of duties of existing agencies such as National Agency for the Prohibition of Trafficking in Persons (NAPTIP).

For the courts and tribunal standard scales of fines bill and financial penalties bill, the president explained that it contradicts existing laws in place.

The lower legislative chamber recently reintroduced 11 bills Buhari withheld assent to, for the purpose of overriding his veto power on them.

http://www.vondanews.com/buhari-rejects-four-bills-passed-by-reps-gives-reasons-2/

Is this a kind of planned drama to let us know Buhari knows the constitution?


Because i don't understand how those lawmakers will approve a bill only for someone many Nigerians believe forged his SSCE certificate, and less educated than most of the senators to be showing them what they should know.

I think he's trying to avoid Jungle Justice