Tag Info

New answers tagged

1

There are a variety of factors that would cause IT organizations to be cautious about creating databases and giving business users the level of access to those systems that you are, presumably, asking for when you talk about wanting to "play with" the data. First off, since you're in a company that does trading, that implies that there are dozens of laws ...


0

@VBOG There's not much of a difference with storing the data in excel or in a single sqlite DB when it comes to protecting the data. IT departments seem to be quite comfortable with allowing users to build databases in spreadsheets, but as soon as a DB is mentioned they perk up and start interfering. For 'play', sqlite will allow you to demonstrate a ...


0

As it's only on your machine you should investigate sqlite or another embedded/portable DB. I was able to bypass our locked down WinXP environment to run a web server and had scripted integration jobs from CSV and XML files. SQLITE is incredibly fast and depending on the file system can easily cope with huge files and millions of records. I'm running 20gb ...


1

It's fairly common for IT departments to have these kinds of policies. Locked down systems are so much easier to manage, and most users have no real need for admin rights or a sandbox environment. There's a few common ways to get around it: Ask for a 2nd PC that's not connected to the network, so you can develop on it without threatening anything. Ask for ...


1

pgbouncer maintains connections in a pool with a postgres server. TCP connection establishment times are significant in a high-volume environment. Clients making a large number of DB requests will have to setup a connection with a remote PGBouncer for each request. This is more expensive, than running PgBouncer locally (so the application connects to ...



Top 50 recent answers are included