Getting Next Existing Record in a DB 

Wondered how to do it,, & did it Using offset:

sql:

SELECT * FROM foo WHERE id = 4 OFFSET 1


Comments

Post a Comment

Popular posts from this blog

Install Cpanm module error : No such file or directory opening compressed index

I got this error while installing Rest client perl module $ HOME=/tmp /home/perl/5.10/bin/cpanm REST::Client ! Finding REST::Client on cpanmetadb failed. ! cannot open file '/tmp/.cpanm/sources/http%www.cpan.org/02packages.details.txt.gz': No such file or directory opening compressed index ! Couldn't find module or a distribution REST::Client Solution: The problem is because of "LWP::Protocol::https" module. Removing the directory worked for me. $ cd /perl_installed_path/perl/5.10/lib/site_perl/5.10.1 $ rm –rf LWP* or try with option "--no-lwp" cpanm REST::Client --no-lwp
Read more

How to increase Elasticsearch Shard recovery Speed

To Increase Shard recovery speed do this: Increase node recovery speed PUT http://es:9200/_cluster/settings { "persistent" : { "indices.recovery.max_bytes_per_sec": "200mb", "indices.recovery.max_concurrent_file_chunks": 5, "cluster.routing.allocation.node_concurrent_recoveries" : 5 } } Links: https://www.elastic.co/guide/en/elasticsearch/reference/current/shards-allocation.html https://www.elastic.co/guide/en/elasticsearch/reference/current/recovery.html
Read more

Getting started with Python Flask application with MVC structure

I have added a MVC structure and getting started with Python flask application in my Github.  I will continue to contribute to this repository with Database connections and JWT Authentication. Lets get started with Python and Flask :) Here is the Github link for my project. https://github.com/srikanthjeeva/python-flask-getting-started Structure your Flask application like a Rails Application. I'm a Rails developer. I like the way a Rails application is structured and I wanted to implement the similar kind of structure for a Python Flask web Application. Flask by default will not give you this structure. So make use of the getting started with Python flask repository above. The Code structure will look like this: python-flask-getting-started/ |-- app | |-- config.py | |-- controllers | | |-- hello_controller.py | | |-- __init__.py | |-- helpers | | |-- common_helpers.py | | |-- __init__.py | |-- __init__.py | |-- models | | ...
Read more