ebouchut + query   84

Postgres JSON: Unleash the Power of Storing JSON in Postgres
You can use Postgres as a JSON document store in your Rails app without leaving the relational world behind.

GIN: Generalized inverted Index
postgres  json  store  retrieve  write  read  native  query  PG  filter  search  find  database  jsonb  index  rails  rubyonrails  migration  document  data  starred 
10 weeks ago by ebouchut
Geode Query Request SELECT ... IN
SELECT orderId, name FROM /orders WHERE orderId IN SET('A', 'B', 'C')
geode  query  request  search  set  IN  multiple  value  find  oql 
november 2019 by ebouchut
lyft/amundsen: Google search for data
Repository for the Amundsen project. Contribute to lyft/amundsen development by creating an account on GitHub.
data  source  search  find  query  library  index  table  dashboard  stream  big-data 
november 2019 by ebouchut
Geode Pagination
There is no such feature. However there is a common pattern for this. Instead of directly querying the matching objects, write your query to return the keys of the matching objects. The client can then implement paging (e.g. page1 is key0-key99, page 2 is key 100-199, etc.). Use the "getAll" method with a list of keys to pull back one page at a time.

BTW, you can query the keys like this: "select key from /person.entries where value.ssn='222-22-2222'"

See https://jira.spring.io/browse/SGF-524
geode  pulse  page  pagination  workaround  query  select 
september 2019 by ebouchut
soheilpro/catj: Displays JSON files in a flat format.
Displays JSON files in a flat format. Contribute to soheilpro/catj development by creating an account on GitHub.
JSON  jq  query  search  find  build  builder  starred  convert  conversion  flat 
august 2019 by ebouchut
cube2222/octosql: OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. - cube2222/octosql
database  query  sql  join  analyse  multiple  several  tool  file  format  csv 
july 2019 by ebouchut
Export Postgres Query to CSV | Jon Saints
First, connect to the remote database server:


Then, export a query to CSV… \copy makes the file go to your local machine rather than the database server file system

\copy (select * from my_table) TO '~/Downloads/my_table.csv' CSV HEADER
postgres  CSV  export  select  data  extract  create  psql  sql  query  request  copy  table  row 
february 2019 by ebouchut
Geode Query Request SELECT ... IN
SELECT id, name FROM /users WHERE name IN SET('A', 'B', 'C')
geode  query  request  search  set  IN  multiple  value  find  oql 
january 2019 by ebouchut
News API - A JSON API for live news and blog articles
Search worldwide news articles and headlines from all over the web in real-time with our free News API.
news  info  get  API  call  request  find  search  keyword  query  data  aggregator  dataset  multiple  datasource  source  several  aggregate  workflow  siri  shortcut  shortcuts 
september 2018 by ebouchut
Dark Sky API: Documentation Overview
The DarkSky API allows you to request weather forecasts and historical weather data programmatically.
weather  API  request  get  current  call  format  forecast  data  search  find  online  query  dataset  siri  shortcut  shortcuts  workflow 
september 2018 by ebouchut
What's new in PostgreSQL 9.3 - PostgreSQL wiki
HINT: There is an entry for table "c", but it cannot be referenced from this part of the query.

Workaround: Use LATERAL instead of the join
postgres  psql  error  sub  query  subquery  SQL  join  table  from  outer  inner  reference  workaround  solution  problem  issue  use  closure  pg 
june 2018 by ebouchut
Becoming a JIRA Search Ninja - History searches in JIRA
"Have you ever wondered how you can query JIRA? Have you ever asked yourself what issues were ever created around a certain topic? This article covers tsearching the history of JIRA issues. It's part of a series containing 4 articles which will bring you from a novice to a JIRA Search Ninja."
JIRA  request  query  date  time  was  during  task  parameter  before  after  serch  list  ticket  issue  find 
march 2018 by ebouchut
Execute SQL statement from the Rails console
ActiveRecord::Base.connection.execute "SQL statement here"
rails  console  execute  SQL  statement  query  run  launch  rubyonrails  from notes
february 2018 by ebouchut
jdberry/tag: A command line tool to manipulate tags on Mac OS X files, and to query for files with those tags.
tag is a command line tool to manipulate tags on Mac OS X files (10.9 Mavericks and above), and to query for files with those tags. tag can use the file system's built-in metadata search functionality to rapidly find all files that have been tagged with a given set of tags.
mac  macos  tag  file  folder  finder  CLI  command  line  query  search  apply  set  list  find  update  change  tagging 
september 2017 by ebouchut
CQRS: Command Query Responsibility Segregation
"CQRS stands for Command Query Responsibility Segregation. [..] At its heart is the notion that you can use a different model to update information than the model you use to read information. For some situations, this separation can be valuable, but beware that for most systems CQRS adds risky complexity."
CQRS  command  query  reponsibility  segregation  pattern  database  model  data  datastore  update  read  write  definition 
march 2017 by ebouchut
Introduction to Twitter's Zipkin - open-source implementation of Google’s distributed tracing system
"Zipkin is the Twitter open-source implementation of Google’s distributed tracing system, Dapper. It’s a great tool for people who wants to understand the bottleneck in their multi-services system. "
tracing  system  i  bottleneck  collector  query 
july 2016 by ebouchut
Free Online Url Parser - Query String Splitter - FreeFormatter.com
"[...] parse a URL into its individual components, i.e scheme, protocol, username, password, hostname, port, domain, subdomain, tld, path, query string, hash, etc. It also splits the query string into a human readable format and takes of decoding the parameters. "
URL  query  parameter  split  extract  token  online  toolbag  parse  tokenize 
april 2015 by ebouchut
MDX : didacticiel sur le langage des BDM - Michaël Tranchant
"MDX (pour MultiDimensional eXpressions) est le langage de requête dédié aux bases de données multidimensionnelles (au sens large) . Pour faire une analogie, il est aux BDM ce que SQL est aux BDR.

