SQLite rows limit - Tasker Tips & Tricks

Hi,
I've a problem with this simple query for a WhatsApp DB (the DB is not in use and is stored on the internal SD card), it will only return results if it's less than 100 rows:
SELECT needs_push FROM messages WHERE key_remote_jid LIKE "%[email protected]"
if I change the selected group ("%[email protected]") to one that has messages fewer than 100 (or added more conditions to limit the results) then it works as expected.
I've tested this using:
SQLite for root
Tasker SQLite Plugin
Any idea what is the cause of this?
Thanks.

Related

Save SMS to memory card?

Hi i was wondering if there is any mod or any way to save SMS messages to a memory card? the reason i wonder this is that after a few hundred SMS the phone begins to slow and i would like to prevent this.
Thanks
No... and even then it would most likely be even slower on the card (internal memory is faster)...
Maybe some 3rd-party SMS programs can if you really want to go that way, but what I'd recommend is simply to delete some so that the phone doesn't have to list those hundreds of messages each time...
mmk, thank you for the quick resoponse
I've had over 1000msgs on my device and never saw it as affecting the phone's speed.
Have u looked into other factors that may be hindering the speed of your phone? (i.e. apps open in the backround)
I'd noticed that too many SMS slowed my phone down - I use PIM Backup to save my texts when I get too many - I transfer the file it creates to my storage card or PC so I could reload if ever I need to look back through them - keeps it clean and a free program too.....
Edit - link for you http://www.dotfred.net/
to save power when in suspended mode your pda power down sd interface
but the phone features are running in the background even when suspended
if you could make your device put sms's on the sdcard
when you received then while your phone was suspended they would be lost
as the sd card would be unavailable when suspended

[Q] Samsung Apps Video Editor - Needs every single permission??

When I tried to install the Video Editor from Samsung Apps, I was shocked by the amount of permissions it needs:
Full internet access, use authentication credentials of an account, modify or delete sd card contents, format storage, modify global settings, retrieve running applications, write APN settings, write sync settings, change network connectivity, mount/unmount system, change UI settings, change your audio settings, take pictures with camera, read/write contact data, read/write owner data, read phone state, modify phone state, directly call phone numbers, read/send/edit/modify sms, read/send/edit/modify Gmail, receive WAP, fine GPS location, read service configuration, create bluetooth connection...
In stark contrast when you try to install the Photo Editor from Samsung Apps, there's only permission required - read/modify SD card content.
Basically if someone installs a dodgy copy of this from somewhere other than samsung it could potentially take control of all aspects of the phone!
I installed it anyway as it's from Samsung, so can feel reassured it's not malware but is it really necassary? Do you think the developers were just lazy and just ticked everything when specifying permission access?
i dont seem to have video editor or photo editor in my samsung apps any clues?
What ROM and region are you?
I'm on JPY 2.2.1 and based in the United Kingdom. Maybe it's only for specific areas/firmware versions?
I tried to upload the apk to XDA but it's 11MB so couldn't as the upload limit is 8MB.
Looks like another member uploaded to a filesharing website in this thread if you want to try it:
http://forum.xda-developers.com/showthread.php?t=927550
But like I said in the original post, I wouldn't have installed this software if I didn't get it direct from Samsung...

[FIX] Bulletproof Background Apps!

