yashsingh1/xdaforums huggingface dataset:
[Miscellaneous Android Development] J.Michael:
I did not have sqlite. I downloaded the zip 3.39.2 from the first post. I extracted arm64-v8a/sqlite3 and put it in ~/bin. (Like I said, I'm using Jack Palevich's Terminal Emulator for Android.) After fighting with the SELinux context defaulting to something inaccessible to me, I got to the point where I could run sqlite3 from the command prompt.

I did enough one-line runs to convince myself it was working, then tried using the interactive mode. It prints the opening paragraph, then the "sqlite>" prompt. I type (on the on-screen keyboard, it's an Android tablet) without seeing what I type. After resetting the terminal a few times, I found that if I type carefully, when I hit "Enter", I get a response. (Actually, I always get a response to "Enter", it just isn't rewarding if I've made any mistakes. And it's easy to get stuck in a seemingly endless loop of continuation prompts.)

When I googled, I tripped over a description of an at least vaguely similar situation whose resolution involved the developer saying something like he hadn't linked the libreadline library into the binary. I didn't know if it could work as well as it does if it was missing a library, so I didn't open with that.

Since it looks so much like having a terminal set to full duplex when the computer is set to half duplex, maybe I should see what other terminal types and settings are available. I just didn't expect this program to behave so much differently than all the others.
[Miscellaneous Android Development] DiamondJohn:
When I am trialing / testing something, I often use the path /data/local/tmp and copy the binary and set the permission & ownership there, and it appears to work for all cases I have tried thus-far. I have numerous utility/bootscripts that use this area to do extreme things.

One of the reasons I dont use interactive, when typing code, the terminal apps are painful. Most of the time, I get an ADB over WiFI connection, and then get the full functionality of the windows command prompt as the terminal. It removes most issues/short-commings with the terminal app, and gives me a full keyboard & copy-paste abilities. Copy paste is a pretty big deal breaker.

As I said, I dont edit the code, but simply compile whats there. And I have had no issues with the 3 or so ROMs/devices, I have run my compilation on. ie I think the code includes all the correct & required links, but your device/ROM may have issues.

Again, ADB Over WiFI is my personal choice of attack. Otherwise using TeMeFI (or boot/shell scripts) which instigates/creates a (often root) shell. My main need of SQLite3 is for my boot scripts. And I just ran some hefty utility scripts through an ADB over WiFi shell, earlier today.
[Miscellaneous Android Development] J.Michael:
No more problem. No idea why.

I extracted the armeabi binary, and interactive mode echoed what I typed. I tried the arm64 again, and now *it* echoed what I typed. I exited the terminal, opened a new terminal, and the arm64 *still* echoed what I typed.

Maybe one of the times I had grep'd a binary file did something odd to my terminal. But what could it do that would leave me able to type commands normally, and just affect the echoing of my input within a program? (It could be that sqlite3 is the first program I have run in a terminal in months that just sat there talking to me. Except for "vi", and I expect its I/O to be different.)
[Miscellaneous Android Development] DiamondJohn:
Again, if I understand what you are trying to describe, the "echo" of what you type is more likely an issue of the terminal emulator and not the sqlite3 binary. If you look at my own screenshots above, I noticed that the "echo" as I typed, was actually cursor point was about 4 characters to the left (or right depending how u want to describe) in position, BEHIND my cursor!??! 🤪 you can see in the image the cursor represented by the grey block is away from the >$ in post #50. Just another reason to use ADB over WiFI...
[Miscellaneous Android Development] DiamondJohn:
New Build 3.39.3 is now in the OP

In case anyone wants to have a go at doing their own build, attached is the "cheat sheet" I use to remember and perform the steps I do for the build. Also attached is the log of the build. So about 5min to actually perform the compile.