Il a son propre vocabulaire, lui permettant de manipuler dimensions, hiérarchies, niveaux et membres.

Très riche, il est vite complexe à mettre en place. Ce didacticiel est une introduction à MDX : il présente les termes courants, les fonctions de base, et quelques astuces."
mondrian  MDX  tutorial  french  query  introduction  starred  learn 
december 2014 by ebouchut
Using Arel to Compose SQL Queries
"Arel is a library that was introduced in Rails 3 for use in constructing SQL queries. Every time you pass a hash to where, it goes through Arel eventually. Rails exposes this with a public API that we can hook into when we need to build a more complex query.

With Rails 4, we can also query for inequality by using where.not. However, where has its limitations. It can only combine statements using AND. It doesn’t provide a DSL for comparison operators other than = and <>.

When faced with a query that requires an OR statement, or when needing to do numeric comparisons such as <=, many Rails developers will reach for writing out a SQL string literal. However, there’s a better way."
rails  rubyonrails  build  construct  SQL  query  activerecord 
december 2014 by ebouchut
OpenWeatherMap free weather API
"The OpenWeatherMap service provides free weather data and forecast API suitable for any cartographic services like web and smartphones applications. Ideology is inspired by OpenStreetMap and Wikipedia that make information free and available for everybody. OpenWeatherMap provides wide range of weather data such as map with current weather, week forecast, precipitation, wind, clouds, data from weather Stations and many others. Weather data is received from global Meteorological broadcast services and more than 40 000 weather stations."
weather  temps  meto  API  query  json  data  free  map  forecast  prevision 
january 2014 by ebouchut
tire.rb: a Ruby client for the Elasticsearch
"Tire is a Ruby client for the Elasticsearch search engine/database. It provides Ruby-like API for fluent communication with the Elasticsearch server and blends with ActiveModel class for convenient usage in Rails applications. It allows to delete and create indices, define mapping for them, supports the bulk API, and presents an easy-to-use DSL for constructing your queries. It has full ActiveRecord/ActiveModel compatibility, allowing you to index your models (incrementally upon saving, or in bulk), searching and paginating the results. "
elasticsearch  search  engine  client  api  ruby  gem  rails  rubyonrails  query  facet  filter  sort 
september 2013 by ebouchut
Bullet Gem: A rails plugin/gem to kill N+1 queries and unused eager loading
"The Bullet gem is designed to help you increase your application’s performance by reducing the number of queries it makes. It will watch your queries while you develop your application and notify you when you should add eager loading (N+1 queries), when you’re using eager loading that isn’t necessary and when you should use counter cache."
rails  rubyonrails  gem  database  query  performance  eager  loading  cache  slow  N+1  activerecord  optimization 
may 2012 by ebouchut
Unfold the value of your data
"UnfoldValue is a distributed data-processing engine designed to acquire, analyze and maintain large, complex and continually changing data sets.

Our system is a blend of MapReduce and Parallel Databases. It takes the formal approach of relational algebra; pushes it a step further with a more general form, a.k.a. monoid algebra, which applies to a broader class of data structure; and refunds it into a MapReduce like engine where formal properties of the algebra opens the way to many optimizations and stream techniques.

