I need a mobile SQL

Realtime stuff?

Perhaps I'm just a bit slow today, but how else would the mobile device keep in sync if it cannot connect to the central DB?
You don't want the credentials for your central database being spread about on a potentially unknown number of mobile devices. You connect through web services. Provides an extra layer of security. I did work for the UK govt on their benefits management system. They follow this very strictly. I currently work in the short term insurance industry, mostly motor, home and travel insurance and in order to be certified with U.K. FCA we need to ensure we protect our customer database from direct access from the web etc.

Mobile devices are a big security risk because they connect over wifi etc.

Other than the security aspect, it's just so much easier implementing web services because you don't have to worry about which Android version, iOS version etc. is on the client. Any case you can't load masses of data on mobile device over wireless connection in a reliable manner. That's just asking for trouble. Design for a small subset of data which can be easily synced using web service. It's the most efficient way for dealing with mobile devices. And as a bonus, that same web service can be used on a desktop/laptop without extra work, other than creating a website, but I am sure you know how easy it is to build a website which provides user friendly ui based on the browser device :)

You also aren't tied to any database vendor. :) fanboyism notwithstanding :)
 
Swist Group, then it became Altech Swisttech

Ah right. I know Herman well.
I worked for Altech Isis. My team was responsible for all the billing applications wholesale/postpaid and the WASP content billing system.
 
You don't want the credentials for your central database being spread about on a potentially unknown number of mobile devices. You connect through web services. Provides an extra layer of security. I did work for the UK govt on their benefits management system. They follow this very strictly. I currently work in the short term insurance industry, mostly motor, home and travel insurance and in order to be certified with U.K. FCA we need to ensure we protect our customer database from direct access from the web etc.

Mobile devices are a big security risk because they connect over wifi etc.

Other than the security aspect, it's just so much easier implementing web services because you don't have to worry about which Android version, iOS version etc. is on the client. Any case you can't load masses of data on mobile device over wireless connection in a reliable manner. That's just asking for trouble. Design for a small subset of data which can be easily synced using web service. It's the most efficient way for dealing with mobile devices. And as a bonus, that same web service can be used on a desktop/laptop without extra work, other than creating a website, but I am sure you know how easy it is to build a website which provides user friendly ui based on the browser device :)

You also aren't tied to any database vendor. :) fanboyism notwithstanding :)

This.

The approach I follow is to expose all functionality with a JSON/REST API. Then any client can talk to it. I also make the web pages talk to the API.
 
You don't want the credentials for your central database being spread about on a potentially unknown number of mobile devices. You connect through web services. Provides an extra layer of security. I did work for the UK govt on their benefits management system. They follow this very strictly. I currently work in the short term insurance industry, mostly motor, home and travel insurance and in order to be certified with U.K. FCA we need to ensure we protect our customer database from direct access from the web etc.

Mobile devices are a big security risk because they connect over wifi etc.

Other than the security aspect, it's just so much easier implementing web services because you don't have to worry about which Android version, iOS version etc. is on the client. Any case you can't load masses of data on mobile device over wireless connection in a reliable manner. That's just asking for trouble. Design for a small subset of data which can be easily synced using web service. It's the most efficient way for dealing with mobile devices. And as a bonus, that same web service can be used on a desktop/laptop without extra work, other than creating a website, but I am sure you know how easy it is to build a website which provides user friendly ui based on the browser device :)

You also aren't tied to any database vendor. :) fanboyism notwithstanding :)

Makes 100% sense, this is what I thought, but I read your comment wrong.
 
The common sense is strong in this thread
 
Ah right. I know Herman well.
I worked for Altech Isis. My team was responsible for all the billing applications wholesale/postpaid and the WASP content billing system.

Herman is awesome, really a cool boss to work for. He is now into long distance mountain biking so I see him at some events and we chat a bit. I remember when I started there in 2001 I asked him about how he started out and what he plans for the future. He told me he saw himself as an entrepreneur and he won't be the MD of a software house for more than 5 years. He wants to go big and then retire.

We'll he sure did that. I am honoured to have worked for him and to still the dude around. He taught me a lot, best I can describe him as is a South Africa Steve Jobs, only he is not an ******* like Steve was :crylaugh:

About Swist and it's absorption into Isis (no offence), I jumped ship months before they moved to Cape Town (due to a power tripping MD). My biggest work was on police case sub-system used as part of our solution for Vodacom, but also some other projects like the community services management system. Many moons ago. Glad I has those opportunities.
 
The common sense is strong in this thread

Microsoft :love:

Not only did they give me a career but back in the day I found my wife on match.msn.com when M$ still owned Match.com
Let's see the kind of wife Linux gives someone?
 
Microsoft :love:

Not only did they give me a career but back in the day I found my wife on match.msn.com when M$ still owned Match.com
Let's see the kind of wife Linux gives someone?
The issue is not :love: for M$. The issue is :love: for only M$.

The "common sense" though is with regards to the comments of having a client connect to a webservice/API instead of connecting to a db directly. If anybody does it differently they can count themselves interns/juniors. Some things are just common sense/best practice and goes without saying.
 
All this reading of APIs I am now in the mood to build something with PHP, a bot of sorts.
 
Herman is awesome, really a cool boss to work for. He is now into long distance mountain biking so I see him at some events and we chat a bit. I remember when I started there in 2001 I asked him about how he started out and what he plans for the future. He told me he saw himself as an entrepreneur and he won't be the MD of a software house for more than 5 years. He wants to go big and then retire.

We'll he sure did that. I am honoured to have worked for him and to still the dude around. He taught me a lot, best I can describe him as is a South Africa Steve Jobs, only he is not an ******* like Steve was :crylaugh:

About Swist and it's absorption into Isis (no offence), I jumped ship months before they moved to Cape Town (due to a power tripping MD). My biggest work was on police case sub-system used as part of our solution for Vodacom, but also some other projects like the community services management system. Many moons ago. Glad I has those opportunities.

Yes Herman is super chill guy. Know from when he was at Stb Uni. Then him and Jannie started SWIST. I used to surf with Jannie. Not sure if true but I asked him what SWIST stands for. He said Somerset West Idiots Stand Together... :crylaugh:

Yes the environment at Isis was quite challenging. People did not last. Not the type of culture that many liked.
 
Not sure if true but I asked him what SWIST stands for. He said Somerset West Idiots Stand Together... :crylaugh:.
Yup, he used to joke about that quite a bit back in the day. Actually we came up with many names which shall remain unmentioned here :D
Linux would give you an 'open' source wife :sick:
:crylaugh: I see what you did there....
 
Ok back on this project. Going with SQLite.

[video=youtube;UN7nMNVw2hk]https://www.youtube.com/watch?v=UN7nMNVw2hk[/video]
 
Ok back on this project. Going with SQLite.

[video=youtube;UN7nMNVw2hk]https://www.youtube.com/watch?v=UN7nMNVw2hk[/video]

Holy **** NO!!!! :wtf:

Firefox has a plugin to manipulate and create sqlite DBs with all the features to script tables indexes etc etc.
 
Top
Sign up to the MyBroadband newsletter
X