yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] vovasoft:
Powerful database editor with clean interface, SQL Editor, Table View, Form View and many more features.

[IMG="Feature Graphic"]https://firebasestorage.googleapis.com/v0/b/sqliteprime.appspot.com/o/feature_graphic.png?alt=media&token=7ee45e36-a73a-4329-a520-25e9ca9328af[/IMG]

Features:

Edit any app database like Contacts, Settings and other (Root needed)

Easy navigation inside Tables, Views and Queries result guaranteed by beautiful and clean interface

Manage Table data by using the built-in Table view and jump to any position or page

Edit databases from your favorite File Manager or use the built-in Browser.

Edit private app databases (Root needed)

Run custom sql from external file

Built-in Query Editor to run sql statements like SELECT, CREATE, DROP, etc

History to track all your previous queries

Auto Refresh of data after creating Tables, Views, Triggers, Indices

Configurable font size and column size

Form mode to easily view Tables with large number of columns

View and Edit fields of Blob type, Import/Export Blob data

Display the data definition language for tables, views, indices and triggers

Support for Without ROWID Tables

Copy the content of any field to the Clipboard by long pressing it

Without any ads

Limitations:

Opening databases from the External Memory Card and from Cloud is not yet supported.

Maximum supported size of blob data is 1 MB

[YOUTUBE]kTESrQEog_0[/YOUTUBE]

https://www.youtube.com/watch?v=kTESrQEog_0

Feel free to comment or ask for help.

Download from Google Play store

https://play.google.com/store/apps/details?id=com.lastempirestudio.sqliteprime

Also you can download it from these links:

https://sqlite-prime.en.aptoide.com/app

https://drive.google.com/file/d/14gEt57XnIbinlLYRCLnlxq8OpWxVILPD/view
[Android Apps and Games] vovasoft:
SqliptePrime updated to version 1.1.1

WHAT'S NEW

Added support for Blob data type.

Now you can:

Edit fields of Blob type

View Blob data in external app

Export Blob data

Optimized displaying long text

Fixed some bugs
[Android Apps and Games] vovasoft:
WHAT'S NEW

- Added Russian language

- Ability to move app to external storage

- Autoincrement option for Columns when creating a New table from the menu

- Added Settings

- Ability to Clear database history and Remove single database from history

- Resolved some minor errors
[Android Apps and Games] engelhro:
Hello,

The app has apparently been pulled from Google Play Store… :crying:. Any reason why? Has it been abandoned or will it come back? It was such a great tool!

I'd be happy to find it available again, or even development going on with new versions! :good:

Thanks for a short status update!
[Android Apps and Games] vovasoft:
Hi [MENTION=7420507]engelhro[/MENTION],

Thank you for the kind words. Yes, it was recently removed because I was using the Analytics service provided by Google itself which lets you know of crashes and number of users. Apparently with the new GDPR I will have to provide a Privacy policy which would explain what I do with the collected anonymous data.

I will probably just disable this service completely because I don't have enough time to look into it. I will try to upload it again afterwards which should solve the problem and restore the app.
[Android Apps and Games] engelhro:
Ah, superb news! Actually both: the app coming back :D and also getting rid of the Analytics module :good:.

Thanks a lot for your tool! Looking forward!
[Android Apps and Games] nec947:
Removed from Google Play
[Android Apps and Games] vovasoft:
Check the answer above ?
[Android Apps and Games] DE SEXIEST:
App can't be found on play store?

Where can I get the APK ?
[Android Apps and Games] engelhro:
Is it that difficult to read? Just a few posts up (the info is even on the same page!)…
[Android Apps and Games] mbirth:
Has been removed from the Play Store again, it seems.
[P3300, MDA Compact III ROM Development] spraggy:
Hi Everyone, does anyone know of a good SMS Lock for the pocket pc?

Basically i'm after one that hides a particular persons incoming text message via a lock or a program that if anyone tries to access your sms they need to input a password.