I did notice after I started the build there was an update to the NDK used to do the compile. But it was like BUILD r25b vs R25. So no biggy.
[Miscellaneous Android Development] DiamondJohn:
Built and posted new build for v3.39.4. See OP
[Miscellaneous Android Development] DiamondJohn:
Built and posted new build for v3.40.0

See OP

Attached below is the log of the build (provides a min level of confidence I am not altering the source between the source download and the build). I have a new PC (last one died), and now it appears to only take 3.5 Minutes, for the build process only; ie less time than starting the virtual machine and editing the make file to point to the latest version.

SQLite change log. https://www.sqlite.org/releaselog/3_40_0.html
[Miscellaneous Android Development] rodken:
v. 3.40.0 has not been posted as of yet.
[Miscellaneous Android Development] DiamondJohn:
It was, but it appears to have dropped off. I checked a few hours ago, and 66 downloads were made of v3.40.0.

I have now deleted some of the older builds (in case it was a size thing), and re attached 3.40.0

EDIT: oops, just noticed the previous version had 66 downloads....
[Miscellaneous Android Development] DiamondJohn:
FYI I’m still here, but away from my build PC, AND there has been no updated code release.

One interesting thing I did see, but didn’t test, I downloaded the latest adb and fasboot binaries to a windows pc, and there was an SQLite binary in the expanded directory. I didn’t test if it was windows or Linux. I assume windows as the adb and fastboot were for windows. Just interesting
[Miscellaneous Android Development] Araratik:
Hi bruh, please update sqlite. V 3.40.1 released
[Miscellaneous Android Development] alecxs:
@Araratik you are violating XDA forum rules. maybe if you tell us the exact reason why v3.40.0 isn't working for you, we won't beat you!
[Miscellaneous Android Development] Araratik:
what? Bruh, don't disturb me. A new sqlite has been released, according to your logic, why did the developer post new versions of the lib? Let the very first one remain, because it works))
[Miscellaneous Android Development] DiamondJohn:
@Araratik READ the OP, no where do I make any promises about maintain the latest build. read the title of the thread, it explicitly states the version that is released. I also give details in the OP on how to do a build yourself, and not depend on me. And it is simply rude to request me to do work for yo0u, for free. And hence the push back from @aIecxs. Although you are not explicitly asking for an ETA, you are requesting that the ETA is now. So yes, I also agree its breaking XDA rules.

And especially read post 5. Another rule of XDA I think is to read the first page of posts.

FYI (To everyone else) I have been away from my PC since dec 11 2022, so will take a few weeks to get back into the swing of things, but would plan on doing a new build/release
[Miscellaneous Android Development] Araratik:
I honestly don't know why you hate me so much.
[Miscellaneous Android Development] alecxs:
Nobody hates you, it's all about being polite "bruh"

;)

just wait for the next release
[Miscellaneous Android Development] Badger50:
I would highly encourage you to check your PM inbox. Thank you.

-Regards: Badger50
[Miscellaneous Android Development] DiamondJohn:
New Build 3.40.1

And boy was that a palava. I had to create and reinstall my linux Virtual Box and recreate the whole build environment! But its up in the first post.

https://xdaforums.com/t/new-sqlite3-binary-v3-40-1-for-all-devices.4273049/page-1

I updated using the build Magisc module feature within TeMeFI
[Miscellaneous Android Development] DiamondJohn:
New Build!

v3.41.0 Check the OP for download

https://xdaforums.com/t/new-sqlite3-binary-v3-40-1-for-all-devices.4273049/page-1

SQLite Release 3.41.0 On 2023-02-21
[Miscellaneous Android Development] DiamondJohn:
New Build!

v3.41.1 Check the OP for download

https://xdaforums.com/t/new-sqlite3-binary-v3-41-1-for-all-devices.4273049/

https://www.sqlite.org/releaselog/3_41_1.html
[Miscellaneous Android Development] DiamondJohn:
New Build!

v 3.41.2 Check the OP for download

https://xdaforums.com/t/new-sqlite3-binary-v3-41-1-for-all-devices.4273049/

