ssokolow

-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6

SELECT foo, bar, baz, quux FROM table
 WHERE oid NOT IN ( SELECT oid FROM table
                    ORDER BY title ASC LIMIT 50 )
 ORDER BY title ASC LIMIT 10

alexjlockwood

public class MainActivity extends Activity {

  private final MyActivityLifecycleCallbacks mCallbacks = new MyActivityLifecycleCallbacks();

  @Override
  protected void onCreate(Bundle savedInstanceState) {
    // Always register before calling into the super class.
    getApplication().registerActivityLifecycleCallbacks(mCallbacks);
    
    super.onCreate(savedInstanceState);

rxaviers

People

:bowtie:	😄 :smile:	😆 :laughing:
😊 :blush:	😃 :smiley:	☺️ :relaxed:
😏 :smirk:	😍 :heart_eyes:	😘 :kissing_heart:
😚 :kissing_closed_eyes:	😳 :flushed:	😌 :relieved:
😆 :satisfied:	😁 :grin:	😉 :wink:
😜 :stuck_out_tongue_winking_eye:	😝 :stuck_out_tongue_closed_eyes:	😀 :grinning:
😗 :kissing:	😙 :kissing_smiling_eyes:	😛 :stuck_out_tongue:

hofmannsven

MySQL

Getting started

• http://www.sqlteaching.com/
• https://www.codecademy.com/learn/learn-sql
• https://www.codecademy.com/catalog/language/sql

Related tutorials

• MySQL-CLI
• Analyzing Business Metrics

octocat

# Compiled source #
###################
*.com
*.class
*.dll
*.exe
*.o
*.so

# Packages #

agendor

This tutorial uses the "Sample hapi.js REST API" project.

Take a look at: https://github.com/agendor/sample-hapi-rest-api/

##Topics

• Introduction
• Installing Node.js
• Installing MySQL
• Setting-up the project

passsy

package com.pascalwelsch.utils;

import android.support.annotation.Nullable;
import android.support.v7.util.DiffUtil;
import android.support.v7.widget.RecyclerView;

import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.List;

stkent

Android Studio Shortcuts (Mac)

Notes:

• Two of the most useful shortcuts utilize the Fn (function) keys. It is therefore recommended that you enable the "Use all F1, F2, etc. keys as standard function keys" option [System Preferences > Keyboard].
• Be sure to enable the Mac OS X 10.5+ keymap in Android Studio [Preferences > Keymap].
• A fairly complete shortcut list can be found here.

Useful symbols:

gabrielemariotti

        Toolbar toolbar = (Toolbar)findViewById(R.id.toolbar);
        
        //Title and subtitle
        toolbar.setTitle("MY toolbar");
        toolbar.setSubtitle("Subtitle");

        //Menu
        toolbar.inflateMenu(R.menu.toolbar_menu);

        toolbar.setOnMenuItemClickListener(new Toolbar.OnMenuItemClickListener() {

gabrielemariotti

public class HelperUtil {

    public static HelperUtilBase getInstance(Context context) {

        if (Build.VERSION.SDK_INT > Build.VERSION_CODES.KITKAT) {
            return new HelperUtilL(context);
        } else if (Build.VERSION.SDK_INT == Build.VERSION_CODES.KITKAT) {
            return new HelperUtilKK(context);
        } else if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.JELLY_BEAN) {
            return new HelperUtilJB(context);