Any help would be great, thanks in advance.
[P3300, MDA Compact III ROM Development] smonte:
Just lock your device. Start > Settings > Lock
[P3300, MDA Compact III ROM Development] spraggy:
i'm talking about a program that hides certain messages not delete them or a program that stops you getting into your messages without a password, not the phone! but i'm sure you knew that.
[Xiaomi Redmi 2 Questions & Answers] Nobbienoob79:
My friend uses redmi 2 model no(2014818) 1gb variant he is using miui KitKat version and he wants upgrade can I flash any nougat ROM directly to phone by clean flashing from twrp? &

I am bit confused about model also is this wt88047 or wt86047?

Some help would be appreciated..

:)
[Xiaomi Redmi 2 Questions & Answers] hariGS:
First u should flash lollipop version of miui using fastboot method...then u can flash any custom rom of redmi 2 from twrp :)
[Xiaomi Redmi 2 Questions & Answers] Nobbienoob79:
Is there any guide that I can follow to flash firmware?If you have any link can you post it here that would be really helpful..
[Xiaomi Redmi 2 Questions & Answers] xehed:
Just flash global Dev. ROM from miui site, then once you in lolipop firmware, install twrp & flash the nougat rom ( no need fastboot, it's more difficult )
[Xiaomi Redmi 2 Questions & Answers] hariGS:
like [MENTION=2813885]xehed[/MENTION] said u can try recovery method

Download redmi 2 prime version of rom from here

if u have TWRP u just need lollipop bootloader to use custom roms so u can try this method too..

http://en.miui.com/thread-472108-1-1.html
[Xiaomi Redmi 2 Questions & Answers] Nobbienoob79:
I don't think redmi 2 prime variant will work on this device as this device has only 1 gb ram where as prime has 2gb ram

Correct me if I am wrong..
[Xiaomi Redmi 2 Questions & Answers] Riyanx55tu:
Im using the same device 2014818 1gb variant.

It is wt88047.

U can use custom roms on KitKat firmware without any problems.(no volte)

Dont flash miui Lp coz soon when u switch to kitkat again from lp miui u will face sim card switch issue due to changed baseband. And miui lp will be slow on 1gb ram variant. But in kitkat firmware , linagge os and other 6.0.1, 7.1.2 ROMs will work.
[Xiaomi Redmi 2 Questions & Answers] drbabusaha:
sir, can u suggest a good mm rom except mokee for R2 1gb???

---------- Post added at 09:28 AM ---------- Previous post was at 09:21 AM ----------

sir, is it safe to flash this bootloaders????

they are of which miui version???

my phn network always changing between 4g/3g/2g....is it due to bootloader???

sometimes network is not there, have to manually search....

my sim card is 4g..
[Xiaomi Redmi 2 Questions & Answers] Riyanx55tu:
1.For MM Stable Nx Rom by Anderson is stable and Tesla Os MM Stable.

2.Bootloader ( Firmware) There Are 2 Firmwares Available One is of Kikat and lollipop (Lp Firmware for volte ) they both are 50 mb. They can be flashed in twrp.

If ur using 2gb prime phone then flash lp firmware. Get it from xda threads.

Then flash a custom rom or miui lp and get volte function.

3. Manually set to 4g network from dialing *#*#4636#*#*

Enter into phone information and select lte , it won't go back to 3g or 2g then.

If u want the firmware links PM me.

4. Once u flash lp firmware u won't be able to work on miui kitkat. So when u flash miui lollipop the phone performance will be so slow due to 1gb ram..it isnt enough for background apps to run. So if u want to revert and go back to miui KitKat just make a backup of miui kitkat (System, boot , firmware ,Efs <- (efs is important coz it contains imei number which gets sim working) before flashing lp firmware. So u can restore easily from twrp.
[Xiaomi Redmi 2 Questions & Answers] drbabusaha:
nx rom build number sir?

for tesla there r 2 variants, one by premaca developer, another by different developer, which tesla build is better????
[Xiaomi Redmi 2 Questions & Answers] Riyanx55tu:
Nx build 10.4 Marshmallow End Build - https://androidfilehost.com/?fid=24588232905725189

Tesla Marshmallow Build - https://androidfilehost.com/?fid=24591000424952571

Tesla build is better but nx is good for battery bkup. Both are stable thou.?
[Xiaomi Redmi 2 Questions & Answers] drbabusaha:
thanks sir

wht abt mokee????

will it work on 1gb R2?

can i root?

---------- Post added at 09:20 PM ---------- Previous post was at 08:29 PM ----------

for nx 10.4 do i have to flash gapps???
[Xiaomi Redmi 2 Questions & Answers] Riyanx55tu:
Yes all custom roms doesn't provide gapps...install arm pico gapps

Mokee rom i tried few months later, it had battery draining issue.

Root access is already available in developer options no need of supersu.

Im having the same device as u have. Don't flash custom kernels it has overclocked cpus nd gpu and doesn't provide good multitasking.
[Xiaomi Redmi 2 Questions & Answers] drbabusaha:
which mokee version u used sir???

release or history?
[Xiaomi Redmi 2 Questions & Answers] Riyanx55tu:
Idk might be previous version from new build...try it out its a nice rom.
[Honor 9  Questions & Answers] paulopcf:
Hello guys!

I successfully flashed B150 firmware on my phone but now the capacitive buttons don't work.

Is there any way to get the buttons back without reverting to B120 firmware?

Thanks for your help.
[Honor 9  Questions & Answers] pijes:
Have you checked the navigation key in settings?
[Honor 9  Questions & Answers] paulopcf:
Yes, I checked that.

I can change the configuration (Back button on the left or right) but nothing works.

Only the home/fingerprint button is working.
[Honor 9  Questions & Answers] Pumpino:
You could try clearing the cache in recovery mode. I believe this solved this issue for someone else after upgrading to a previous version.
[Honor 9  Questions & Answers] paulopcf:
Thank you but I also tried that.

I cleaned cache and dalvik cache but the buttons still don't work.

I'm desperate here.

I would really appreciate any help solving this problem. :(:(
[Honor 9  Questions & Answers] Pumpino:
You could try factory reset, but who wants to do that? ;)
[Honor 9  Questions & Answers] paulopcf:
:

:D

Tried that too.

Doesn't work.

:mad::mad:
[Honor 9  Questions & Answers] Pumpino:
I'd try flashing the ROM again.
[Honor 9  Questions & Answers] paulopcf:
Tried flashing the Rom again and still didn't fix the issue.

I gave up and downgraded to B120 and got the buttons working again.

Don't know what happened. I hope someone posts a fix for this soon.
[Honor 9  Questions & Answers] paulopcf:
How did you flash the firmware?
[Honor 9  Questions & Answers] Agadoo:
I lost the capacitive buttons too.

Only multifunction menu button work.

I reflash c432b150 without rebrand [link] but the capacitive dont work.

Need help!
[Honor 9  Questions & Answers] Agadoo:
I flash RR rom + vendor and there work the button.

After Factory reset, low lewel format. Next flash stock b130 and b150 too, but in stock rom doesn't work.

WHY???
[Honor 9  Questions & Answers] Midhon58:
Except from the B120 firmware there seems to be a bug that causes the lost of the capacitive buttons if you directly flash the stock rom on your device. Only way is flashing B120 and waiting for OTA to appear.
[Honor 9  Questions & Answers] Agadoo:
Ok, tomorrow i will try flash b120 firmware with FF proxy.
[Honor 9  Questions & Answers] Agadoo:
I used this guide: [link] without rebrand.
[Honor 9  Questions & Answers] Agadoo:
I did C432B120 downgrade with myself modified hwota.sh file and hwota.zip method.

After reboot and the capacitive buttons worked.

Next unlocked BL and rooted phone.

Work everything perfect.
[Honor 9  Questions & Answers] paulopcf:
I upgraded from B120 to B150 with Firmware Finder through proxy and the buttons were working perfectly.

However, after I flashed TWRP recovery, the buttons stopped working again.

So I guess the buttons issue is caused by TWRP recovery.

Is there any way to fix this in TWRP?
[Honor 9  Questions & Answers] Agadoo:
I upgrade too b120 to b150 with FF.

Then unlock BL again -> low level format -> reboot fastboot mode ->flash twrp [this] and reboot recovery -> wipe internal sd (because when twrp start this partition was corrupted) -> install SuperSU-v2.82-SR2-20170808115921.zip for root (this work together with capacitive button)
[Honor 9  Questions & Answers] paulopcf:
OK, thanks, I'll try that.

Question:

After flashing twrp you just wiped the internal storage? There is no need to wipe cache or data?

Thank you for your help.
[Honor 9  Questions & Answers] Agadoo:
Yes, just internal sd.
[Honor 9  Questions & Answers] FlyingMachete:
Did this work out for you mate? Trying to recover my capacitive keys as well here... Lost after flashing the temporary TWRP 3.1.1.
[Honor 9  Questions & Answers] paulopcf:
Well, actually I didn't try it.

I just gave up, returned to original B120 firmware and updated to B150 via Firmware Finder.

My phone is not rooted now, but I got the capacitive keys working again.

I think the problem is caused by TWRP 3.1.1.

I'll wait for the next twrp and try it again.
[Honor 9  Questions & Answers] FlyingMachete:
Ok thanx a lot for your reply! I'm on B150 now, please where do you find old B120 to downgrade?
[Honor 9  Questions & Answers] Midhon58:
You can find it in the rebrand guide.
[Honor 9  Questions & Answers] OldDroid:
for me the issue appeared on b170, afterwards i downgraded again to b130 and updated to b150, fine so far, once i unlocked the bootloader the issue appeared again..

and then it magically disappeared after some days on b150..

to note: just the bl unlocked, no twrp installed
[Honor 9  Questions & Answers] pijes:
just now my left capacitive button suddenly stopped working. the battery was about 17% left. but when I plugged the phone into the charger it went back to normal again
[Honor 9  Questions & Answers] tom195:
Could anybody send me links to B120 software, because I don't see this links anywhere.
[Honor 9  Questions & Answers] FlyingMachete:
Search for the "rebrand" guide mate, links in there. ?
[Honor 9  Questions & Answers] Andreus94:
Hi guys isn't there a way to use a soft navbar?
[Honor 9  Questions & Answers] pijes:
I always have Simple Pie app installed and placed it on the side in the middle of the screen
[Honor 9  Questions & Answers] Andreus94:
Is this app battery friendly?
[Honor 9  Questions & Answers] pijes:
so far it always sit at the bottom of the list in the consumption level, using less than 1mah
[Honor 9  Questions & Answers] Andreus94:
Great ;)

My H9 should arrive next week, I'm doubting about soft touch buttons, are they easy to use or are unconfortable?
[Honor 9  Questions & Answers] FlyingMachete:
Easy to use for sure. But even easier to lose. :laugh:
[Honor 9  Questions & Answers] Morphine1:
Guys im on b130 after a brick, installed b130 via 3 buttons

Bootloader got relocked.

How can I go back to b120? Need to unlock again?
[Honor 9  Questions & Answers] Blaze Falconburger:
I lost my buttons at some point after upgrading to B170 - I think they worked straight after the upgrade, but went at some point after unlocking the boot loader &/or installing TWRP. This must be a software issue if reflashing or downgrading resolves it, so there is hope it will be a simple fix for this, permissions or config file I think
[Honor 9  Questions & Answers] Cuthbert1337:
Any news on that? Lost my navigation buttons after unlock and flashing twrp. Flashing erecovery, relocking, and factory reset did not help (on B130). Upgrade to B150 also did not solve the problem...

Is B120 the only solution so far?
[Honor 9  Questions & Answers] andruman33:
Hurray! installing B120 with the rebrand technique worked with some difficulties and the capacitive buttons work again. what a pain in the ass
[Honor 9  Questions & Answers] Honor9Fan:
[MENTION=8752977]andruman33[/MENTION]: Can you tell me / us how you have done the downgrade to B120 please? I think some of the steps in the rebrand thread are not necessary. I also only need to make a downgrade so my buttons, light and flashlight work again.

Yes, its not only the buttons that are not working. Also light and flashlight for camera are broken! Its a unuseable phone with these bugs.

EDIT: Got it working with downgrade to B120. Buttons and flashlight are working again and root is also working without problems. So i will stay at B120 and all is fine!
[Honor 9  Questions & Answers] FlyingMachete:
Why you guys downgrade to solve issues when you can upgrade to freakin OREO by following such a thorough guide as [MENTION=4960686]OldDroid[/MENTION] 's one in that optic... Get our side of the fence, hang with the cool kids. :D
[Honor 9  Questions & Answers] Cuthbert1337:
[MENTION=8761086]Honor9Fan[/MENTION]: at least for me it was basically the rebranding thread without step 7 or so. I also noticed the flashlight wasn't working, after unlocking and flashing twrp.

In this process of getting back to stock I got stuck in a boot loop into error mode because of missing recovery. I don't know how this happened, probably false action in hwota tool. If this happens the only thing that helps to boot into fastboot mode is to wait until battery is at 0%. Then after several tries of power + volume dn I got into fastboot mode and could do the process again (let battery charge a little bit after booting to fastboot).

Since then I updated via firmware finder proxy to B150. Everything works fine beside root :crying:.

[MENTION=7755744]FlyingMachete[/MENTION]: is this Oreo version stable on L09?After going through this unpleasant process described above, I'm not willing to go there again.

What I'm waiting for is a twrp able to read encrypted partitions and flashing supersu on that. Can you be encrypted and rooted with Oreo by [MENTION=4960686]OldDroid[/MENTION]?

Besides Oreo is already at beta for Europe so I think it is coming to our honor 9 soon enough.
[Honor 9  Questions & Answers] FlyingMachete:
Stable as F mate, it's my daily driver, rooted of course, cannot live else way. The guide takes you there for system modification, it just describes and provides the tools to unroot afterwards as a recommendation... And honestly, the process was a breeze, one shot, no issue.

Oh and on L-09 of course.
[Honor 9  Questions & Answers] Cuthbert1337:
And encryption is also working?
[Honor 9  Questions & Answers] andruman33:
Well I started out wanting to flash Resurrection Remix which didnt work and wasted couple of evenings trying to get the phone working again. Since I now have a working method of getting the phone back to B120 I might as well try flashing OREO. I really want root for titaniumbackup.

I'll try and report back

cheers mate
[Honor 9  Questions & Answers] Honor9Fan:
[MENTION=7755744]FlyingMachete[/MENTION]: Freakin Oreo? Sorry, but i dont like Oreo.

And why i should use a unstable Beta Version instead of a really nice working stable firmware? Because i wanna be a "cool kid"? No, thanks. Iam a clever man instead. ;)
[Honor 9  Questions & Answers] FlyingMachete:
Have you tested before claiming something "unstable"?