Release Notes at:

SQLite Release 3.41.2 On 2023-03-22
[Miscellaneous Android Development] Oswald Boelcke:
Moderator Announcement

Thread cleaned on request of OP @DiamondJohn! Do not hijack foreign threads, and don't show disrespectful behaviour towards anybody. I'm convinced the OP will continue to report such posts also in future. Any future violator might expect more severe consequences to the XDA account. Thanks for your cooperation.

Regards

Oswald Boelcke

Senior Moderator
[Miscellaneous Android Development] DiamondJohn:
New Build!

v 3.42.0 Check the OP for download

https://xdaforums.com/t/new-sqlite3-binary-v3-41-1-for-all-devices.4273049/

Release Notes at:

https://www.sqlite.org/releaselog/3_42_0.html

edit: and yes, I know I have an extra space in the filename...
[Miscellaneous Android Development] Jacopo Mii:
I don't know why my post was deleted.

{Mod edit. Oswald Boelcke, Senior Moderator}
[Miscellaneous Android Development] Oswald Boelcke:
@Jacopo Mii The reason why your former post has been deleted can be found in my below quoted announcement that I'd posted immediately after the deletion of your post. Please read my announcement thoroughly again.

Regards

Oswald Boelcke

Senior Moderator
[Miscellaneous Android Development] DiamondJohn:
SQLite Guys have been quiet of late, but came across this post regarding the next release

SQLite Release 3.43.0 On 2023-08-24
[Miscellaneous Android Development] DiamondJohn:
New Build!​

v 3.43.0 Check the OP for download

https://xdaforums.com/t/new-sqlite3-binary-v3-43-0-for-all-devices.4273049/

Release Notes at:

https://www.sqlite.org/releaselog/3_43_0.html
[Miscellaneous Android Development] DiamondJohn:
NEW BUILD v3.43.1​

See OP for download

New SQLite3 Binary v3.45.2 for ALL devices

I built the latest stable SQLite3 binary for ARM devices. I built it as I have an app that I requires it, and distribute it with my app TeMeFI , as a lot of people asked to not have to install it as a separate step. TeMeFI app does a LOOOOOT of...

xdaforums.com

Release Notes at: https://www.sqlite.org/releaselog/3_43_1.html
[Miscellaneous Android Development] DiamondJohn:
NEW BUILD v3.43.2​

See OP for download

New SQLite3 Binary v3.43.2 for ALL devices

I built the latest stable SQLite3 binary for ARM devices. I built it as I have an app that I requires it, and distribute it with my app TeMeFI , as a lot of people asked to not have to install it as a separate step. TeMeFI app does a LOOOOOT of...

xdaforums.com

Release Notes at: https://www.sqlite.org/releaselog/3_43_2.html
[Miscellaneous Android Development] DiamondJohn:
New Build!

v 3.44.0 Check the OP for download

New SQLite3 Binary v3.45.2 for ALL devices

I built the latest stable SQLite3 binary for ARM devices. I built it as I have an app that I requires it, and distribute it with my app TeMeFI , as a lot of people asked to not have to install it as a separate step. TeMeFI app does a LOOOOOT of...

xdaforums.com

Release Notes at:

https://www.sqlite.org/releaselog/3_44_0.html
[Miscellaneous Android Development] DiamondJohn:
New Build!

v 3.44.02 Check the OP for download

New SQLite3 Binary v3.45.2 for ALL devices

I built the latest stable SQLite3 binary for ARM devices. I built it as I have an app that I requires it, and distribute it with my app TeMeFI , as a lot of people asked to not have to install it as a separate step. TeMeFI app does a LOOOOOT of...

xdaforums.com

Release Notes at:

https://www.sqlite.org/releaselog/3_44_02.html
[Miscellaneous Android Development] DiamondJohn:
New Build!

v 3.45.01 Check the OP for download

