I need a mobile SQL

Still haven't come right with adding it.

I add the SqlLite.dll reference. It won't actually give me any options to do anything or add anything.
 
halfmoonforever said:
Unfortunately I can't +1 sqlite because the OP didn't specify the use-case. If the "mobile" needs to sync to some centralized database somewhere so that other "mobile" users can see/access the updated data and pull reports from everyone concerned, then sqlite won't fit in well because it's usually tied to the device that's not syncing to a central db at all.

They also failed to specify if this is a native app on mobile devices, or just a responsive HTML5 implementation. When working with HTML5, you have several storage options, but again, if the client, at any point in time wants to see what Sales Rep 1 is doing, there needs to be a central database to store this in.
Click to expand...

Desktop App
 
Last edited:
Solarion said:
I'm looking for something I can use because the one client does not want to install SQL server. It's a fairly small app itself only holds about 12 users information with time cards for each person. What can I use?
Click to expand...

The way I would do this is to create a central db using XAMMP (MYSQL) then point the datalayer of the app to this central db.So that you are covered for any future needs with data syncing and locking etc.
 
Why would you need XAMMP just to get a MySQL server instance going? How about you just install the instance and open the port?
 
If you're prepared to install all sorts of random pieces of software why not go for sql server express?
 
What are the limitations on Express these days? We all have MSDN Enterprise setups so I am not sure what cutbacks they make on Express or Pro anymore?
 
Feeling pretty stupid now with my flat file recommendation, to me his needs sounded basic enough.
 
Thor said:
Feeling pretty stupid now with my flat file recommendation, to me his needs sounded basic enough.
Click to expand...

Don't feel stupid. In all my time on myBB this is the first time I took a look at something that even remotely has a bearing on what I do daily for a living. If the OP does end up using SQLite on his central point to which all mobile base stations report to I will be pretty impressed. Thus far the only server side DB I have worked with was MS SQL Server or Oracle 8i and above.
 
Rouxenator said:
What are the limitations on Express these days? We all have MSDN Enterprise setups so I am not sure what cutbacks they make on Express or Pro anymore?
Click to expand...

Namely the query optimiser - that's reserved for people that have the cash to throw away. In addition you can't use column-store indexes on anything but Enterprise Edition. You're also limited to like 10GB per database.
 
Yeah... something the OP won't miss at all. So good call by Toxic.

I do not have any cash to throw away but I do have an awesome employer.
 
Thor said:
Feeling pretty stupid now with my flat file recommendation, to me his needs sounded basic enough.
Click to expand...
They'll work but it's not future proof. If the app will stay a desktop app to run on one machine and the data will remain small then flatfiles with json data will work just fine.

Sooner or later though this guy will probably want to be able to access the "app" from his phone etc. and then flatfiles will become an issue.
 
XennoX said:
Namely the query optimiser - that's reserved for people that have the cash to throw away. In addition you can't use column-store indexes on anything but Enterprise Edition. You're also limited to like 10GB per database.
Click to expand...
Concurrent connections?

And the obvious: Windows (unless that Linux port is done yet).

Would rather go Postgre to be honest.
 
Last edited:
No love for NoSQL databases when working server side? I've been a huge fan of MongoDB for the past 20 months and it scales quite easily using it's built-in sharding. Not the solution for on-device database though...
 
Rouxenator said:
Don't feel stupid. In all my time on myBB this is the first time I took a look at something that even remotely has a bearing on what I do daily for a living. If the OP does end up using SQLite on his central point to which all mobile base stations report to I will be pretty impressed. Thus far the only server side DB I have worked with was MS SQL Server or Oracle 8i and above.
Click to expand...

I have no thrown the Sqlite idea out just yet. I'm back on this app today, had some other stuff to do yesterday, so I'll have a proper crack at using it.

Lots of interesting recommendations in this thread!
 
Rouxenator said:
What are the limitations on Express these days? We all have MSDN Enterprise setups so I am not sure what cutbacks they make on Express or Pro anymore?
Click to expand...

They actually quite decent these days

As of 2016 the SKU's are more aligned than ever before. Express can run on up to 4 cores, Max DB size of 10GB, and it misses some of the high end features.
 
ToxicBunny said:
They actually quite decent these days

As of 2016 the SKU's are more aligned than ever before. Express can run on up to 4 cores, Max DB size of 10GB, and it misses some of the high end features.
Click to expand...

You would still need to install it on the machine though?
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X