Also claiming yourself clever is a thing, proving it while understanding the sarcasm in "cool kids" is another. ;)
[Honor 9  Questions & Answers] andruman33:
I tried upgrading to OREO and now my device is bricked. Now I cant even manage flashback to stock...

F:\handy\h9>fastboot flash recovery twrp-3.1.1-1-stf.img

target reported max download size of 471859200 bytes

sending 'recovery' (32028 KB)...

OKAY [ 0.681s]

writing 'recovery'...

FAILED (remote: partition length get error)

finished. total time: 0.693s

I have really no clue whats going on

Im tempted to smash this phone with a hammer :( nothing but a pain in the ass and I only wanted god damn root for my titanium backup.
[Honor 9  Questions & Answers] kac222:
You must use command :

fastboot flash recovery_ramdisk twrp-3.1.1-1-stf.img

Wysłane z mojego STF-L09 przy użyciu Tapatalka
[Honor 9  Questions & Answers] mkln:
I just lost the capacitive buttons and the flash as well, on stock B130, right after flashing TWRP....
[Honor 9  Questions & Answers] oslo83:
Today on B180, right after flashing TWRP, I lost capacitive buttons aswell but not the flash nor flashlight.

Flash is still working for me on B180 after a TWRP 3.1.1-1 nougat flash.
[Honor 9  Questions & Answers] hassanjavaid8181:
Which twrp you flash??
[Honor 9  Questions & Answers] yokese:
Same problem here. But, flash or flashlight, works sometimes (hardly ever).

Expecting someone finds a solution soon....
[Honor 9  Questions & Answers] xequtor:
I also lost capacitive buttons after flashing twrp-3.1.1-1-stf.img, I'm on B150

flash and flashlight also not working
[Honor 9  Questions & Answers] FearFac:
Follow https://xdaforums.com/honor-9/how-to/stf-l09c432b130-capacitive-buttons-100-t3729106
[Honor 9  Questions & Answers] 4nthe:
No capacitive buttons on stock STF-L09C432B120

The rebrand guide did not work for me. I'm on stock STF-L09C432B120 now, but my capacitive buttons are not back (flash and flashlight are working though).

I had OpenKirin's RROS v5.8.5 / OpenKirin's TWRP 3.1.1-1 running for 3 weeks without problems. But after I updated Magisk, I was stuck at the lockscreen. Every time when I entered my pin, the screen went dark for a second. When it went on again, I was still on the lockscreen. So I recovered a backup that I made before via TWRP. This got me rid of the lockscreen-problem, but since then the capacitive buttons are gone.

So I followed the rebrand guide, but as mentioned, this did not work. I also tried it via /dload, but without a positive result.

My next step would be to install Oreo (since somebody wrote, that this brought him the buttons back), then rollback to B120 and install RROS again. But this seems very experimental and unsure to me.

Do you have any other ideas what I can do now? Any help would be very appreciated!
[Honor 9  Questions & Answers] Rimasi89:
Yes i've lost my capacitive buttons too after rebranding from STF-AL00 to STF-L09C342B180 ... I don't have TWRP or Bootloader unlocked because it has all restored by the rebranding process but is it possible to get to B180 through B120 to B130 to B150 and so on? If yes i'll do that because i don't need root or TWRP or bootloader unlocked.

Has everyone tried that?
[Honor 9  Questions & Answers] Midhon58:
Yes, it's possible over OTA, just install b120 and then directly b180 with Firmware Finder Proxy if you don't want to wait for automatic OTA.
[Honor 9  Questions & Answers] WFree:
I've installed twrp on b180 but now I've lost functionality of the two capacitive buttons. Now I've flashed back stock recovery and full b180 but the problem remain.

I want try to downgrade to the previous version (yesterday the phone updated to b180) but I don't remember right which was the previous between b130 and b150.

By the way can I downgrade from b180? Can I do directly b180>b130 ? Or should I do b180 > b150 > b130 ?

How to downgrade? With this method: https://xdaforums.com/honor-9/how-to/guide-honor-9-t3653719 ?

My current version is stf-l09c432b180.

EDIT 1 ---------

- Flashed b150 over b180 with rebrand method: Bootloop!

- Exit of bootloop after unlocking again bootloader.

- With b150 buttons still not working.

- Downloading b130 to try with this...
[Honor 9  Questions & Answers] Rimasi89:
Ouh ok is it possible?

I thought it would only be possible to update manully to B130.. I'll give it a try ;)

---------- Post added at 03:51 PM ---------- Previous post was at 03:49 PM ----------

To downgrading did you use the rebranding guide?
[Honor 9  Questions & Answers] WFree:
yes, why?
[Honor 9  Questions & Answers] Rimasi89:
I'm trying to update from B130 to B180 through FF... I'll send feed when it's done ;)
[Honor 9  Questions & Answers] WFree:
What is FF? Firmware Finder?

I'm now to downgrade b150>b130 just now.