New SQLite3 Binary v3.45.2 for ALL devices

I built the latest stable SQLite3 binary for ARM devices. I built it as I have an app that I requires it, and distribute it with my app TeMeFI , as a lot of people asked to not have to install it as a separate step. TeMeFI app does a LOOOOOT of...

xdaforums.com

Release Notes at:

https://www.sqlite.org/releaselog/3_45_1.html
[Miscellaneous Android Development] DiamondJohn:
New Build!

v 3.45.2 Check the OP for download

https://xdaforums.com/t/new-sqlite3-binary-v3-45-2-for-all-devices.4273049/

Release Notes at:

https://www.sqlite.org/releaselog/3_45_2.html
[Tilt, TyTN II, MDA Vario III General] baron162:
I just received the replacement for a faulty AT&T Tilt. I have a ton of contacts and an extensive calendar already keyed in to the faulty Tilt and I was wondering if there was a quick and easy way to transfer all of that data on to the new Tilt without using Outlook Express, which I do not have and do not have much use for. The contacts and calendar are saved onto the phone itself, not the SIM card. Is there anything I can do? Thanks a lot.

BTW, I have Windows XP on my PC.
[Tilt, TyTN II, MDA Vario III General] Mark Crouch:
Depending on how "faulty" the faulty Tilt is, this might work....

Download PPCPimBackup from here onto your PC and use ActiveSync to copy the .EXE onto the faulty Tilt and the new one.

Download MyMobiler from here, install it on your PC and then run it so it displays the screen of the faulty Tilt. Use MyMobiler to load File Explorer and run PPCPimBackup, select to backup just the contacts and calendar. Next, copy the PPCPimBackup backup file via Windows Explorer from the faulty Tilt to your PC, then connect the new Tilt, copy the backup file onto it and then run PPCPimBackup on the new Tilt to restore the contacts and calendar.

Hope that helps :)

Mark.

PS. Feel free to post back if you get stuck - didn't wanna insult your intelligence by posting an "idiot's guide" ;)
[Samsung Galaxy S10 Questions & Answers] Orel6505:
I want to flash crDroid to my s10, and want to know if I can flash S-cam (samsung camera)
[Samsung Galaxy S8 Questions and Answers] gmkhamisani60:
Hello every one, I tried many ways but unable to unlock OEM kindly help me.
[Samsung Galaxy S8 Questions and Answers] stonedpsycho:
I believe this is a US Snapdragon variant where the bootloader cannot be unlocked, so you won't get the OEM unlock option.
[Samsung Galaxy S8 Questions and Answers] speedson:
Hi...

you didnt need to unlock the bootloader on samsung device....cause of this you also didnt have the option in Dev options.

Samsung devices didnt have a bootloader like Xiaomi or Huawai.

There are enough Tutorials in www where the Point "unlock the bootloader" is listet. But thats just bull****

I did modify a cup of Samsung Devices and never had a Option in Dev-Options to unl the Bolo^^ and it works every pretty well.

So your good to go...good luck

solong

speedson 🤘 🙃 🤘

hi...

no thats wrong my friend :)

solong

speedson🤘🙃🤘
[Samsung Galaxy S8 Questions and Answers] stonedpsycho:
The US varient (Snapdragon) has a locked bootloader and can not be unlocked like the Exynos varients can, he will never see the OEM toggle.

You say you have worked on Samsung before, does that include the Note 8 or S8?
[Samsung Galaxy S8 Questions and Answers] speedson:
Ok mate...just go to the TWRP Website and search for the s8/n8 snapdragon official TWRP....and you find what you are looking for. So ask yourself why the official TWRP is available if the bootloader cant get unlock? cause the true is...there is a way to paradis :)

Btw you also can take a look at xda snapdragon forum...ui costum roms available for that...so im sorry bro but your wrong ;)

solong

