[Q] Android Notepad Tutorial - Implementing Search feature - Android Q&A, Help & Troubleshooting

I have been learning Android programming from various books and tutorials from roughly 4-5 months now and have a basic idea of most of the things in Android Programming and I recently started with the Notepad Tutorial and now have the final application after Exercise 3.
I want to add the search feature to my app. So that the notes that are stored in the database can be searched i.e. a word given as search query is checked in the body section of all the notes and then only those notes are listed which contain that specific word.
Please can you suggest some modifications in the existing code or suggest what will be needed to implement this search feature? How can the SQLite query be modified for this? or should I use indexof() method of Java after storing the body of all the notes in a String Array? and then just displaying those elements of the array using the for loop and if condition with the indexof() method??

Related

[Q] Problems with modifying google example app BluetoothChat

Hello together,
at the moment I'm developing a application based on googles example BluetoothChat (to find on googles developing site or within the examples in the android sdk)
I've modified the application so that every entry in the list view can be clicked and within a click a new activity starts (because I want to display some details). My Problem now is that this activity should have the same title like the main activity (BluetoothChat). This activity shows the connection status in the title and gets this information from the BluetoothChatService. How can I get to this information in my new activity?
thx

[Q] quiz in excel to apk

Ok so I have used an excel spreadsheet combined with VBA within excel to create a quiz (randomised questions picked from a bank held within the spreadsheet) i want to make it into a apk to have it on andriod store. Want to be able to add more questions weekly. And want to be able to add new features any helpful advice?

[Q&A] [Q] Connect to Remote Database?

Q&A for [Q] Connect to Remote Database?
Some developers prefer that questions remain separate from their main development thread to help keep things organized. Placing your question within this thread will increase its chances of being answered by a member of the community or by the developer.
Before posting, please use the forum search and read through the discussion thread for [Q] Connect to Remote Database?. If you can't find an answer, post it here, being sure to give as much information as possible (firmware version, steps to reproduce, logcat if available) so that you can get help.
Thanks for understanding and for helping to keep XDA neat and tidy!
Oracle Database 12c is Ideal For Your Project!!!
ktulu123 said:
Hey, Im developing a web app with java servlets that can access an oracle database through the tomcat server. I am also developing an android app that I want to use to be able to display the information that is stored on this database.
I am just wondering how I do this or is it even possible with oracle & tomcat? If not what other databse/server should i use? The data will also have gps coordinates to display the items on a map.
Fairly new to this type of application
Thanks a mill
Click to expand...
Click to collapse
Why Oracle Database 12c?
Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities delivering breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in three editions to fit your business needs and budget: Enterprise Edition, Standard Edition, and Standard Edition One.
New Oracle Database Utility,TyphoonDBMS 1.0 Beta (Free)
TyphoonDBMS is a complex and efficient Java-based software (free) solution that enables user to easily access and manage tables on Oracle Database Servers.
Typhoon is a comprehensive and reliable application that was developed to assist user in managing the contents of Oracle databases, enabling user to add, edit or remove tables without needing to resort to SQL statements to get the job done.
To gain access to the utility, user first need to create an account using a preferred set of credentials, which will then be required to enter every time user wish to work with Typhoon.
The program allows user to connect to a local or cloud server, by providing the necessary information, including name, version, driver and service ID. user can also input the network details, specifically the host and port number, along with the username and password, or even the database URL. Prior to saving the configuration, user can test the connection to make sure everything is in order.
Once user connect to the Oracle database, Typhoon allows user to view its contents, namely the tables that it comprises. user can browse through them, select a record and update it. Similarly, user can add a new one, as the tool enables user to ‘Insert Number Data’, ‘Insert Blob Data’, ‘Insert Clob Data’, ‘Insert String Data’ or ‘Insert Date Data’.
Moreover, user can create a new table by defining the number of columns that user need, assigning it a name, then filling out the columns and rows with the information user wish it to store. All of this can be done without having to resort to SQL statements or commands. Other options include the ability to drop tables from the database.
This Java-based utility also offers user a series of SQL ‘Syntax References’, (statements and functions) and which user can analyze in detail, to learn how to better work with them, and then use them for your own purposes.
Download & Blog
typhoondbms.wordpress.com/download/
download.cnet.com/Typhoon-DBMS/3000-10254_4-76273374.html
softpedia.com/get/Internet/Servers/Database-Utils/Typhoon.shtml