This new blend opens the ability to analyze all sort of data within one platform, using a modern high level query language, on top of an extensible, scalable, real-time engine."
data  engine  acquisition  process  query 
october 2011 by ebouchut
Firefox AddOn - UrlParams
"UrlParams displays the GET and POST parameters of a webside in Firefox/Mozillas sidebar, so that you can easily add/modify/remove parameters"
firefox  extension  plugin  add-on  query  string  parameter  URL  HTTP  GET  POST  submit  modify  add  remove 
april 2011 by ebouchut
320 and up - Tiny screen first boilerplate extension
Many CSS Media Queries boilerplates start with a desktop-specific stylesheet, then add queries and styles for progressively smaller viewports. This means that even the small browsers load desktop layout styles and potentially large assets, even when these are set to display:none;.

‘320 and Up’ starts with a tiny screen stylesheet that contains only reset, colour and typography styles. Media Queries then load assets and layout styles progressively and only as they’re needed. Think of this as responsible responsive design
mobile  css  css3  html  design  webdesign  web  media  query  html5 
april 2011 by ebouchut
javascript - escape(), encodeURI(), encodeURIComponent()
"[...] differences between these three methods and decide on the appropriate times to use each"
javascript  escape  encode  encoding  character  URL  programming  encodeURI  encodeURIComponent  URI  query  string  HTTP  request  parameter  matrix  difference 
february 2011 by ebouchut
"css3-mediaqueries.js is a JavaScript library to make IE 5+, Firefox 1+ and Safari 2 transparently parse, test and apply CSS3 Media Queries."
css3  css  javascript  media  query  device  size  page  width  height  design  webdesign  library  jquery  browser 
december 2010 by ebouchut
« earlier      
per page:    204080120160

related tags

acquisition  activerecord  ad  add  add-on  address  advanced  advertising  after  aggregate  aggregator  alfred  all  analyse  analysis  analytics  analyze  ancestor  any  apache  api  apply  arel  array  ask  association  before  BI  big  big-data  binding  bo  bottleneck  browse  browser  build  builder  by  cache  call  campaign  cause  change  character  CIDR  CLI  client  closure  collection  collector  command  commercial  compare  comparison  console  construct  contain  conversion  convert  copy  CQRS  create  crossjoin  css  css3  csv  CTE  cube  current  custom  dashboard  data  database  dataset  datasource  datastore  dataviz  date  define  definition  demeter  demo  dependency  describe  description  design  development  device  diagram  difference  dimension  distinct  document  documentation  don't  druid  dsl  dsp  dsp-core  during  eager  edge  edit  editor  elasticsearch  encode  encodeURI  encodeURIComponent  encoding  endpoint  engine  entry  error  escape  event  execute  exist  explain  export  extension  extract  facebook  facet  fallback  fast  field  file  filter  find  finder  firefox  flat  folder  forecast  format  FQL  framework  free  french  from  function  gem  geo  geode  get  grape  graph  greater  grid  group  groupby  GUI  hadoop  handle  height  hierarchize  history  host  html  html5  HTTP  i  ILIKE  improve  IN  index  inet  info  information  informational  inner  intent  interface  interval  introduction  IP  issue  item  java  javascript  JIRA  join  jq  jquery  json  jsonb  kafka  key  keyboard  keyword  label  language  launch  law  layout  ldmobile  leaf  learn  library  LIKE  line  linux  list  loading  lower  mac  macos  map  match  materialized  matrix  MDX  measure  media  method  meto  microsoft  migration  mobile  model  modify  mondrian  multiple  mysql  N+1  name  native  navigation  navigational  neo4j  news  node  object  OLAP  online  open  opensource  operator  optimization  oql  OR  outer  overlap  page  pagination  param  parameter  parse  parser  parsing  path  pattern  percent  performance  pg  pivot  plan  plugin  port  portable  POST  postgres  present  prevision  problem  process  programming  property  proxy  psql  pulse  queries  query  rails  read  recipe  record  recursive  reference  regex  relation  relationship  remove  REPL  reponsibility  request  responsive  retrieve  row  ruby  rubyonails  rubyonrails  run  SASS  schema  scheme  search  segmentation  segregation  select  serch  set  several  shortcut  shortcuts  siri  size  slow  snippet  solution  sort  source  sourcing  spec  speed  split  sql  sqlite  stackoverflow  starred  statement  store  stream  string  sub  submit  subquery  syntax  system  table  tag  tagging  target  task  TDA  tell  temps  term  test  text  ticket  time  tips  token  tokenize  tool  toolbag  tracing  transaction  transactional  tsearch  tutorial  type  ui  uniq  unit  unix  update  URI  URL  use  value  version  versionning  view  visualization  w3c  was  weather  web  webdesign  width  with  workaround  workflow  write  xml  xpath 

Copy this bookmark: