Beratung und Softwareentwicklung
Mein Name ist Stefanie Janine Stölting. ich Untersütze meine Kunden im Backend Development mit einem Fokus auf PostgreSQL, Git, Open Source, SQL, PL/pgSQL, PHP als selbstständige Software Entwicklerin.
Darüber hinaus gebe ich Vorträge über PostgreSQL und die in diesem Umfeld benutzten Tools auf Software Konferenzen, bevorzugt in Englisch.
Aktuelle News
Neue Version pgsql_tweaks: 0.3.0
Veröffentlicht am 06.12.2018
Die PostgreSQL Erweiterung pgxsql_tweaks ist in einer neuen Version verfügbar.
Das Repository wird nun auf GitLab gehostet, auf GitHub bleibt eine Kopie.
In dieser Version wurde ein Fehler beseitigt, der die Installation bei PostgreSQL 11 betraf, siehe https://gitlab.com/sjstoelting/pgsql-tweaks/issues/1.
Darüber hinaus wird die Funktion sha256() jetzt installiert, wenn bei der Installation die Erweiterung pgcrypto gefunden wird.
Die Release Notes in Englisch für diese Version sind unter https://gitlab.com/sjstoelting/pgsql-tweaks/tags/v0.3.0 zu finden.
Neue Funktion:
- array_trim
Kann leere und/oder doppelte Einträge aus einem Array entfernen
Neuer View:
- pg_table_matview_infos
Deteilierte Informationen über Tabellen und Materialized Views
ezSQL auf upstream umgestellt
Veröffentlicht am 11.10.2018
Da meine Erweiterungen von ezSQL mittlerweile in das Projekt übernommen wurden, sollte nunmehr wieder ezSQL selbst verwerndet werden.
weiter lesen...Neue Version pgsql_tweaks: 0.2.4
Veröffentlicht am 03.07.2018
Die PostgreSQL Erweiterung pgxsql_tweaks ist in einer neuen Version verfügbar.
Neue Funktionen:
- is_json
Prüft einen als Parameter übergebenen Text, ob es sich um JSON handelt - is_jsonb
Prüft einen als Parameter übergebenen Text, ob es sich um JSONB handelt
Darüber hinaus ist eine HTML Hllfe Datei verfügbar.
weiter lesen...pgsql_tweaks über PGXN verfügbar
Veröffentlicht am 30.05.2018
Die PostgreSQL Erweiterung pgsql_tweaks ist jetzt auch über PGXN verfügbar und damit enfach zu installieren.
weiter lesen...Vortrag #pgconfde 2018 "NoSQL The SQL Way"
Veröffentlicht am 16.04.2018
Mein Vortrag "NoSQL as Not Only SQL" von der Deutschsprachigen PostgreSQL Konferenz 2018 vom 13.August 2018 ist auf GitHub unter https://github.com/sjstoelting/talks/tree/master/NoSQL-The-SQL-Way.pgconf-de-2018 veröffentlicht.
weiter lesen...English News
Switched ezSQL to upstream
Published on 2018-10-11
Because all my changes have been merged into ezSQL
you should now use the original ezSQL sources. read on...Talk "PostgreSQL As data Integration Tool" at PGDay Amsterdam 2018 on GitHub
Published on 2018-08-02
I've published my talk "PostgreSQL As data Integration Tool" given at PGDay Amsterdam 2018, Netherlands, on GitHub.
It does include the slides as ODF and PDF and the SQL used for the live database examples.
read on...Talk "One Database To Rule 'em All" at #bbuzz 2017 on GitHub
Published on 2017-06-22
I've published my talk "One Database To Rule 'em All" given at the Berlin Buzzwords 2017 in Berlin, Germany, on GitHub at https://github.com/sjstoelting/talks/tree/master/one-database-to-rule-em-all.buzzwords-berlin-2017.
It does include the slides as ODF and PDF and the SQL used for the live database examples.
read on...Talk "NoSQL The SQL Way" at PostgreSQL Meetup Group Berlin in March 2017
Published on 2017-04-01
On 30th of March 2017 I gave a talk at PostgreSQL Meetup Group Berlin about JSON in PostgreSQL
You could find my slides and the SQL code on GitHub.
read on...Talk "One Database To Rule 'em All" at #pgconfeu 2016 on GitHub
Published on 2016-11-04
I've published my talk "One Database To Rule 'em All" given at the European PostgreSQL Conference 2016 in Tallinn, Estonia on GitHub at https://github.com/sjstoelting/talks/tree/master/one-database-to-rule-em-all.pgconfeu-2016.
It does include the slides as ODF and PDF and the SQL used for the live database examples.
read on...Talk at FrOSCon 2016 "NoSQL as Not Only SQL"
Published on 2016-10-23
I've published my talk "NoSQL as Not Only SQL" at Backup Berlin 21st November 2015 on GitHub at https://github.com/sjstoelting/talks/tree/master/no-sql-as-not-only-sql
read on...Talk "JSON By Example"
Published on 2016-02-01
I published my talk "JSON By Example" in PostgreSQL Developer Raum at the FOSDEM on 31st of January 2016 including the SQL statements on GitHub https://github.com/sjstoelting/talks/tree/master/json-by-example
. read on...Talk "NoSQL as Not Only SQL"
Published on 2016-01-08
I've published my talk "NoSQL as Not Only SQL" at Backup Berlin 21st November 2015 on GitHub at https://github.com/sjstoelting/talks/tree/master/no-sql-as-not-only-sql
read on...Talk "One Database To Rule 'em All" on GitHub
Published on 2016-01-08
I've published my talk "One Database To Rule 'em All" at the Berlin PHP Usergroup on 7rd November 2015 on GitHub at https://github.com/sjstoelting/talks/tree/master/one-database-to-rule-em-all.
read on...Talk "JSON By The Other Elephant" on GitHub
Published on 2016-01-08
I've published my talk "JSON By The Other Elephant" at the Berlin PHP Usergroup on 7th July 2015 on GitHub at https://github.com/sjstoelting/talks/tree/master/json-by-the-other-elephant.
read on...Talk at PHP Usergroup Düsseldorf
Published on 2015-03-27
On Thaturday, 19th of March I gave a talk at the PHP Usergroup Düsseldorf about PostgreSQL from a developers perspective.
The repositary can be found at https://github.com/sjstoelting/talks/tree/master/meet-the-other-elephant zu finden.
read on...Extended ezSQL with a mysqli class
Published on 2014-02-19
Added the new class ezSQL_mysql to use mysqli. To update existing projects, just change the class you are using from ezSQL_mysql to ezSQL_mysqli. This class is downward compatible to ezSQL_mysql, but is able to use prepared statements.read on...
Extended ezSQL MySQL quick_connect method
Published on 2013-12-15
The method quick_connect in the MySQL class is extended with a parameter to pass the charset.
read on...Client site connection pooling with ezSQL3 on Oracle
Published on 2013-08-24
The support of Oracle databases in ezSQL3 is extended in ez_sql_oracleTNS with client site connection pooling.
read on...Extended the Oralce Support of ezSQL3
Published on 2013-06-01
The support of Oracle databases in ezSQL3 was extended.
The connection can now be done without the TNSNAMES.ora. This is realized in a new class, ez_sql_oracleTNS.php.
read on...PHPIDS for MODX 0.7.1.5
Published on 2012-03-31
The current release of PHPIDS for MODX is a bug fix.
The following tickets are fixed:
- https://code.google.com/p/phpids-for-modx/issues/detail?id=7
- https://code.google.com/p/phpids-for-modx/issues/detail?id=8
Due to the current state of PHPIDS, two functions do not work as expected:
- The demo link for testing possible attacks ends on an empty page.
- The calculation of hashes for filter updates fails.
I've also updated jQuery to version 1.7.2.
read on...htmlToPDF 0.1.3.2 released
Published on 2012-03-26
Today I released version 0.1.3.2 of htmlToPDF for MODX Evolution.
The following changes where done
- TCPDF is updated to Version 5.9.152.
PHPIDS for MODX 0.7.1.4
Published on 2012-02-27
The current release of PHPIDS for MODX is a bug fix.
I added the possibility to show hash error messages. Currently the hash for the converter and the default filter are wrong on https://phpids.org.
The error message is shown and logged to the MODX system event log.
I've also updated jQuery UI to version 1.8.18.
read on...PHPIDS for MODX 0.7.1.3
Published on 2012-02-18
The current release of PHPIDS for MODX is a bug fix.
The server of https://phpids.org is available, but returns an empty result. As a result, a check of the local filter to the filters on https://phpids.org not possible since the hash value can not be calculated correctly.
This situation is solved by showing the filters up to date. The error of the call of https://phpids.org is logged in the system log of MODX, the curl call returns error 1112 and is logged:
PHPIDS-Update: Some error occurred: 14077458:SSL routines:SSL23_GET_SERVER_HELLO:reason(1112)
read on...
