LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 03-18-2008, 03:02 PM   #1
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Rep: Reputation: 31
Client/Server app suggestions


Dear all,

I'm about to start coding client/server app (max. 200 clients). I know what to do, but have some doubts, so I've came here to ask fellow programmers what would they do...

Servers will have huge databases, and clients will query approx once a second. Failure should not happen, not even for a second! What would you do? RPC, XML-RPC, -lmysqlclient,...?

If all goes well, you'll be reading all about it in LQ Members Success Stories section

PS. Anybody had experience with barcode readers in GNU/Linux?
 
Old 03-18-2008, 03:15 PM   #2
arkinrome
LQ Newbie
 
Registered: Mar 2008
Location: México
Distribution: Slackware
Posts: 15

Rep: Reputation: 1
Well I don't know what DMBS you'll be using but it seems like a good idea to me that you use a connection pool to handle the user requests.

Regards.
 
Old 03-18-2008, 04:05 PM   #3
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Original Poster
Rep: Reputation: 31
I'll be using MySQL cluster.

This won't (I guess) be an PHP app, or ODBC. I'll code it, so I really will consider creating conn. pool. Oh, threadsafe programming, here I come

Thanks for the tip!

What would be your perfect setup (no need to detail too much)?
 
Old 03-18-2008, 06:10 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,344

Rep: Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746Reputation: 2746
Depends what lang you want to use. Perl has nice DB modules.
 
Old 03-19-2008, 05:15 AM   #5
bigearsbilly
Senior Member
 
Registered: Mar 2004
Location: england
Distribution: Mint, Armbian, NetBSD, Puppy, Raspbian
Posts: 3,515

Rep: Reputation: 239Reputation: 239Reputation: 239
why do you need RPC to do a query?
 
Old 03-19-2008, 06:21 AM   #6
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Original Poster
Rep: Reputation: 31
Language is not decided yet I'm not Perl master, so I doubt I'll use it
 
Old 03-19-2008, 06:31 AM   #7
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Original Poster
Rep: Reputation: 31
Quote:
Originally Posted by bigearsbilly View Post
why do you need RPC to do a query?
That's one possible way to do it:

clients -> (RPC communcation) -> server app -> MySQL cluster
 
Old 03-19-2008, 07:24 AM   #8
bigearsbilly
Senior Member
 
Registered: Mar 2004
Location: england
Distribution: Mint, Armbian, NetBSD, Puppy, Raspbian
Posts: 3,515

Rep: Reputation: 239Reputation: 239Reputation: 239
it's like SOAP ain't it?

you wind up wrapping 8 bytes of data in 500 bytes of envelope!
MS style computing ;-)

depends what sort of queries i guess, if you have a known subset.
security issues?

Last edited by bigearsbilly; 03-19-2008 at 07:33 AM.
 
Old 03-19-2008, 09:14 AM   #9
indienick
Senior Member
 
Registered: Dec 2005
Location: London, ON, Canada
Distribution: Arch, Ubuntu, Slackware, OpenBSD, FreeBSD
Posts: 1,853

Rep: Reputation: 65
Heh, judging by some of the guidelines: 1 query per second (without failure), and barcode scanning, I would think this might be an application for a POS (Point Of Sales) setup.
 
Old 03-19-2008, 09:21 AM   #10
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Original Poster
Rep: Reputation: 31
Quote:
Originally Posted by bigearsbilly View Post
it's like SOAP ain't it?

you wind up wrapping 8 bytes of data in 500 bytes of envelope!
MS style computing ;-)

depends what sort of queries i guess, if you have a known subset.
security issues?
Yeah, something like SOAP, that would be.

I have a known subset for query/response (pretty limited one). Security is not the issue, network will be completely isolated.

Quote:
Originally Posted by indienick View Post
Heh, judging by some of the guidelines: 1 query per second (without failure), and barcode scanning, I would think this might be an application for a POS (Point Of Sales) setup.
You are very close
 
Old 04-18-2008, 06:57 AM   #11
dragoncity
LQ Newbie
 
Registered: Apr 2008
Posts: 10

Rep: Reputation: 0
Why don't you check out Erlang ?? It was designed to do just what your thinking about.

Its mnesia DB is designed to be failsafe and distributed across thousands of clients. It looks after itself in as much if one client 'fails', the others do not and the database is not corrupted. You can program against mnesia with other languages but as its also written in erlang there is no language <=> dB impendence, its not ODBC however ( if thats an issue for you)

However, be warned ! , Erlang is not your 'usual'
language. Perl/php/C/VB etc its not !!
 
Old 04-18-2008, 08:03 AM   #12
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Original Poster
Rep: Reputation: 31
Hey, thanks for the tip.

I've heard for Erlang, but never took a look at it... Which I'm about to do now
 
  


Reply

Tags
clientserver, development


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Suggestions for a good gnome weather app. please! aquaboot Ubuntu 1 12-20-2006 08:27 PM
BitTorrent app with client-server setup cs-cam Linux - Software 3 03-14-2006 08:32 PM
I need suggestions for an ftp client... NonSumPisces Linux - Software 2 08-28-2004 03:23 PM
Suggestions for 'cooler' xload app? JordanH Linux - Software 3 04-27-2004 05:19 PM
e-mail server. Want to use client app to retrieve mail bkeating Linux - Software 2 08-23-2003 07:44 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 04:34 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration