What is the way to insert a huge JSON data into a SQLite DB in android

I have a large json request, that is, it has around 50k rows with 15 columns that I have to insert into a SQLite DB with the same structure. This is, I have to copy the same data allocated in postgres db into my sqlite db within my app. Is there some efficient way to do it? is there some api or something that could help to the work?

I have to tell that I'm able to do with OMRLite with JSON datas that isn't large but when I try to do with a bigger ones I have my app crashes and has the out of memory error.

Please if you have some idea or some example that I could follow I will appreciate it a lot! thanks in advance!

Answers


You can also use Google's Official Gson Streaming Library.

Gson Streaming : Gson Streaming

JsonReader plays very important role to parse json using Streaming library.


Need Your Help

Filling form fields from JSON Array with JQuery clone

jquery json

I have implemented JQuery Clone as in the following link :

How would I grab certain information from HTML scraping, if the website returns it as not loaded?

c# html winforms parsing screen-scraping

When I write the HTML to a file, and open the file, it says "The inventory is not available" I tried using a user-agent, but I had no luck. Any help?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.