speedson 🤘 🙃 🤘
[Samsung Galaxy S8 Questions and Answers] stonedpsycho:
The OP has the US snapdragon varient, there is a Japanese Snapdragon varient (I think it's Japan) that is able to unlock the bootloader which is obviously the TWRP you are talking about, but this does not apply to the gentleman here. But please find me a TWRP for this gentlemans model number and then post it here, I'm always happy to be corrected if I am wrong like you suggest, but I think you will find that infact it is you who is wrong bro.

I await the TWRP link.
[Samsung Galaxy S8 Questions and Answers] speedson:
if i remenber correctly it was verizon and thats the united states
[Samsung Galaxy S8 Questions and Answers] stonedpsycho:
If you have a look at the thread below you will see how difficult it is to get a rooted custom rom for the OP's varient. There is no mention of TWRP but flashing different combination filmware files. Why would they go to all that trouble if they could just flash TWRP?

https://xdaforums.com/t/discontinue...e-snapdragon-n950u-u1-v8-bootloaders.4060707/

OP, if you read this do not try flashing the filmware in the link above as it's reported that devices can randomly brick, it is also no longer being worked on.
[Samsung Galaxy S21 Ultra] basilray:
I've begun noticing odd behavior w/ my S21 Ultra when I set it down on a flat surface.

Intermittently, I will hear what I initially thought was static/buzzing from a speaker. It's actually the phone buzzing/vibrating. This is not related to a notification, as I can reproduce it by setting the phone down a few times.

It appears to be the haptic motor running at a low frequency for no reason at all, and it will stop if I pick it up. You can feel the vibration coming from the top center of the device, and it creates an audible hum from whatever surface the phone rests on.

Anyone else seen similar?

I wouldn't think it's a software issue, but I may consider a factory reset. I'm running the U1 firmware on the U variant, but that doesn't seem like a logical cause.
[Samsung Galaxy S21 Ultra] NippleSauce:
I'd just check the settings menu called "system sound/vibration control" and then look at what's enabled for device vibration. Try disabling the vibration access to just ONE thing there at a time and see which one stops the idle vibration from happening.

If disabling one of those options prevents the idle vibration, then you'll know what to look into more specifically to resolve the issue. But without that information, there's not really a way that anyone here can diagnose the exact issue as it also might just be a screwed up/malware/other virus app that was installed... =(.

A family member of mine has an obsession with installing virus apps from the Play Store and then always complains about their phone being slow lol. So if you install more than 40 apps from the Play Store, then you're in the same boat as my family member (who for some dumb reason has over 100 apps installed from the Play Store lmao).
[Redmi Note Q&A, Help & Troubleshooting] chancellor31:
So, few weeks ago my phone was suddenly turned off and stuck in boot mode ( Redmi logo and reset again ) for almost an hour. I thought it just a random error because overheat etc. so im not really care about it because it fixed by itself.

Yesterday, i got that error again for 6 hours and at some moment i can successfully boot the phone. When i try to touch the power button, the power button suddenly keep pressing itself until sometimes the phone reboot again. Is that normal to get that kind of error? is it just a random error or is there anything i can do to fix the problem? thanks
[Touch Pro, Fuze ROM Development] StashCompInc:
Diamond radios can now be flashed to the Raphael.

Ive got 1.00.25.05 flashed right now and its a lot better than any Raphael radio.

I had some problems in the begining but Olipro helped me.

1st you security unlock, here : http://xdaforums.com/showthread.php?t=426609

2nd chose the option "Security Unlock" on you PDA in the last step and press "Commit Changes".

3rd download any Diamond radio (NBH) of choice .

4th you have 2 basic choices to make it flash:

1) extract radio from NBH, rebuild for Raphael (bit long winded but of course words)

2) open the NBH in a hex editor and substitute "DIAM*****" for "RAPH*****" or RAPH10000 or RAPH12000 (depending on whether your SPL screen says 100 or 120) - stick with wildcards first and use the exact values if it continues to complain.

