I have a web based quoting system my sales team uses and the database has 70,000 rows in the quotes table, each one a different quote. I'm using Android's SyncAdapter classes to make it so the application synchronizes with the remote database when a connection becomes available but will use the local NoSQL database when getting pricing. Now one of the sales guys might want to go back and look at quote number 50231 from a few years ago when in a remote area without service so I'm wondering if there are any issues with synchronizing all 70,000 rows from this table to the local database on the phone or if there's a different accepted way of doing this.
The entire database is 1 gibibyte in size and contains all customers, quotes, pricing and a bill of materials for each job. I'm just trying to find best practice here.
Related
I work for an IT firm, and often when we go onsite we end up having to retrieve user passwords for various reasons. Right now our options are to:
A) Print out the site's password sheet and take it with us
B) RDP back to our company network and lookup each password as needed
The first solution is rife with security concerns, while the second is a pain in the butt.
What I would like to do is set up a background wifi sync at the office with my android tablet, so every time I leave the building I automagically have up-to-date files with me. But also store them in an encrypted folder or format, so if the tablet gets lost we don't have to reset many hundreds of client passwords. I am not at all opposed to buying an app, or more than one if this can be accomplished in a convenient and secure way. Any ideas?
Dropbox? Preferably combined with storing the passwords in an encrytped database such as keepass?
Really, you want confirmed sign off from your management here. ****ing up with a customer password database (say you lost your phone) is a Career Limiting Move.
Sent from my GT-I9100 using Tapatalk
So.
I can only hope that posting this here doesn't somehow ruin it down the road, but everyone here has a Gmail account corresponding with their devices, and most likely WebStorage (if you use it) as well, so I've been thinking for a while that this "exploit" may be possible: AND IT IS!
Is everyone familiar with a feature of Gmail and Google's infinite wisdom that allows you to make any number of "fake" accounts that tie in to your actual, single account? Of course most use it to register for and subsequently filter out Spam.
However, it's Google's servers which account for this ability, and so the (and really most/all) WebStorage app will accept any dotted (and dashed? don't remember what all you can do) form of your Gmail account name as a new account. So although it will be 8GB segments you could have any number of them with organized info distributed per "account."
I believe this could most likely also be done with an OG Transformer to activate* the one year of "unlimited" storage, and you could upload massive amounts of info in a relatively short amount of time across a few "accounts" and have just about any of your stuff up. I don't have an OG so someone will need to check it out.
*EDIT:
Let me also state I only did this to begin with because ASUS or whoever manages WebStorage said they couldn't update my initial account to correspond to my ownership of the Prime. They told me to do this.
Code:
ASUS bundles of ASUS Webstorage could only be activated within new accounts. Therefore, you won't be able to expand your subscription of current existing account, but you're definitely welcome to register a new ASUS WebStorage user ID to retrieve your term of Transformer.
Please follow the steps below to access complementary ASUS WebStorage Service:
1. Logout from current ASUS WebStorage ID.
2. Register a new account from Mycloud
I'm not sure if this is the right place to ask.
I'm looking for a simple app with very specific functionality: I should be able to take a picture of a receipt, tag it with an amount and a date. It will then store it on the phone or "in the cloud" (cringe). I should be able to generate reports by date range that give me the sum of amounts between those dates. Ideally it would also be able to generate a PDF document with a list of receipts including all images, amounts, and dates for a given date range.
I'm capable of writing this myself but I'd rather just grab something off the play store if someone knows what to look for!
I do not know if I am asking in the correct place, or the correct way. I am not a developer and so far attempts to use google to find the answer to my question has been in the form of developer answers which are useless to me since I am not writing a program. I am looking for one.
I am trying to build myself a database. On my desktop I can use Open Office Base to do this, but the database is only accessible on my desktop.
I have tried Momento database app and its desktop counterpart, but its limited to 3 tables only unless I buy a monthly subscription and it relys on an external web service to function.
I have looked at the Cellica program for syncing database, but it does not support the Open Office Base format, and Open Office can not export to MS Access format.
What I am looking for is the best free database program for my desktop which has an android app, which I can use to sync my database between my android tablet and my desktop over wi-fy when I'm at home.
If its good enough I may even consider a paid program, as long as there is no subscription fee.
I'm building an Android application which will allow my sales team to quote projects and I want it to work while they're in remote areas, which means it will download price changes when they get into service areas and also upload any quotes they have done. Since it needs to work offline, I need to authenticate the user login but I'm hesitant to be authenticating them against the database stored locally on the device. Is there a proper way of doing this? I can't authenticate remotely because it has to work offline. Is the local NoSQL database secure? Should I not worry too much about it and just make sure they're authenticated remotely prior to the synchronization when a connection becomes available? Thanks a lot.