Showing posts with label data. Show all posts
Showing posts with label data. Show all posts

Monday, July 28, 2014

Move ViewState out of the page

From this year I'm working on a ASP.NET Web Forms project. I'm currently tuning this project with some tweaks.
One of those tweaks is related to ViewState, IMHO the Achilles' heel of this framework.
Due to business decisions, budget etc... dev-team could not re-engineer the entire pages, so they decided to improve whatever possible.

Move ViewState out of the page... that means one thing: lighter pages!

ViewState, by default implementation,  is actually stored in a HiddenField, but you can move it everywhere: Session, Cache, Database...

Sunday, August 5, 2012

SQLite wrapper based on java.lang.reflect

In Android development, data persistence is often realized with SQLite. Sometimes the act of preparing all the classes, the adapter, every kind of query (CRUD) and rewrap into model,is a bit frustrating. It's like something already done, to do again every time.

I never see this kind of class on the web, so I decided to make my own one.
What I'm talking about?

A class that simplifies the common use of SQLite with a friendly usage (inspired by .NET's LINQ one).
SQL Scripts are defined by the model, so you need to supply the object instance or just its class.

For the moment I provided:
  • select (distinct, count,where, limit, order by)
  • delete (where)
  • insert
  • transactions

Thursday, January 19, 2012

Manage a Database in Android


Today we will learn how to manage a database in Android using native SQLite libraries.