Which SQLite Editor is best? - Sprint Galaxy S 5 Q&A, Help & Troubleshooting

I see quite a few editors in the play store but none stands out. Looking for input based on experience. Thanks!

BillyBob3 said:
I see quite a few editors in the play store but none stands out. Looking for input based on experience. Thanks!
Click to expand...
Click to collapse
I always liked this one https://play.google.com/store/apps/details?id=com.speedsoftware.sqleditor
Seems like every one I have tried adds a space if you try to modify a comma separated list though, which could be bad for modifying some system db settings. I usually end up doing it from the terminal.
Sent from my SM-G900P using xda app-developers app

Related

[APP] MySQL Manager

I'm trying to get a feel for what kind of demand there is out there for a MySQL manager for Android.
Obviously there's only going to be a small niche of people who would want/use one, myself included, so I guess I wanted to get the feedback of the people on these forums to see what demand is like.
I'm currently building one that I plan to stick on the Android Market in the next week or so, and I'll let everyone who expresses interest know when that happens. The first version I put out will be a "lite" version. Features will include:
Create/Edit/Delete server/db credentials
View a list of all Tables, Views, and Stored Procedures in a db
View first 100 records of any Table or View
Drop Tables, Views, and Stored Procedures
Add/Edit Views
Add/Edit Stored Procedures
Run custom queries
If the demand and responses are good, I will completely re-do the UI, add some nice graphics, and put out a much more feature-rich version. Not going to waste my time to do that, though, if I don't feel there is enough need.
Thanks in advance to everyone who responds!
-teleknEsis
Any plan for SSL authentication like desktop client?
Sent from my Nexus One using XDA App
jameztcc said:
Any plan for SSL authentication like desktop client?
Sent from my Nexus One using XDA App
Click to expand...
Click to collapse
Probably will be in the full version
teleknEsis said:
Create/Edit/Delete server/db credentials
Run custom queries
Click to expand...
Click to collapse
I would definitely use this. Personally, running custom queries would be the only thing I would use it for tho (i'm a sql/command line ninja haha). Hard saying how often I would use it. Currently I just ssh into a nix box and use mysql client from there when I'm remote/without a laptop and need to fix something.
teleknEsis said:
Probably will be in the full version
Click to expand...
Click to collapse
Look forward to it. Thanks.
Sent from my Nexus One using XDA App
jameztcc said:
Look forward to it. Thanks.
Sent from my Nexus One using XDA App
Click to expand...
Click to collapse
I have released the initial version of my app on the market. Search for AndSQL.
Keep in mind, this is a very rough first version and is not intended to be complete with features. If response/feedback is good I will re-do UI, add graphics, and style it. Any feedback is greatly welcomed. Thanks!!
-teleknEsis
Can't find on the market, is there a download link?
Also, about "Run custom queries" is there the option to save/load the queries too?
I will appreciate that because i often run the same queries, so i save and load them when i need
__max__ said:
Can't find on the market, is there a download link?
Also, about "Run custom queries" is there the option to save/load the queries too?
I will appreciate that because i often run the same queries, so i save and load them when i need
Click to expand...
Click to collapse
As of right now there is not. This would be a feature I would definitely add if I decide to make a 'full' version. This was really more or less just a quick tool I made for myself to do quick db edits/checks on the fly when problems are reported. It has a ton of potential, I'm just not sure how large the demand is for a 'full' version of this.
My app targets 2.1 and up so not sure why you don't see it in the Market, but I'll go ahead and post it in the OP. Look for it there.
Ok, thanks for reply, it's quite useful already to do quick and emergency checks.
I'm on froyo now, so i should be able to find it in the market...
__max__ said:
Ok, thanks for reply, it's quite useful already to do quick and emergency checks.
I'm on froyo now, so i should be able to find it in the market...
Click to expand...
Click to collapse
Did you ever find it? I posted it in the first post in case you never did find it in the market.
got it from market , thanks!
Sent from my Nexus One using XDA App
Downloaded from here.
It seems to connect, at least i don't receive any error, but i don't see the tables/views/sproc, and if i try to run a query the result is empty..
Tried with 2 different db on 2 different servers.
Sent from my Nexus One using XDA App
__max__ said:
Downloaded from here.
It seems to connect, at least i don't receive any error, but i don't see the tables/views/sproc, and if i try to run a query the result is empty..
Tried with 2 different db on 2 different servers.
Sent from my Nexus One using XDA App
Click to expand...
Click to collapse
There's likely a bug in my connection error reporting. If you're not seeing any tables or views then there's probably something wrong w/ your connection settings.
Make sure your MySQL db is set to allow remote connections, and also verify that the port you specified is correct. Hope that helps
Im' pretty sure everything it's ok, from my home pc i can connect without any problem...
__max__ said:
Im' pretty sure everything it's ok, from my home pc i can connect without any problem...
Click to expand...
Click to collapse
Hmmm well works fine for me with several different MySQL db's on different servers, different hosting solutions. I'll make sure connection error reporting is working tonight and submit an updated app for you.
Thanks, i appreciate the effort
Sent from my Nexus One using XDA App
Great APP! Thanks for sharing and developing this app!
hi... anyone knows an app like MySQL Manager for windows mobile 6.5? thanks...

[Developer] Any Interest??

***Developers Read***
I Have Four App Suggestions For Any Developers Willing To Take On Any Of The Projects!!
{Suggestion #1}.... Is A App That Can Be Run To Fix Parse Issues Sometimes Associated With Installation Of Apps, And If It Can Fix The Parse Issue, Specify Why!
{Suggestion #2}.... Is A App That Basically Asks Where On The SDCard (Or If Possible, Even Desktop) You Would Like The Current App To Be Installed, Similar To A Desktop Computer, Which Gives The Option To Choose Exact Folder/Desktop Location!!
{Suggestion #3}.... Might Be Reaching On This One, Lol!! But....
It's A Request For A App That That Makes Apps, It Would Basically Have "SIMPLE" Hooked On Phonix Options, For How Or What The User Would Like To Create!! Like I Said Probably Reaching Huh? Lol!!
& Finally Probably The One I'm Hoping For The Most....
{Suggestion #4}.... This Suggestion Is For More Options In The XDA App It Self, Such As.... The Ability To Bookmark Forum Page, Directly Return To The Last Page ( After Closing App), Upload Apps/Scripts Directly From Phone ( Instead of Home Computer), Edit Profile (Pictures), & Also Fried Request!!
Hopefully Someone Will Like At Least One Of These Ideas And Try To Bring It To Life...
Also.... I'd Like To Give A Quick Thanx To All The Developers!!
Sent from my HERO200 using XDA App
I'm not a developer, but in response to number 4. The XDA app is actually built off another app named Tapatalk Pro. The folks at Tapatalk Pro made this app special for us XDA users.
If you want a feature added, I would suggest contacting them. Best of luck on the rest!
dkelle4 said:
I'm not a developer, but in response to number 4. The XDA app is actually built off another app named Tapatalk Pro. The folks at Tapatalk Pro made this app special for us XDA users.
If you want a feature added, I would suggest contacting them. Best of luck on the rest!
Click to expand...
Click to collapse
Okay, I Will "Try" To Contact Them...& Hopefully They Will Consider My Suggestions.... Either Way, Thanx For The Information Man!!
Sent from my HERO200 using XDA App
PMGRANDS said:
{Suggestion #3}.... Might Be Reaching On This One, Lol!! But....
It's A Request For A App That That Makes Apps, It Would Basically Have "SIMPLE" Hooked On Phonix Options, For How Or What The User Would Like To Create!! Like I Said Probably Reaching Huh? Lol!!
Click to expand...
Click to collapse
Maybe reaching a bit if you want to create apps on your phone. Google has a tool called App Inventor that will help you create apps in a web browser on your computer:
http://appinventor.googlelabs.com/about/
What you are looking for is often called Rapid Application Development, or RAD. Searching for Android RAD doesn't help much, but it does show that there are other people looking for Android RAD.
brucemcl said:
Maybe reaching a bit if you want to create apps on your phone. Google has a tool called App Inventor that will help you create apps in a web browser on your computer:
http://appinventor.googlelabs.com/about/
What you are looking for is often called Rapid Application Development, or RAD. Searching for Android RAD doesn't help much, but it does show that there are other people looking for Android RAD.
Click to expand...
Click to collapse
Thanx For Your Info Man.... Appreciate It!!
Sent from my HERO200 using XDA App

[Q] Prevent Youtube from clearing search bar?

I get the feeling many don't feel the same as I do (I get this feeling from my utter lack of success on Google with this), but is there a way to prevent the Youtube app from clearing the search bar after every search?
I like to watch a lot of episodic content and, of course, I would search for it using terms like 'Comedy Show Episode 01', but doing this is a bit more difficult due to how the Youtube app seems to clear the search bar after every search. Of course, if I also misspell a word during my search, I'd end up after to rewrite the entire thing.
Is there a way/tweak to allow my search queries to remain?
Copy it to your clipboard the first time you type it and change the number.
Sent from my SAMSUNG-SGH-I727 using xda premium
Sheolrock said:
Copy it to your clipboard the first time you type it and change the number.
Click to expand...
Click to collapse
Well, thanks for suggestion about copy/paste, but the reason I didn't use that to begin with is that I'm usually inter-switching between using Youtube, surfing various information websites, reading Kindle books, commenting on websites, and etc. More often than not, my clipboard is already filled with some other important notes I intend to use later.
Yes, I also understand I could simply copy/paste the note somewhere else to re-use the clipboard, but I was hoping for a quicker/simpler solution. If there isn't one, I will do it that way, but just keeping a bit of hope.
Ya I see why that wouldn't really work.
Sent from my SAMSUNG-SGH-I727 using xda premium
Sheolrock said:
Ya I see why that wouldn't really work.
Click to expand...
Click to collapse
Well, no matter. There doesn't appear to be any solution to my issue, so I guess using the clipboard in tandem with a note app is the only method available to me.
Thanks for responding to my thread.

[APP][ROOT][4.0+] SMS Limit Tool

Some time ago, I posted an app that would raise the limit on the number of SMS Messages that could be sent before seeing the ever-annoying warning dialog that you text too much. However, this app only worked on JellyBean 4.1 and was very ROM specific, so I set out to improve upon the idea a little.
The "new" app will work on ANY (to my knowledge) rooted device running Android 4.0+ and allows you to set the limits yourself (within reason). Basically, just load it up, set your limits, click apply, and reboot. The settings will stick unless you wipe data or factory reset your device and I included an option to return to defaults if need be.
There is a known problem with the reboot binary on some HTC devices not playing well, so you may have to reboot manually. Please let me know if you encounter any other problems with it and I'll work through them.
You can grab the apk from HERE. There is an identical donate version available from the market if you're feeling generous.
Play Store Link
Works great for me! Thanks!
Thanks, my spare phone is doing auto-forwarding duties nowadays and this was just what I needed =)
will this work on rooted Gingerbread (2.3.4) ? - specifically:
Virtuous G-Lite v2.0.1 :: GB AOSP HTC/G2 base 2.16.531.5
Does gingerbread have the limitiation? I know froyo doesn't, I only need this for my Jelly Bean S2.
If GB has a limit, it's handled differently and this won't work on it.
Sent from my Galaxy Nexus
Thanks. It's just what I needed.
Thanks. :good:
Do you know if it's possible to just read the "sms_outgoing_check_max_count" actual value without root?
I'm guessing probably not. The value isn't present in the database unless it is changed from the default. Depending on the device, Android version, and carrier, the default could be stored anywhere in XML or code, so I can't even venture a guess as to the values.
Sent from my SCH-I605
erishasnobattery said:
I'm guessing probably not. The value isn't present in the database unless it is changed from the default. Depending on the device, Android version, and carrier, the default could be stored anywhere in XML or code, so I can't even venture a guess as to the values.
Sent from my SCH-I605
Click to expand...
Click to collapse
Thank you. :good:
So basically SMS Apps can't do anything about it until google decides to let the default value be customizable (like in cyanogenmod).
Hope they change their mind.
Xenxda, maybe yes, using Xposed.
Xposed seems to need root access on installation because it replaces a file in /system/bin.
Thanks for the great app with free version :thumbup:
PS: If i uninstall the app, will the limit I set using the app will remain?
Sent from my Z120
mark_sgy said:
Thanks for the great app with free version :thumbup:
PS: If i uninstall the app, will the limit I set using the app will remain?
Sent from my Z120
Click to expand...
Click to collapse
Unless you clear your data in some way, shape, or form.
Sent from my SCH-I605
Thanks for the great tool! For those of us (me) who would rather not install another app, could you please provide the process? I like to do things manually for certain things so I have googled a little bit; I believe it's essentially finding the right file with SQlite Editor and either adding a value or changing an existing one. Any help would be appreciated!
kwest12 said:
Thanks for the great tool! For those of us (me) who would rather not install another app, could you please provide the process? I like to do things manually for certain things so I have googled a little bit; I believe it's essentially finding the right file with SQlite Editor and either adding a value or changing an existing one. Any help would be appreciated!
Click to expand...
Click to collapse
Instructions in this thread http://forum.xda-developers.com/showthread.php?t=1831289
[Fix] Jelly Bean SMS Warning Dialog
Sent from my SCH-I605
Thanks. Seems like in 4.1.* systems, the sqlite modification needed to be made in the 'secure' part, whereas in 4.2.* systems, it needs to be made in the 'global' part. Is that accurate?
kwest12 said:
Thanks. Seems like in 4.1.* systems, the sqlite modification needed to be made in the 'secure' part, whereas in 4.2.* systems, it needs to be made in the 'global' part. Is that accurate?
Click to expand...
Click to collapse
That is correct.
Sent from my SCH-I605
This doesn't seem to be working for 4.3
Anyone else have the same issue?
Sent from my Nexus 4 using xda app-developers app
DarkShadowAy said:
This doesn't seem to be working for 4.3
Anyone else have the same issue?
Sent from my Nexus 4 using xda app-developers app
Click to expand...
Click to collapse
Most likely because superuser is barely working properly in 4.3.
Sent from my SCH-I605

How to access IOTHiddenMenu?

So I am on CleanROMm 8.2. Yeah a little bit outdated. I have tried all the dialer methods and the creating a shortcut method with a different launcher. The hidden menu option does not appear in any of the activities in both Nova and Launcher Pro. I want to check if my phone is refurbished. (I know random for a phone this old), but I love it. So I want to check.
Anyone have any suggestions?
IOTHiddenMenu exists when I look it up in my apps. Just need to access it.
Any help will be greatly appreciated.
Thanks.
if your handphone was root, you can try edit file build.prop in /system
or download app build prop editor in Playstore, and add this
Code:
Property name: sys.hiddenmenu.enable
Property value : 1
Tried editing in build prop. No luck. I also added this property and value. Just can't access the menu anywhere. Not even in shortcuts!
Thanks for the help though!
996 said:
Tried editing in build prop. No luck. I also added this property and value. Just can't access the menu anywhere. Not even in shortcuts!
Thanks for the help though!
Click to expand...
Click to collapse
When added you have to reboot the phone otherwise it won't work
From my Wicked S3 on SOKP
ShapesBlue said:
When added you have to reboot the phone otherwise it won't work
From my Wicked S3 on SOKP
Click to expand...
Click to collapse
So I did what you told me and rebooted the phone. I use AnyCut to create the shortcut for IOTHiddenMenu. When I try clicking the shortcut...I get the "Application not installed" message.
I have added the code in build prop editor with the value of one as well.
Thanks
996 said:
So I did what you told me and rebooted the phone. I use AnyCut to create the shortcut for IOTHiddenMenu. When I try clicking the shortcut...I get the "Application not installed" message.
I have added the code in build prop editor with the value of one as well.
Thanks
Click to expand...
Click to collapse
I was just making a suggestion. I've never used this option myself.
From my Wicked S3 on SOKP
You have to go into
/efs/carrier/hiddenmenu
(No extension, but its a text file)
Change the contents from "OFF" to "ON" and reboot.
Only works on TW ROMs though I think? Could be totally wrong on that, I guess it *is* only an app, and probably doesn't rely on TW framework.
And even then, only certain menu items still work. Back when the phone came out lots more work. Just google around for some codes you need and try them out.
Sent from my SCH-I535 using XDA Free mobile app
XdrummerXboy said:
You have to go into
/efs/carrier/hiddenmenu
(No extension, but its a text file)
Change the contents from "OFF" to "ON" and reboot.
Only works on TW ROMs though I think? Could be totally wrong on that, I guess it *is* only an app, and probably doesn't rely on TW framework.
And even then, only certain menu items still work. Back when the phone came out lots more work. Just google around for some codes you need and try them out.
Sent from my SCH-I535 using XDA Free mobile app
Click to expand...
Click to collapse
That same file extension is present in CM11, it might work
From my CM11 S3
ShapesBlue said:
That same file extension is present in CM11, it might work
From my CM11 S3
Click to expand...
Click to collapse
Yeah I noticed it was still there just a minute ago, haven't checked if the app is still in /system/app though. Will report back!
EDIT:
Not there, I guess it makes sense though, its in the /system folder which I wipe when I install CM.
Sent from my SCH-I535 using XDA Free mobile app
Sent from my SCH-I535 using XDA Free mobile app
XdrummerXboy said:
You have to go into
/efs/carrier/hiddenmenu
(No extension, but its a text file)
Change the contents from "OFF" to "ON" and reboot.
Only works on TW ROMs though I think? Could be totally wrong on that, I guess it *is* only an app, and probably doesn't rely on TW framework.
And even then, only certain menu items still work. Back when the phone came out lots more work. Just google around for some codes you need and try them out.
Sent from my SCH-I535 using XDA Free mobile app
Click to expand...
Click to collapse
So when I use ES File explorer to get to the efs folder...it is empty. -__- I know the application is installed because I installed it. The shortcuts still do not work though.
By the way thank you guys for the responses.
996 said:
So when I use ES File explorer to get to the efs folder...it is empty. -__- I know the application is installed because I installed it. The shortcuts still do not work though.
By the way thank you guys for the responses.
Click to expand...
Click to collapse
You must not have enabled "root" from the tools menu of ES browser. I think that's an EXTREMELY important folder for imei/efs/carrier stuff and it persists through ROMs, so every gs3 has stuff in it.
Sent from my SCH-I535 using XDA Free mobile app
XdrummerXboy said:
You must not have enabled "root" from the tools menu of ES browser. I think that's an EXTREMELY important folder for imei/efs/carrier stuff and it persists through ROMs, so every gs3 has stuff in it.
Sent from my SCH-I535 using XDA Free mobile app
Click to expand...
Click to collapse
Cool! Did what you told me. Created the shortcut...still get the message "application not installed." I'm befuddled.
996 said:
Cool! Did what you told me. Created the shortcut...still get the message "application not installed." I'm befuddled.
Click to expand...
Click to collapse
What exactly is it you're trying to do? Probably only available from the stock Samsung dialer as a guess, which means only TW ROMs.
Edit:
Just read you're on CleanRom which is TW based.
I don't really know what shortcut you're talking about, but pretty sure the app can't be run/opened like normal apps.
The way you open it is via dialer codes,
i.e. going into the stock Samsung dialer and typing codes such as *#0*# (dont click call/send, it will open automatically) to get to the extremely basic hardware diagnostic test.
Now, the average user isn't supposed to get into this menu, so most of the codes no longer work, since people figured out the ones to benefit themselves, such as the WiFi offloading which gets rid of the annoying "please connect to WiFi network" or whatever that was constantly in the notification bar.
The above code is one of the few that still work, you'll just have to google around to find some that still work on the 4.3 (?) TouchWiz rom.
Other than that, you may just be SOL, since they removed so many.
Good luck!
Sent from my SCH-I535 using XDA Free mobile app
Cool thank you. ##786# worked for me. haha

Categories

Resources