[Q] What Android database apps exist? - Android Apps and Games

I currently use a WinMo phone but might move over to Android. I have several large databases (1200+ records) so I use Handbase. I was wondering what database apps exist for Android. From what I'm told the iPhone version of Handbase is rubbish, is the Android version any good?
I've had a quick google search and didn't find anything and it looks like I can only search Android market via an Android phone which I don't own yet.
What I need from a database is to be able to import my existing databases (probably as a .cvs file) then easily filter the records. The simplest and best database program I've ever used was on my Psion 5, handbase (winMo) is a close second. Other than Handbase are there any other decent database apps out there and is Android Handbase any good?

I don't know of a good database app, but you can browse the market with Cyrket:
http://www.cyrket.com/search?q=database&market=android&sort=
There you also see HanDBase and others

Or search with Appbrain's website.. http://www.appbrain.com/

That was quick, I'm at work and a bit busy to have a proper look at the links, I'll look later.
Thanks for the quick replies.

Just to be clear, are you looking for an app that can read your current database files? Or just any database application (do you have any requirements E.G. GUI, Sql console, RDBMS transactionality?) For example, are you looking for "A database" in the same way that MS Access is "a database" (Hint: it isn't it's just a GUI) or "a database" in the way MySQL is.
Android has binaries for SQLite built in and searching for sqlite in appbrain should give you a number of front-ends for that.

Bouncypete said:
What I need from a database is to be able to import my existing databases (probably as a .cvs file) then easily filter the records.
Click to expand...
Click to collapse
I'm developing this kind of application, but i'v just started on it
Here it is
SQLator beta 0.1
Hope that give me more feedbacks
HouWWari.

Related

The best document editor

Is Documents to Go the best document editor for android? Or is QuickOffice?
INeedYourHelp said:
Is Documents to Go the best document editor for android? Or is QuickOffice?
Click to expand...
Click to collapse
For me I found the best document editor is "Polaris Office". Unfortunately until today I could not find the document apk to install it.
Anyu developers here could help?
I need the apk file to install it.
Thanks.
found this http://forum.xda-developers.com/showthread.php?t=1045522&highlight=polaris+office
But when I installed it on my Nexus1 it only lets me log in to a Box.net account to see docs I guess.
No GDocs settings, no way to create new documents.
The Google Docs app has been released, which may be a decent, powerful tool one day, but in this first version needs some polish. Has a great scan ability using your camera which, after some improvements, could be the ultimate feature.

[Q] Remote Administration of Multiple Android Handsets