UPDATE: Try BulletProofing Apps with my latest V6 SuperCharger Script! Use the following link OR use the link in my signature
I didn't want to risk making the SuperCharge & Bulletproof thread too confusing so I figured it best to make a "sister" thread.
This is a work in progress.
But if this information is helpful, please click the thanks button
HUGE thanks to Feeyo and Bear in NM for helping me figure out a workable solution on locking a background app in memory on boot up.
Feeyo gave me the gist of it but it wouldn't work on boot.
After posting in this thread at Droid Forums, things got rolling - with alot of help from Bear in NM.
Create a Unix script file with no extension (I named it 97oom) with Notepad++ and put it in your i/system/etc/init.d/ folder and put this inside:
Code:
#!/system/bin/sh
sleep 60
PPID=$(pidof [B]com.estrongs.android.safer[/B])
echo "-17" > /proc/$PPID/oom_adj
Permissions: chmod 755 /system/etc/init.d/97oom (same as 10overclock)
You can also do it on the phone itself:
1. Make a copy of 10overclock
2. Renamed it to 97oom (I have a 98governor and a 99complete so...)
3. Deleted the text and put the text you see above
4. Set permissions
Then reboot to test!
You can check to see if it worked with either Auto Memory Manager (AMM) or AutoKiller Memory Optimizer (AKMO).
The bold text in the above code is the process name of the app that you want to protect!
Note: You can get the process name from most process monitors or with AKMO or AMM.
That command "as is" will give ES Security Manager the highest priority of -17.
AKMO shows it as being ignored by the OOM killer
At first it wasn't working on boot because ES Security was not yet loaded in memory.
The "sleep 60 "command fixes that by waiting 60 seconds to execute the command
You can also do this in GScript Lite with this:
Code:
PPID=$(pidof com.estrongs.android.safer)
echo "-17" > /proc/$PPID/oom_adj
This comes in handy for apps that don't load on bootup - just run a GScript for those apps
I suggest you get Busybox Installer and have it install the latest BusyBox (v1.19).
This ensures GScript doesn't spit out ugly stderr: messages.
GScript Tip: 1. Make a file (with any text editor) with the commands
................. 2. Rename it with an .sh extension (example 97oom.sh)
................. 3. Put it in sdcard/gscript folder
................. 4. Run GScript, Menu key, Add script, and click Load file, select a script and Save (leave SU checked)
Even better, you can make shortcut for any GScript.
Long press desktop > Shortcuts > GScript Lite > Select... BOOYA!
As I said, this is a work in progress.
Taming the OOM Killer explains that an app will be ignored by the OOM killer if it has the -17 priority.
The problem is that Android will still shuffle it's priority downwards like it does with any inactive app.
If that happens, then the app reverts to it's usual priority.
This is why ESS will lose it's -17 after a couple of hours. It just sleeps ALL the time.
My thinking that if a more active background app, such as an SMS app or a music app is given the -17, it won't lose it's priority at all.
Feedback with results is more than welcome!
No need to set a variable, just use back-ticks:
Code:
echo -17 > /proc/`pidof [B]com.estrongs.android.safer[/B]`/oom_adj
Although that may be a little too complicated for some people to type in. Best to keep it simple I suppose...
That's pretty cool.
I figure most people would copy/paste the whole thing and replace the process name.
So maybe the back ticks wouldn't be a big deal.
That is why I try and avoid putting any code I use on forums. Someone who actually knows what they are doing will always come along and whack me ;^)
Seriously, good work Zep.
Craig
I don't mind.
That's all a part of learning so it's always good that there's somebody around that's "smarter" at something than me.
For example... this script I'm trying to get working for supercharging stock phones...
On custom roms, CM and FroyMod at least, I'd modify /system/etc/rootfs/init.mapphone_umts.rc
I flashed stock telus 2.2 and the path seems to be just /init.mapphone_umts.rc
I don't see rootfs anywhere
But there is a rootfs is mounted
To mount as rw, "mount -o remount,rw /system" doesn't work
In gscript, I'm getting "sed not found" errors too.
grrr...
how well do you think this would work with handcent? it's a little laggy to load up on my phone, but i want to try it out more. will keeping handcent in memory eat up ram that i need otherwise? and do you think it will be active enough to keep it's -17 after a few hours? thanks
edit: i was trying it out, it disappeard from processes withing a few minutes. oh well, maybe it doesnt need to be running anyway
Did you check with AMM to see if handcent had the high priority or if it really got killed?
ya, i checked. it was set to -17, then next time it refreshed it was gone. then i opened handcent, went back, and the process had a different pid, not oom level. oh well
damn
Maybe some apps are too prone to get killed off and the only way to keep them alive is with multitasking friendly minfree values
zeppelinrox said:
damn
Maybe some apps are too prone to get killed off and the only way to keep them alive is with multitasking friendly minfree values
Click to expand...
Click to collapse
Yes, I've seen the same happening with the stock SMS app. I did not receive SMS anymore so I decided to look at it a bit closer (using adb logcat). I started the SMS app, noted down the PID and set the oom_adj value to -17 using adb shell. A few seconds later it was killed. Setting the minfree values back to system default allows me to receive SMS again. Also whatsapp, gtalk and push mail now work reliable. With high minfree values I could see in the logs that, when a message arrived the app is started and immediately killed afterwards. So, I was never notivied that a SMS or whatsapp message had arrived. With default minfree values it seems to work more reliable.
But it all depends on how you use your phone, I guess. I'm using it as my communication central and don't want to miss any message. If you use it more as your mobile gaming or surfing device you might still be better off with high minfree values.
I agree.
That's why I made 6 different profiles.
The multitasking and balanced 2 settings, for example, will leave you with more free ram but are actually more background app friendly than stock google/android values.
zeppelinrox said:
I agree.
That's why I made 6 different profiles.
The multitasking and balanced 2 settings, for example, will leave you with more free ram but are actually more background app friendly than stock google/android values.
Click to expand...
Click to collapse
I see. I did not realize that. It seems I've been reading your post too superficially.
I'll give those settings a try. I've just lost another SMS (this time with the default setting)
If I can't get this under control I might go back to CM6. I understand this is not as memory hungry as CM7 is.
Well, handcent is a giant pain in the ass.
I'm running stock telus froyo and the thing doesn't even stay loaded and I'm not even doing anything.
I run it.
Try and bulletproof it with a gscript (and sometimes handcent is even killed off if I take too long opening gscript lol)
The script won't even change the priority of hancent.
It stays at an 9 or 10 in the content provider grouping.
But the thing is a pig anyway.
20+ mb of ram used up and the app itself is close to 5 mb.
Maybe froyo has a reason to not like it? LOL
very very important and informative post!
thank you!
one question: any idea why "Auto Memory Manager" isn't avialable to
milestone according to market?
I can't install it from market site and wasn't able to find it in market application?
zeppelinrox said:
Create a Unix script file with no extension (I named it 97oom) with Notepad++ and put it in your i/system/etc/init.d/ folder and put this inside:
Code:
#!/system/bin/sh
sleep 60
PPID=$(pidof [B]com.estrongs.android.safer[/B])
echo "-17" > /proc/$PPID/oom_adj
Permissions: chmod 755 /system/etc/init.d/97oom (same as 10overclock)
You can also do it on the phone itself:
1. Make a copy of 10overclock
2. Renamed it to 97oom (I have a 98governor and a 99complete so...)
3. Deleted the text and put the text you see above
4. Set permissions
Click to expand...
Click to collapse
I did it, and after reboot stock sms app (com.android.mms) is killed, I cheched in AKMO, and that fix didn`t help, so I set default minfree values in AKMO (although the previous settings weren`t so strict)
Ok, first off, I am a UK Milestone, running Cyanogenmod 7 RC4. I am trying to raise the oom_adj of COM.ANDROID.MMS and I just used the method zeppelinrox posted instead of the proposed alternative (though I did try that too) and the startup command seems to do nothing. So I decided to try the GScript way and I get this:
Code:
stderr:
stderr:
stderr:
stderr:
stderr:
stderr: cannot create /proc//oom_adj: directory nonexistent
stderr:
stderr:
stderr:
I have never used GScript before and maybe I am doing something wrong here, but I am running it the script as superuser, I have exactly what zeppelinrox has (except a change for the messaging app process name) and I am at a total loss here. Other methods worked fine on my RC3 and keep Messaging as a "Foreground Group" app, but in RC4 it is an "Empty" and that means it will likely get killed a lot. I am using stock minfree values, just using AMM to check oom. I don't want to be missing texts, so any help would be greatly appreciated. Let me know if you need anything else.
You get that "directory nonexistent" error because the app was already killed so there is no PID anymore.
I suggest you get Busybox Installer and have it install the latest BusyBox (v1.19).
This ensures GScript doesn't spit out ugly stderr: messages.
I finally installed CM7 for the first time and RC4 at least does have the option to lock messaging app in memory.
It's sitting in the foreground with a 0 priority
I thought that maybe it was killed already also, but I opened Messaging -> checked System Panel to ensure it was running -> ran the GScript (which failed as noted before) -> and checked System Panel once more and it was still running. Maybe I am crazy here..
I am using the "Lock messaging in memory" but "Messaging" process is still killed by the stock manager, is it still alive in some separate process? It certainly is not 0 priority in Foreground, still sitting in "Empty" at something generally over 4 priority.
I will probably just switch back to the previous build as all was well there, though I would like to be able to keep up with the newest features.
Thank you for the Busybox link, I will try that.
That's strange.
Maybe that setting needs a reboot?
I remember seeing messaging in content provider earlier and then I was actually surprised to see it in the foreground.
I actually checked to see if I still had the 97oom file in the init.d folder but it's not there.
But it should be immediate because if I uncheck Lock messaging in memory, it gets instantly killed.
I run it, check lock messaging again, and AMM shows it in the foreground group again.
Stderrs... now I dunno what's going on with that
GScript was working perfectly in stock Telus rom without stderrs after installing busybox (to get certain commands to work).
But in CM7, after updating busybox, stderrs all over the place.
Now I have to figure this out.. those stderrs are annoying as hell
zeppelinrox said:
You get that "directory nonexistent" error because the app was already killed so there is no PID anymore.
I suggest you get Busybox Installer and have it install the latest BusyBox (v1.19).
This ensures GScript doesn't spit out ugly stderr: messages.
I finally installed CM7 for the first time and RC4 at least does have the option to lock messaging app in memory.
It's sitting in the foreground with a 0 priority
Click to expand...
Click to collapse
What am I missing here? I'm looking at my CM7 Milestone right now with the "lock messaging app in memory" selected. And the messaging app is sitting in "background". Then I set the oom_adj value to -17 and a few minutes later messaging is gone. I'm starting to become desperate.