I used this HEX editor : http://www.hhdsoftware.com/Products/home/hex-editor-free.html

Olipro recommends XV132 and its free.

5th now put the edited NBH (radio file) in the same folder as Raphael Custom RUU. Heres a link to the RUU : http://xdaforums.com/showthread.php?t=410761&highlight=customruu

6th now flash !

And remember all of this information was provided to me by Olipro via e-mail, without me even asking (I was using the unlocker again and again and he noticed so he shot me an e-mail). Im just passing the information further, all credit goes to them !

Keep up the great work everyone !
[Touch Pro, Fuze ROM Development] danielherrero:
Hi hope some cheef can convert the diamond radio roms to touch pro to avoid we brick out toys :)
[Touch Pro, Fuze ROM Development] guitarguy:
Can you please explain what exactly is better in the Diamond radio's compared to the Raph radios? IE Battery life, reception, GPS?

And of course this may be a stupid question (well, for sure a stupid question!) but how 'bout US 3G? :rolleyes:

Thanks!
[Touch Pro, Fuze ROM Development] Olipro:
nothing's better... but if you're bored and have nothing better to do...

OK, well, some will claim performance increases etc etc, the truth is, it's entirely subjective, and the current Raphael Radios are in fact just modified versions of new Diamond ones.
[Touch Pro, Fuze ROM Development] guitarguy:
That's what I figured... Same hardware, probably just slightly modified radios for both devices... Well, I'll keep my current radio for now until I hear something really ground-breaking...

Thanks for the quick reply!
[Touch Pro, Fuze ROM Development] StashCompInc:
I looked under phone settings and it does not show the US 3G 850MHz frequency. Which this radio (1.00.25.05) supports on the Diamond. Dont know what thats all about........

The reception (phone and data) is better and faster what Ive seen so far. Its 1040 PM here so will test GPS tommorow and need more time to see the differences in battery.
[Touch Pro, Fuze ROM Development] athanaso77:
Can you upload modified Radio?
[Touch Pro, Fuze ROM Development] cmonex:
it might not be entirely subjective, it depends on the area where you are. in any case the more choices the better.
[Touch Pro, Fuze ROM Development] cmonex:
the truth is, the raphael radios (both the ATT 1.01 and the "european" 1.02.25.31) support both 850 and 1900 Mhz 3G. it is confirmed because they've been flashed to a Fuze.
[Touch Pro, Fuze ROM Development] StashCompInc:
Does this mean that the Fuze has different hardware to support these ?

Ive deleted the radio I used to flash but I can make a new one if you want. Just tell me.

Edit : Ive just flashed from ROMeOS to DCS (latest) and the 850/1900MHz options are now visible in the settings. But I cant test them since Im in Sweden.
[Touch Pro, Fuze ROM Development] moisesz:
I'm in the US. If you send me one of the Diamond radios I can test it on different ROMs to see if 3G is enabled with the diamond radio.
[Touch Pro, Fuze ROM Development] StashCompInc:
Ok heres the Diamond radio Im using. Ive edited it to work on the Touch Pro.

Heres a link : http://rapidshare.com/files/146154003/Diamond_Radio_1.00.25.05.rar.html
[Touch Pro, Fuze ROM Development] adolfotregosa:
well i've just brought the security unlocker and did the hex editing and i confirm that the radio from diamond works. Going to test it the next few days.
[Touch Pro, Fuze ROM Development] moisesz:
thanks for the file. I downloaded it. Do Ihave to use the Hex editor or just flash it directly to my TP?.

update:

I've tried to to the Hex edit but I cannot find any reference as specified on the first post. I might require your help as I'm not an expert. :) thanks

I've tried both RAPH***** and RAPH10000 as specified in my SPL and during the flashing process I get to 100% but the last page shows "error[226]: Flashwrite... flashwrite error UI535.

I've tried a couple of times with no luck. any clues?