My situation:
In my company we have about 30+ handsets currently running Android (standard and custom ROMs from XDA). The handsets include HTC Desire HD, HD2, Desire S and Desire Z. The users cannot be trusted not to brick the phones if they are allowed to download apps and modify them in anyway (not to mention they are business phones so shouldn't have facebook etc on them any way).
I've heard about admin tools which allow control of handsets remotely.
Requirements:
So, if possible, what i would like does something along the lines of...:
1: Blocks further apps from being added to the handset without a password
2: A lock to keep as many of the settings as is originally provided (wallpaper etc)
3: A master admin tool which i can remotely manage all the handsets from (download requested and approved apps, wipe, lock, locate and reset the phones if lost...etc)
What i have done before to stop the users adding further apps is register my email address to Android Market on all the phones, then changed the password using my desktop). While this stops new apps from being downloaded from the market, it does mean i cannot remotely roll out approved apps as they are no longer signed in to the account.
Is there anything out there which does any/all/some of the above?
Is there one tool which can manage all these tasks? Or will it have to be seperate apps like Norton Mobile Security (such as) etc?
Can anyone get their heads around this?
Thanks!
The market lets you download apps to a phone.
Lookout Security does all of the security tasks you want.
Thanks, that would take care of the remote wiping, locating and locking.
Does Android provide any corporate setup for administration of lots of handsets? Surely this is a niche in the market for some devs to jump on if there isn't something like that already.
And i know Android Market allows you to remotely download apps to multiple phones but i want to make it impossible to download through the phone itself. (so i can add apps but the user can't)
Something that performs like MFormation Enterprise Manager but avoiding the $20k price tag! (a tall order i know)
Sonic_Sonar said:
Something that performs like MFormation Enterprise Manager but avoiding the $20k price tag! (a tall order i know)
Click to expand...
Click to collapse
Hello,
Have you found any apps that fit your needs? Do you use them? If no, is your organization still interesting in mobile device management service?
I'm asking because I'm working for http://bloove.com (personal phone management service) and we're going to expand our offer to small and medium companies.
This new service will combine existing contact, sms, phone log and bookmark backup for personal phone with MDM features like centralized app management, location and wipe service etc.
We're looking for early adopters who will have a chance to add their custom requirements to the service and get this service for free for up to six months.
Please let me know if you're interested and want to discuss this further.
Thank you,
Rostislav
[email protected]
Please use the Q&A Forum for questions Thanks
Moving to Q&A
I did something like this ...
I first installed openssh server, plus a script that checks a specific URL for remote access needs (had to do it that way since my carrier blocks connections on all ports).
The server side is a simple php script that you call like this: check.php?deviceid=[ID]. The script checks a DB to see if there is anything new for that device ID and acts accordingly. I implemented three features: Tunnel, Script, Install APK. So, If I want to install an APK to all devices, I just upload it on our webserver, and on the MySQL DB I add devices id = all, action=install, file=/apks/whatever.apk. If, for instance, I want to do something more complex on certain devices, I add: id = all, action=script, file=/apks/whatever.sh. I write the script, then all phones check for updates on this check.php every 5 minutes, if they find a script, they'll download and execute. If it's an APK, they'll download and install. If I insert a line with deviceID=[deviceid], action=tunnel, file=[PORT NUMBER], then the phone will SSH into a remote server and do a reverse port forward, on [PORT NUMBER]. Then I can just SSH into localhost:[PORTNUMBER] on the server, and I'll have a terminal inside the phone to do whatever I need.
This doesn't address the restrictions issue, but it does allow you to control the phones however you want.
Regards,
Almafuerte.

[Q] Oralce Database App

Looking for a good Oracle 10g or 11g integrated app that will run on a tablet? I have looked at the ones on the market place but none that will run the database or allow you to create scripts for testing and updating the database.
Running Oracle Database on a tablet would be terrible. Oracle Database 11g on Windows requires a minimum of 1 gigabyte of RAM just to even open the application, and several gigabytes of hard drive space. Considering that the Transformer typically only has around 300 megabytes of memory free after loading up the OS and all background services, it's highly unlikely that you'd be able to do much with any sort of DBA app before it would bog your system down to the point of being unusable.
Use RDP, VNC, or SSH to take control of an actual workstation to do your work.
New Oracle Database Utility,TyphoonDBMS 1.0 Beta (Free)
humanporkrind said:
Looking for a good Oracle 10g or 11g integrated app that will run on a tablet? I have looked at the ones on the market place but none that will run the database or allow you to create scripts for testing and updating the database.
Click to expand...
Click to collapse
TyphoonDBMS is a complex and efficient Java-based software (free) solution that enables user to easily access and manage tables on Oracle Database Servers.
Typhoon is a comprehensive and reliable application that was developed to assist user in managing the contents of Oracle databases, enabling user to add, edit or remove tables without needing to resort to SQL statements to get the job done.
To gain access to the utility, user first need to create an account using a preferred set of credentials, which will then be required to enter every time user wish to work with Typhoon.
The program allows user to connect to a local or cloud server, by providing the necessary information, including name, version, driver and service ID. user can also input the network details, specifically the host and port number, along with the username and password, or even the database URL. Prior to saving the configuration, user can test the connection to make sure everything is in order.
Once user connect to the Oracle database, Typhoon allows user to view its contents, namely the tables that it comprises. user can browse through them, select a record and update it. Similarly, user can add a new one, as the tool enables user to ‘Insert Number Data’, ‘Insert Blob Data’, ‘Insert Clob Data’, ‘Insert String Data’ or ‘Insert Date Data’.
Moreover, user can create a new table by defining the number of columns that user need, assigning it a name, then filling out the columns and rows with the information user wish it to store. All of this can be done without having to resort to SQL statements or commands. Other options include the ability to drop tables from the database.
This Java-based utility also offers user a series of SQL ‘Syntax References’, (statements and functions) and which user can analyze in detail, to learn how to better work with them, and then use them for your own purposes.
Download & Blog
typhoondbms.wordpress.com/download/
download.cnet.com/Typhoon-DBMS/3000-10254_4-76273374.html
softpedia.com/get/Internet/Servers/Database-Utils/Typhoon.shtml

WhatsApp Backup Transfer

I wasn't quite sure where to put this, and I did email their support but I figured there's such an untapped knowledge base here, that you guys would probably be more fit to help me better and faster.
I recently upgraded from my Atrix 4G to an iPhone 5, and I've been using WhatsApp for months if not well over a year on my Atrix. I have done regular backups and since my jump from Android to iOS, I lost those files. I understand WhatsApp doesn't have server side backups and all the backups are local to your device. I thought a mere grab and drop of the backup files would do the trick, but the architecture and structure of WhatsApp between these two operating systems is astounding. I have both the msgstore.db (Android) and the ChatStorage.sqlite (iPhone) backups, in my searches I found that the .sqlite file is is not encrypted like it's counterpart, .db. I was hoping and wishing that there was a way where I could decrypt the .db and rename it as the .sqlite, I'm not entirely sure if that is such a lost cause because the differences between how WhatsApp handles on Android as opposed to iOS or if it's something that is feasible. There's just too much information stored on my old chat logs that I can't lose from the jump.
I'd appreciate any type of help with this, thanks in advanced.
There currently is no easy and comprehensive solution for migration from Android Whatsapp to Iphone Whatsapp.
You have the following options:
- Use Whatsapp Xtract. With this tool you will at least be able to browse your old messages in a browser, so they aren't completely lost.
[TOOL] Whatsapp Backup Messages Extractor
- ark0n3 is working on a Java tool called WhatsAppMigrator (however from iOS to Android, I think), you may contact him: ark0n3
As far as I know, the tool currently only manages to convert normal messages, but no media or group messages.
- You may wait for Whatsapp Xtract to include a conversion and/or merging feature. But currently it doesn't look like we will make it soon.
The problem is not only the encryption of msgstore.db.crypt (using Whatsapp Xtract you easily can decrypt it), but the completely different database structure between Android and Iphone Whatsapp data files.
ztedd said:
There currently is no easy and comprehensive solution for migration from Android Whatsapp to Iphone Whatsapp.
You have the following options:
- Use Whatsapp Xtract. With this tool you will at least be able to browse your old messages in a browser, so they aren't completely lost.
[TOOL] Whatsapp Backup Messages Extractor
- ark0n3 is working on a Java tool called WhatsAppMigrator (however from iOS to Android, I think), you may contact him: ark0n3
As far as I know, the tool currently only manages to convert normal messages, but no media or group messages.
- You may wait for Whatsapp Xtract to include a conversion and/or merging feature. But currently it doesn't look like we will make it soon.
The problem is not only the encryption of msgstore.db.crypt (using Whatsapp Xtract you easily can decrypt it), but the completely different database structure between Android and Iphone Whatsapp data files.
Click to expand...
Click to collapse
some days ago I had to move the project from google drive to a public website (for some technical limitations imposed by google).
please not that this tool (at least at the moment) move your Whatsapp history from iPhone to Android, not the other way around.
here you go mod edit - links removed
How to transfer chats Whatsapp from Android to iPhone ?
I'm willing to pay for help
condor-style
@
mail,
ru
Is there any chance of making the conversion to reverse? From Android to iPhone? Thanks.
panchowatkins said:
Is there any chance of making the conversion to reverse? From Android to iPhone? Thanks.
Click to expand...
Click to collapse
Any idea? I'm looking for this...
I'm also looking for any method to migrate my whatapps' history from android over to my next phone. Due to this is a company phone, therefore, there's plenty of important messages which I needs from time to time.
Please, if someone could help out on this.
Thank you very much in advance.
I guess all the Data are stored at WhatsApp server.
If you install a fresh and verify your old same number, it will sync your conversations...
Secondly, one can use WhatsApp Backup app.
I am not sure for the availability of backup and restore capabilities across multi platform.
But if that is not available today, some developers may go for that looking to the popularity and user base WhatsApp has got.
Hi all,
I also run into this problem. I really want to have my Whatsapp db on Android converted to the sqlite format for iPhone. Is there a way I can help ? I have some python coding experience and also some db knowledge. Not very much, but willing to learn !
shackks said:
I'm also looking for any method to migrate my whatapps' history from android over to my next phone. Due to this is a company phone, therefore, there's plenty of important messages which I needs from time to time.
Please, if someone could help out on this.
Thank you very much in advance.
Click to expand...
Click to collapse
panchowatkins said:
Is there any chance of making the conversion to reverse? From Android to iPhone? Thanks.
Click to expand...
Click to collapse
A program called Android WhatsApp to iPhone Transfer from Backuptrans can help.
How to transfer WhatsApp Messages from Android to iPhone?
iPhone WhatsAppp to Android Transfer is also supported. Hope it helps.
ark0n3 said:
some days ago I had to move the project from google drive to a public website (for some technical limitations imposed by google).
please not that this tool (at least at the moment) move your Whatsapp history from iPhone to Android, not the other way around.
here you go mod edit - links to paid app removed
WhatsappMigrator switched name to WazzapMigrator and moved to a native Android app.
Check out (free on Play Store): https://play.google.com/store/apps/details?id=com.nbeghin.whatsappmigrator.lite
Click to expand...
Click to collapse
can't delete this post. maybe missing permission??

[Q] File/Folder Tagging Software

Hello. I am looking for android software that will allow me to attribute multiple tags to individual folders and files. By doing this I can organize them into as many virtual folders as I like according to their tags. I currently use Evernote which does exactly this but all files have to be converted into Evernote format and synced using their cloud server. If I could apply my own tags using the native android file structure I could simplify my organization and not have to use Evernote.
I found software that I think does this for windows (Tabbles.net) but it is not developed for android.
I seached for alternatives for Tabbles for android on alternativeto.net but had no luck.
Anyone know of software like this for android? Or could suggest another place to search for it?
Thanks.
I think this is what you are looking for, i'm not sure because i haven't understood you so much (bad english )
Not really understood what you're talking about
Okay, I'll try to explain it better. Android (and most other platforms have a tree-like file structure. Files are stored in folders and subfolders. To find a specific file or folder, you find a parent folder and work your way down to the folder/file you want. The "Folder Tag" application recommended above (thanks xacobe97) allows you to bookmark a folder so that you can find it easily later. I want to add multiple tags to a file so that I can organize it under multiple headings.
For example, the word file "LG G2X Screen Protector" could have the tag "Phone reference" so that I have the information on hand, and the tag "Errands" so that when I look under that tag I see that I need to go out and buy one. This is exactly what Evernote and many other productivity software titles do, but you have to convert all the files you want organized to their file format. I would like some kind of file manager that can tag any type of file, and make these programs unnecessary. It would also allow me to use my preferred office app to edit files, not whatever editor comes with Evernote or whatever else.
Any help would be appreciated. Thanks.

Categories

Resources