【APP】Optimize Tool Box(15 powerful functions)

【APP】Optimize Tool Box(15 powerful functions)
Thanks to caotiantupi :angel:
Description:
Android Optimizer is a Swiss Army Knife for your mobile phone. Top 15 functions makes you manage your phone easily, effectively and efficiently.
This powerful app has 9 sections, 15 functions such as Device scan, Quick settings, Startup manager, App manager, Program manager, Cache cleaner, File explorer, Power saving settings, and Device infor. Those powerful and comprehensive tools form a 360 angle protection for your Smartphone can always keep your Smartphone in the best state!
Features:
1.Device scan: Provide full scan for your mobile phone. One click to optimize Installed apps, Auto start apps, Running apps and Cache. Show CPU, RAM, ROM,SD, Signal, Speed, and Battery status.
2.Apps sort: Custom category for your apps to manage easily.
3.General and advanced settings: Quick access to set ring mode, volume control, input settings, screen rotation, WIFI, Bluetooth, security, APN and so on.
4. Widget:Add widget to homescreen, easy to switch WIFI, Bluetooth, airplane mode, auto rotate, cache cleaner and much more.
5.Startup manager: Clean useless apps when startup, which can free memory, speed up running speed and save power.
6.Uninstaller:Support batch uninstall unwanted apps .
7.Installer: Install apk files from SD card.
8. Sort apps: Easy find apps to uninstall by installed time, size, or name .
9.Program manager: Display all running apps and services, kill unwanted running apps and running service. Ignore list can protect fatal apps and services.
10.Cache cleaner: One click to delete all cache to free more memory.
11.Message clear: List all your messages, contacts and strangers. one click to delete messages..
12.File explorer: Manage mobile phone and SD card files: view, send, move, copy, rename, delete and add files.
13.Power monitor : Monitor running apps’ battery status. Huge power consumptive apps can be sorted out and killed.
14.Power save: Adjust screen brightness, timeout, turn off WIFI, Bluetooth, GPS, auto-sync, background data.
15.Device information: Display mobile phone’s information such like CPU, model, RAM, SD card, memory, screen, operator, network type, IMEI, roaming status, system version, and kernel version…
V2.0.2 updates:
1 Add Startup time notification selection. Notification disabled by default.
2 Add single item detailed optimization result.
3 Add notifications to show whether installed apps can move to SD card.
4 New process ending rules, release memory completely.
5 Fix accidental delete problems in deep clean. The next version will be more accurate.
6 Add more functions in Quick settings.
7 Fix Compatibility problems in some devices.
8 Fix some tiny problems.
Download : Here
THX i try

