Live data from Hacker News

Ask HN: Freelancer? Seeking freelancer? (December 2021)

news.ycombinator.com

81–90 of 124 posts

Re: Ask HN: Freelancer? Seeking freelancer? (December 2021)

#81

SEEKING WORK | Remote | India | Full Stack Web and Mobile Developers, QA We are a team of 5 devs and 1 QA who are available part time or full time available individually or as a team. We have extensive experience with Building Web and Mobile Apps, automating tests and have a designer coming onboard soon. Portfolio of our work done and CVs will be made available on request. Tech Stack that we are familiar with - Javas…

:)

I could use a helping hand on AnonyProxies.com, see the Github repo via the link on https://anonyproxies.com -

thanks,

Alexander Schliker Facebook (co-Founder), Microsoft (co-Founder)

Re: Ask HN: Freelancer? Seeking freelancer? (December 2021)

#83

SEEKING WORK - Remote (Located in Poland, EST/PST timezones OK) -------------------- We are very efficient team of Python/Django experts, NodeJS, Reach and mobile (React Native) developers who helped startups get their prototypes and products launched in a record time. We've worked as team extension and provided outsourcing for Startups, created Prototypes, MVPs, complete solutions, provided on-site training for clie…

:)

I could use a helping hand on AnonyProxies.com, see the Github repo via the link on https://anonyproxies.com -

thanks,

Alexander Schliker Facebook (co-Founder), Microsoft (co-Founder) founders@anonyproxies.com

Re: Ask HN: Freelancer? Seeking freelancer? (December 2021)

#84
SEEKING FREELANCER above auspices of ticket to gold, disabled to gold, golden ticket, etc.

Visit https://www.anonyproxies.com - there are a few things to make happen:

Create an auto-deploy section on the page that allows you to automatically deploy the service to a new cloud VPS for a service fee just like the other sections that say Subscribe Now. This needs to be part of the API which is located at https://anonyproxies.com/api/ (django-rest-framework). The API url mentioned and its functions just needs some configuration to resolve any kind of Internal Server Error and it needs setup to ensure it runs using a database like MySQL (settings can be places in live.py of anonyapi repo located at https://bitbucket.org/anonysurfer/anonyapi/. The section and the configuration modal that you generate allows the person to at any moment in the future specify custom advertisement javascript code or any javascript code at the top of the A2, Glype, PHProxy, PHProxy++ pages assuming the user is logged in (use a "Config" button that opens up a modal where this can be configured using our API). The "Config" button and its modal also allows the user to specify if they want their deployment to be part of the mirrors, a DNS domain name option where they can provide a domain name (otherwise we provide them automatically with a domain subdomain of anonyproxies.com and anonyproxi.es [an alias of anonyproxies.com])

VPN sections need to be configured and a .sh script needs to be generated to automatically setup the VPN and proxy options that are offered on https://anonyproxies.com

Login functionality needs to be setup so that people can login to the /secure/ URL with some kind of secure cookie and also login to the individual sections

PhoneGap application needs to be deployed (the code is already there, just needs to be compiled) with more clear instructions for setting everything up at https://bitbucket.org/anonysurfer/anonyproxiesgap/ - an .apk file, Apple Store file, Microsoft Store file needs to be generated and uploaded to the PhoneGap repository at https://bitbucket.org/anonysurfer/anonyproxiesgap/

If logged in to both the anonygap and anonyweb apps from github.com/anonyproxies/ - sections on the page need to show, based on what was paid for in particular whatever VPN or proxy details are necessary to use the application.

:)

Email me: founders@anonyproxies.com

A few thousand lines of code and I'll add you as a co-Founder to AnonyProxies :)

A few major contributions and you can join the team page at https://anonyproxies.com/team.php

:)

Alexander Schliker

Re: Ask HN: Freelancer? Seeking freelancer? (December 2021)

#85
SEEKING WORK | REMOTE (UK TIMEZONE) | Full Stack Typescript Developer I'm a full stack Typescript Developer, specializing in React and Electron applications. - I have over 5 years experience working on typescript / react applications.

Interested in fintech, video automation and blockchain, but open to any industries!

Daily rate of £600 ($819) per day - Happy to quote on a per project basis instead if you prefer.

Contact: dave [at] weatherall [dot] io

Re: Ask HN: Freelancer? Seeking freelancer? (December 2021)

#87
post #76

Earlier quoted context omitted.

Many thanks to tsholmes for finding a solution and sharing it with me. He has requested the full amount be donated to Nine Lives Foundation, proof of donation can be seen here: https://ninelivesfoundation.networkforgood.com/ I'll be posting the script and the format documentation shortly

I would be very interested if you or tsholmes could discuss the thought process behind identifying and reverse engineering the format!

Sure thing!

The sqlite file format spec (https://www.sqlite.org/fileformat.html) is fairly short. I looked at hexdumps of where the db header should be, and a few page headers, and it seemed to line up, but not everything was filled in correctly. Trying to patch the header fields to match the sqlite spec and running it through sqlite3 didn't work, so I figured there was some more structural differences.

Since the spec is pretty short, I wrote a small parser for the sqlite files, printing out hexdumps of various sections as I went to check against the spec. The cell pointers in the btree leaf pages were missing, so I just tried reading them out in order from the cell data section and that worked (the pointers are really just an optimization to skip over cells when scanning). The table schemas are stored differently, but its a text format so its pretty easy to read (comma-separated columnName:type).

The record format was the most different part. Instead of type-tagged values like in sqlite, these records just had the column count and offsets of values. The offsets can be 1 or 2 bytes depending on the length of the record, which tripped me up for a bit. This was mostly figured out by looking at hexdumps of records. The values have to be interpreted based on the schema of the table the record is in.

The file format used little-endian for the record values, despite everything else in the file being big-endian. The schema in these files allowed array-of-vals and array-of-structs column types that I haven't decoded yet, but they don't seem to be on any of the important tables, mostly file metadata tables. There are some untyped binary columns containing an array of 64-bit floats, which was found by comparing against the csv of the same data.

Not counting some of the binary columns which I haven't decoded yet, the alternate version of the various sections were still pretty simple, so I was able to figure them out by eyeballing it. There weren't any numeric enums (outside of the ones in the sqlite spec) or flag masks that would have taken a while to decipher.

Re: Ask HN: Freelancer? Seeking freelancer? (December 2021)

#89
SEEKING WORK - EU, English, French - Contract, remote

- Location: Berlin

- Technologies: Svelte, React, D3.js, R, QGIS, TypeScript, Clojure/Clojurescript

- Website: https://basilesimon.fr

- Github: https://github.com/basilesimon

---

Freelance dataviz practitioner, creative technologist. All about telling a story from data and helping products do just that in a memorable way. Former BBC, Times, Reuters.

I work across the stack and encompass statistics and modelling as well as design and building of the bespoke output, in addition to standing up whichever data pipeline or API.

---

Contact: basile@basilesimon.fr

Re: Ask HN: Freelancer? Seeking freelancer? (December 2021)

#90
SEEKING WORK | UK (UTC) | Remote

Need to develop your SaaS MVP fast? I can build it in less than a month.

I love helping people to get their vision off the ground - especially if it's a niche product. I've built many MVPs in less than a month and in some cases days.

And not only will it be built quickly, it will be created to be a solid platform on which to grow and build upon. No dirty hacks or shortcuts. Just my repeated experience of building new projects to validate ideas quickly.

Technologies: Python, Django, Django REST framework, Pytorch, C/C++, + more

I also take on more traditional project work (and technical writing). More info / CV available on request.

email: hn [at] davidbrownwastaken.com

Post reply on HN