Blog

This task was to display stock data from Quandl. It downloads the available tickers for a certain day, displays them and lets the user choose one, then it downloads the pricing data and draws candles on a canvas. The first problem I ran into was CORS. I’m not sure whether I’m misusing their API orRead more

I have to design and implement a database on the study course. I want to make sure that my scheme is correct. I’ve created a model company and a system which needs a database. A little background about the database: The database is designed for the company who test applications for external clients. Let’s sayRead more

Pipeline processing of data – python syntax In python world, python co-routines/generators are used to perform pipeline processing of finite/infinite data from any data source (like socket/collection/generators/..), as shown below, Example 1: grep() is used with parallelism. Example 2: wwwlog = open(“access-log”) bytecolumn = (line.rsplit(None,1)[1] for line in wwwlog) bytes = (int(x) for x inRead more

I have a SQL Server database with hundreds of tables and they all have timestamp columns. I don’t have access to backups or the server’s file system. To use the export data wizard, I have to go into each table’s mapping and set the timestamp column destination to Ignore. It’s very time consuming. Using SSMSRead more

I am successfully exporting my views tabular data in CSV format. The only problem that I have is its spitting out machine names on the table header rather than the fields that I specified in my view. How can I make the CSV header to be same with my View table headers?Read more

I need to extract the photos from the internal memory of my Samsung S5. I’ve downloaded some software called dr.fone which shows me previews of my files (i think by downloading software onto the phone) so it must be possible but it is expensive for the full version. Are there any free apps which IRead more

I’m pretty lost. I have an app that takes input from users – a subway line and a particular stop on the NYC subway. Using that, it’s supposed to output whether or not their line has a delay and how many minutes until the next train arrives. To get information on delays and train positions,Read more

I have been using this process for quite a while and while it is a bit cumbersome it has always worked SharePoint 2016 Access 2013 Excel 2013 Open Access Create ne DB External Data Connect to SharePoint List The Import Excel Spreadsheet into linked list I have always been able to import anywhere up toRead more

I have a search function on my site that needs to search through ~2000 items (this table never changes, it will always have the same number of items) stored in MySQL. All it needs to do is search by name or ‘LIKE’ the name and return the id. I have thought of two approaches toRead more

Yesterday, I had accidently formatted C drive on Windows 10 PC. Right now, I have no clue about the recovery of lost PST files from a formatted hard drive. I can’t resume my work without contacts in lost PST file. Please help!Read more