Huawei Private Space vs Samsung Secure Folders: how do they compare?

A few questions on Huawei Private Space vs Samsung Secure Folders
As per the subject, I’d like to understand how the two compare. I have a Samsung and am considering getting the Huawei P20 Pro. I have found a broad description of Private Space in this manual: https://www.devicemanuals.eu/wp-content/uploads/2018/04/P20-user-guide-EN.pdf
However, there are a few things I haven’t understood:
With Samsung Secure Folders, not all apps are immediately available: you have to manually select which ones you want to be made available and ‘reinstall’ them within Secure Folders. Does Private Space work the same way? Or does it immediately give you access to a ‘blank’ version of all your apps?
If it’s the latter,does Huawei provide an isolated sandbox like Samsung, or how do the two differ? The way I understand it, if you move Chrome to Secure Folders and then run it, you are not running the same executable file, but the one you have installed in the sandbox. With Huawei, are you running the same executable but then data is stored in a separate folder, eg the way a program is available to multiple users on the same PC?
Do the two offer a comparable level of protection and isolation, or is one of the two much better (if so, why?)? For example, if you download a file from a private space browser session, is it available outside of it? With the third-party app Parallel Space it is, for example https://play.google.com/store/apps/details?id=com.lbe.parallel.intl&hl=en_GB .
Does the Huawei thing work if you already have a work app to access work email set up as device administrator? This is what prevents Island from working on my Samsung, for example: https://play.google.com/store/apps/details?id=com.oasisfeng.island&hl=en_GB
Thanks!
SF vs PS
I used SF on Galaxy and since recently use PS on Mate 20 Pro, and a bit disappointed with PS, so looking for a better way of using it and see this thread which nobody seems to answer (?)
Both need to install selected apps, which is fine for me. However while SF is a space that can be used in parallel/concurrent with the normal space, PS is likely to create another user profile with encrypted data (true?), so it must be used exclusively.
However, switching from one mode to another is a pain with PS: needs long step (turn off screen then login, or long steps in setting); SF allows to be used in parallel (so same time) with main space (out of SF) and can quickly access the SF apps per task list. This is good, as we used the app in normal space but for certain data and apps we need to be in encrypted mode or protected with separated password/lock. PS can't do so, it must get out of PS to use normal mode and vice-versa, a pain for me, unless we have to install many more apps in PS as well, but then it will be redundance with normal space.
Another negative point with PS is app notification from PS, for instance, if we setup WhatsApp or another messenger in PS (or email? not tested) which use another account than the ones in main space. While we are in main space, the notification of new message in PS won't be shown so impossible to know that's there is new message. It's not a case with SF: notification still pass out of SF that we know to switch to SF to read, quickly, by task list for instance.
Data sharing or moving in out is not optimal from my viewpoint. Both work on main memory only, SF move in/out but limited number of files at a time, a pain if you have many files; PS... hum, the only way I find is thru obb folder, but this sounds to share and be visible to other users on this phones as well!!!! It is likely a Public folder rather than only for this user within both mode PS and non PS. Also, SF can be customised in setting to enable/disable clipboard between 2 areas while PS can't which is a pain too.
By the way, both SF and PS allow fingerprint to access this private space, but fingerprint is a joke for me (easily to hack) and I would not recommend it unless for temporarily use. I like the face recognisation (with eyes, a must, otherwise it's a weakness) mode of M20P, unfortunately this does not work in PS mode!
Samsung Secure Folder lacks multiple instance feature
Samsung's Secure Folder is more user friendly in term of ease of use than Stock android version of multiple user feature.
copying and moving files, opening app from the interface of main phone without logout and login another user like Stock android multiple user mode.
android's multiple user feature is shipped with some android devices, but others like Samsung just replace this feature with it's secure folder.
The biggest drawback of Samsung's Secure Folder is not possible to have multiple instance of it. you can only have one such Folder per phone.
every not fully trusted android app should run in an isolated space like Secure folder, and should offer some high level of control like, suspending(like power off), giving mock GPS, mock IMEI, IMSI etc.

Categories

Resources