postgresql

Recursos de programación de postgresql
En el mundo de las bases de datos a veces es complicado saber elegir qué base de datos es la más optima para cada tipo de problema, sobre todo si no has trabajado mucho con ellas. ¿Qué base de datos es más optima para búsquedas textuales? ¿Cuál para gestionar datos geoespaciales? ¿Y si solo queremos almacenarlos para analizarlos? Desafortunadamente no os voy a poder dar la clave para elegir la que mejor se adapta a vuestro problema, pero vamos a repasar juntos algunos de los conceptos técnicos (sin profundizar en ellos) que se esconden debajo de muchas bases de datos para que cuando os enfrentéis a este problema estéis mejor preparados: ¿Qué índices son usados para buscar sobre textos? ¿Y sobre datos geoespaciales? (Como los que se esconden detrás de bases de datos como PostgreSQL con PostGIS o Elasticsearch). ¿Cómo hacen algunas bases de datos para escalar casi "de forma lineal" (Como Cassandra)? ¿Qué algoritmos y sistemas permiten analizar grandes volúmenes de datos (Como algunos sistemas del ecosistema Hadoop)? Todos estos conceptos los veremos desde una forma superficial, para poder tener una visión amplia de estos sistemas y que podamos profundizar cuando nos sea necesario.` https://2017.codemotion.es/agenda.html #5693168230072320/5651253979774976
@dadoonet How do you mix SQL and NoSQL worlds without starting a messy revolution? You can add Elasticsearch to your legacy application without changing all your current development habits. Your application will have suddenly have advanced search features, all without the need to write complex SQL code! https://www.autentia.com
The past week I attended to my second Socrates Canaries (Software Craftsmanship and Testing Conference)... This posts summary the experience (things I have learned, ideas to explore, techniques to use...). The Socrates event is an open space, so whatever happens is the only thing that could have :)Notes from the sessions:Under the umbrella (elixir) @gemcfadyenInteresting and very practical presentation about how to organize and structure elixir application using the umbrella concept (h...
The past week I attended to my second Socrates Canaries (Software Craftsmanship and Testing Conference)... This posts summary the experience (things I have learned, ideas to explore, techniques to use...). The Socrates event is an open space, so whatever happens is the only thing that could have :)Notes from the sessions:Under the umbrella (elixir) @gemcfadyenInteresting and very practical presentation about how to organize and structure elixir application using the umbrella concept (h...
In hardly any other area we've had as much change and improvement as in the field of databases. Just a few years ago everyone had "their" database that was used for each project. Today you are confronted with a variety of approaches and implementations. We start off with a brief look at the theoretical background of distributed systems and databases in particular. On the basis of this, we take a look at traditional relational databases such as PostgreSQL and MySQL. Additionally, we dive into newer NoSQL systems like MongoDB, Redis, Cassandra, or Elasticsearch. After that, we discuss possible scenarios as well as the advantages and disadvantages of several databases: * Why SQL is in fashion (again). * Why MongoDB's document structure fits object-oriented programming so well. * How you can capture visitor hits with Redis efficiently. * Why Cassandra is so scalable and fail-safe. * How full-text search works with Elasticsearch. The right choice of database(s) hasn't become easier through the wide range of possibilities, but all the more interesting!
Descripción del sistema de almacenamiento y explotación de datos NoSQL. Presentación de las características de NoSQL en PostgreSQL. Integración con JSON. Comparativa de rendimiento de MongoDB con PostgreSQL en relación con SELECTS, INSERTS, carga de datos y tamaño de la base de datos. Breve reseña a ToroDB.
Greach 2014, The Groovy Spanish Conf 28/March, Madrid, Spain http://greach.es Follow us on twitter http://twitter.com/greach_es Slides & source code: in http://greach.es/speakers/ivan-lopez-metaprogramming-with-groovy Groovy is a dynamic language that provides different types of metaprogramming techniques. In this talk we'll mainly see runtime metaprogramming. I'll explain Groovy Meta-Object-Protocol (MOP), the metaclass, how to intercept method calls, how to deal with method missing and property missing, the use of mixins and categories. All of these topics will be explained with examples in order to understand them. Also, I'll talk a little bit about compile-time metaprogramming with AST Transformations. AST Transformations provide a wonderful way of manipulating code at compile time via modifications of the Abstract Syntax Tree. We'll see a basic but powerful example of what we can do with AST transformations. Iván López Engineer at Kaleidos Software Engineer and Systems Administrator with 11 years of experience. I discovered Grails 4 years ago and since then I develop almost exclusively using Groovy. I am the creator of Bokzuy.com and some Grails plugins like Postgresql-Extensions and Slug-Generator. Everyday, I look forward to learning and enjoying at my job. I think I qualify for the "Geek Dad" definition and so I share my passion for technology and free software with my two daughters. You can contact me at the monthly meetings of Madrid-GUG or on twitter via @ilopmar.
Greach 2014, The Groovy Spanish Conf 28/March, Madrid, Spain http://greach.es Follow us on twitter http://twitter.com/greach_es Slides in: http://greach.es/speakers/alonso-torres-understanding-gorm/ UNDERSTANDING GORM GORM is one of the keys for the success of Grails, but for a Grails beginner some concepts may be a bit confusing. Even for a long time developer there can be some missconceptions due to the abstractions layers of the framework. In this talk I'll try to cover some of the basics of GORM, Hibernate and how to interact with transactions and sessions. I'll show some of the problems that I had starting with the Grails framework and how I think they are best solved. Some other topics that I'll go over are the interaction with GPars, transactionality inside tests and the differences between "session" and "transaction". Alonso Torres Software Engineer at Kaleidos Software engineer and pragmatic programmer, Alonso has been developing software for the Java ecosystem for over 8 years and nowadays is a full-time Groovy & Grails developer at Kaleidos, where he has been involved in the development of some Grails plugins such as Grails Postgresql Extensions and Grails time-travel.