[Q] Help making Android App with MySQL DB (or other DB if you have suggestions)

Hi.
I am new to Android and am looking to solve a problem.
I want to create an Android app that has a login and that you can send messages back and forth with the people who use that app. Similar to the Facebook Messenger App. Also similar to Facebook, I want to users to be able to log in via a web-app in their browsers and view/exchange messages.
My idea was MySQL as the database that stores all of this information. The website will then be made with a PHP framework to access that MySQL data and similarly, I was thinking the Android App would read/write to that same MySQL Database.
I already proto-typed this and was able to create an android app that posts data to a process.php file I have sitting on a web server which then queries the MySQL database, and returns a JSON object back to the Android App for consumption. I followed this guide from Stack Overflow to accomplish this and it worked good. I also searched these forums and found this: http://forum.xda-developers.com/showthread.php?t=2325799 which seems to sort of do things the same way.
My question is:
1) Is this the right way to do things for an app I want to scale to 10,000 users? I want to ask the more experienced developers if this is how they would go about creating such an app. Is there a better way besides what I described? I am a noobie so this was the best way I could come up with from searching the internet.
Much Love,
MicroR

[Looking for] Multi-platform custom dictionary app

Hello dear community,
I am looking for this for quite a while.
Is there an app that will allow me to create my own cloud based dictionary? I want to improve my language skills through creating my own dictionary.
The dictionary database has to be editable online (web based), since I would like to be able copy/paste detailed definitions from different web dicts.
And of course a sync-able android app that will allow me to check some words on the go or learn while in the train
"Now" dictionary is getting pretty closer to what I wish for, but it's only available for smartphones and no browsers.
"Anki cards" is cool too, but they focus on the flip-cards learning feature which I don't frankly need. I will be completely happy with a super simple searchable custom dict.
There are some apps that allow to create custom dict file and then upload it to the SD or whatever and use it. But I want to be able to add words constantly (web or on the go)
I'm thinking - there definitely is such an app, its just me who fail to search of it properly so please help )
cheers,
Kalin
Hi there!
I would like to encourage you to check out the Spreadsheet Memo app: http://spreadsheetmemo.com
Spreadsheet Memo is a flashcard-based learning web application (combined with the power of Google Sheets to store your content) that allows you to quickly memorize things.
Flashcards can bear vocabulary, major historical dates, chemical element names, math/physics equations or even types of dinosaurs
Simply put, any subject matter that can be learned via a question-and-answer format.
You can use it for your study, as a preparation tool, knowledge check for one of your exams or to practice new vocabulary.
Sky is the limit!
See more:
YouTube: https://www.youtube.com/watch?v=UReSmwT4O9E (everything you need to know about the Spreadsheet Memo app in one video)
Facebook: https://www.facebook.com/SpreadsheetMemo (news, helpful tips and updates notifications)
Twitter: https://twitter.com/SpreadsheetMemo
Example Document (updated with every new release; provides the examples of how to use the new Spreadsheet Memo features)
Chrome Web Store: https://chrome.google.com/webstore/detail/spreadsheet-memo/kkanmehahohgnfcncalgknpbnaiaomeb (you can add the Spreadsheet Memo to your Chrome Apps for quick access - this app is free, no ads and no hidden costs)
The main features and the main goals of the Spreadsheet Memo are:
It helps you to memorize things: and it works! Every lesson is composed with two rounds. The goal of the first (initial round) is to check your brain memory's performance (you reveal the answer and subjectively define its difficulty by choosing one of the following: "I knew it" or "I didn't know"). The second round (final round) is to make sure that you have remembered the new or troubling things. The progress of the current round is presented by the progress bars located near the Question/Answer cards.
Ability to use the Google Sheet documents to store your data: with all the benefits of Google documents like sharing, editing, printing, etc.
Compatible with mobile devices: you can use it on your computer but also on all kinds of your mobile devices. You're not bound to one device. So, whenever you've got some spare time, start the new lesson. You just need a web browser!
Multiple documents: you can use as many different documents as you want. All according to your needs! You can even use the Named Ranges feature offered by Google Sheets. This is a very useful way for slicing your Spreadsheet Memo documents to a smaller parts and describe those parts with friendly names.
Responsive: no unnecessary pages loading - clean, quick and simple.
You can add links and images to your content: sometimes the words are just not enough. You can add an image or a link to the internet resources to enrich your content. It could be especially useful when you prefer some additional visualization for being able to remember things quicker and better.
You can enrich your content by using Wiki Markup - supported types are: Text formatting, Indent text, Lists, Sections, External links, Images and YouTube videos.
You can add mathematical equations or formulas using the TeX or AsciiMath notation.
Your documents stay with you: by using the standard Google Sheet documents you're able to review and edit their content even without the Spreadsheet Memo app.
Secure and safe: all of your documents belongs only to you, no personal info is shared or collected, all connections are made with secure https protocol.
No ads or hidden costs: it's all for free!
Your privacy is very important and you have the right to remain anonymous.
The Spreadsheet Memo was build on the foundations provided by Google (Google Apps Script: https://developers.google.com/apps-script/) and uses all the benefits of this platform, such as:
integration with Google services (e.g. Google Sheets)
single sign-on (you don't need to remember yet another login/password. Let the Google manage and provide access to other apps, like the one to the Spreadsheet Memo app)
built-in security, stability, scalability and efficiency
This app uses the Google Authorization. Thus, when first launched, the Spreadsheet Memo will need your authorization to run. You can read more about it here: https://developers.google.com/apps-script/guides/services/authorization You don't need to know all about this - the most important info is that your email, login, password or any other personal info will NOT be passed to the Spreadsheet Memo. They will always remain your property.
Your approval of permissions will let the Spreadsheet Memo operate properly and with full capabilities.
And I'm fully aware that all the permissions might look pretty scary at first glance. And that is exactly why I've written all of this - trying my best to make you feel safe and making sure that you are well informed.
So, let me explain those permissions:
View and manage your spreadsheets in Google Drive, View and manage the files in your Google Drive - for being able to find the Spreadsheet Memo documents. This app operates only on Spreadsheet Memo documents, it has no access or even isn't aware of the existence of any other of your Goggle Drive files.
View and manage data associated with the application - for being able to store your preferences using the user properties (those preferences are private and are connected specifically with your Google account)
Allow this application to run when you are not present - for being able to run this app without additional login prompt, when you're already logged into your Goggle account - just to save your time (standard behavior of Google related products)
Know who you are on Google - standard permission to recognize you as a google user (no information is processed or collected)
View your email address, Send email as you: for being able to send you the welcoming mail (with short summary and information about your current Spreadsheet Memo assets). And the best part is that this email will be sent from your account to your account, never leaving your own context. So your email address, as well as your identity, will stay hidden and secure.
And If you don't like this app (something that, I hope, is unlikely going to happen ) you can always revoke its accesses (uninstall it). There are two ways to do this:
Just follow the instruction from https://developers.google.com/apps-script/guides/services/authorization#revoking_access_rights
or you can use the Uninstall option provided in the mail that you will receive from Google. It will be sent right after the first launch of the Spreadsheet Memo app. Look for the mail: "More information about Spreadsheet Memo with uninstall instructions." in your inbox. Any documents that you've created will stay in your Google Drive, nothing will be lost.
Wrapping things up: remember that all of your documents belongs only to you, you can uninstall this app any time you want, no personal info is shared or collected, your identity (such as email) is and will remain your own property. From the Spreadsheet Memo point of view, you're anonymous.
You can find some additional info about the Spreadsheet Memo at the https://www.facebook.com/SpreadsheetMemo page - including news, helpful tips and updates notifications.
I've been using flashcard-based apps for quite some time (Super Memo was great!) and I've found them very useful. But every one of them had some things that just doesn't work for me (e.g. troubles with data migration, lack of support for mobile devices, no statistics, etc.) - so I've decided to write my own.
One line of code to another and the idea transforms into something with its own domain name and Facebook/Twitter page.
So, feel free to check it out. And if you have any thoughts about it (like/dislike, opinions, reviews, ideas) please leave a comment. Thanks in advance for any feedback!
Jump to the http://spreadsheetmemo.com and start memorizing now!

Categories

Resources