554 reputation
28
bio website mesoconcepts.com
location Europe
age
visits member for 3 years, 7 months
seen Mar 11 at 22:04

Currently open for work opportunities.


I’m a marketer and growth hacker gifted with in-depth IT skills.

At home with engineering as much as I am with sales, I can lead an interdisciplinary team to execute every step towards launching, growing, and managing a product.

Colorful highlights in my career to date include:

  • Being put in charge, as an intern at an SDSL startup, of designing a carrier’s network.
  • Turning a personal blog into a 4,000-customer strong business while globe trotting.

Operating as a consultant, I’ve a knack for spotting untapped markets and sales channels with high potential, as well for distilling raw data into actionable metrics. This enables me to rapidly articulate focused and practical steps, as well as strategic insights, which help businesses cut costs and amplify revenue.

Full CV upon request: d at mesoconcepts.com.


Dec
13
comment Should tables with very large records quantities be split into multiple tables
It depends on how you use the data. Fwiw, though, in the DB world you can think of 100kB at tiny, 1MB as small, 1GB as medium, 1TB as large, and 1PT as huge.
Sep
24
awarded  Autobiographer
Nov
24
comment Amount of memory used by postgres
@AliceEverett: that's probably a question for DBA...
Nov
24
answered Amount of memory used by postgres
Nov
15
comment Postgresql indexes in memory
@IgorRomanchenko: it can make some sense when running a cache with unlogged tables in a ramdisk — though admittedly, one might as well use memcached in that case. :-)
Sep
26
comment Get count of processed queries
Look into github.com/julmon/pg_activity or its source code.
May
20
awarded  Yearling
May
19
comment MySQL Master/Slave. Actual use of Slave Machine
Isn't master-master relying on NDB in MySQL?
May
19
comment MySQL Master/Slave. Actual use of Slave Machine
An NDB cluster is probably a terrible idea.
May
16
comment PostgreSQL group roles
This grants write perms to the tables, which isn't what OP wants. Fwiw in addition, I was thinking the same when writing my own answer, but testing revealed a PG bug (in 9.2 anyway). Running alter default privileges in schema foo grant select on tables to public; is, per docs, supposed to grant select on all tables in schema foo to public; automatically on new tables (i.e. what OP wants), but testing revealed that you still need to run that query manually (i.e. what OP is currently doing) for some reason.
May
16
comment PostgreSQL group roles
After playing around with it, it most definitely looks like there's a bug or three in Postgres...
May
3
comment InnoDB errors after having deleted “ibdata1”
Should go to DBA...
May
3
comment Can't connect to the postgres server ls: /tmp/.s.PGSQL.5432: No such file or directory
(Or the new one might not be running yet.)
May
3
comment Can't connect to the postgres server ls: /tmp/.s.PGSQL.5432: No such file or directory
Restart your Mac. The older version of Postgres (the one that's installed by OSX) might still be running.
May
2
comment Database design - People and Organisations
I'm not saying it's impossible. Merely that it's thorny. And that in practice there's very little value in doing so "properly" considering the joins, validation issues, and UI/UX involved, vs something that would actually cover 99% of cases with a conveniently well known UI, aka Outlook.
May
2
comment Database design - People and Organisations
One big example would be when you normalize the company. If you toss in a link to a screen with an edit button when you click it, you may very well end up with the secretary screw up I mention further up. One alternative, which is a convenience textfield to rename the company, amounts to the same. The last alternative is to have a dumb text field with no ties to the table at all (just like in Outlook), and to tie things back up in a subsequent (or ajax) screen if there is actual need for normalization.
May
2
answered Database design - People and Organisations
May
20
awarded  Yearling
Jul
26
answered ts_rank massively slows my query, how can I improve performance?
Jul
4
answered Postgresql row-level encryption