Ask HN: Freelancer? Seeking freelancer? (December 2021)
Please lead with either SEEKING WORK or SEEKING FREELANCER,
your location, and whether remote work is a possibility.
Bonsai (YC W16) (https://www.hellobonsai.com) offers freelance contracts, proposals, invoices, etc.
123 comments
[ 5.3 ms ] story [ 188 ms ] threadMy name is Joe. I am the creator of https://awayto.dev which is a free open source web application platform. It uses React, Redux, Material UI, NodeJS, Typescript, Webpack, Postgres, Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, as well as my own custom scripts. Awayto makes it fast to deploy low-cost web applications and then have a skilled developer come in and build up your application.
If you are looking for a consulting- or contract-based resource, I am interested and open to take on projects of many varieties. Over the last 10 years, my professional experience has touched on Education, Professional Consulting, IT Management, E-Commerce, and I hold my MA in English teaching. I have helmed numerous, extremely successful software development teams within the companies I have worked at, on projects of large complexity, some with millions of users and in revenue.
Java, C#, Javascript, Typescript, HTML, CSS, PHP, Ruby, Python, HITRUST, FERPA
Thank you for your time.
Inquiries: joe@keybittech.com Website: https://awayto.dev LinkedIn: https://www.linkedin.com/in/joe-mccormick-76224429/
I'm working on an open-source library in a niche civil engineering field. I have a proprietary file format that I would like to decode and support.
I am almost certain the file is an SQLite database with the header changed, though my attempts to reconstruct the header and find any other changes have failed.
If you think you are up to the challenge, I've linked to some example files below, the first person who can share the procedure to update the file that it will open in a native SQLite reader I will pay a $2,000USD bounty or donate to a charity (your choice).
Email in profile, I'll post below if an answer has been accepted.
edit: This has been decoded and the bounty will be donated! Waiting for confirmation from the person who provided the script to decode the file and I will share results and proof of donation
If you email me how you know it is a SQLite file and what is missing, I can also send you the data that is contained within the files if that will be helpful to you.
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
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.
I really enjoyed learning more about b-trees and binary encoding formats taking this on. My primary exposure to those concepts has come from reading Designing Data-intensive Applications — so having something concrete to work on to test that knowledge was fun.
I’m excited to review your script. Great work!
Portfolio: https://www.seanw.org/
Location: Edinburgh, UK and remote (time zone differences aren't a problem)
Email: sw@seanw.org
---
I help startups with UX/UI and web design for their products, including design work for new and existing web apps, websites and landing pages. My background as a full stack developer and startup founder helps me come up with practical design solutions that balance usability, aesthetics, development effort and performance.
---
The best live example of my work is Checkbot (https://www.checkbot.io/), a browser extension that tests websites for SEO, speed and performance problems. The entire project is my own work including coding the extension itself, UX/UI design, website design (the desktop homepage is optimised to load in 0.7 seconds with only 0.3MB transferred), website copy, and website articles on web best practices.
[ Rated 4.9/5, 40K+ active users, 100s of paying subscribers ]
---
I have 10+ years of experience, including a PhD in software verification and 5+ years working for myself for over 20 companies including Just Eat and Triumph Motorcycles. See my website for testimonials, portfolio and more:
https://www.seanw.org
Skills: Figma, Sketch, TypeScript, JavaScript, Vue, HTML/CSS, Tailwind, OCaml, Java, Python, C, website SEO and speed optimisation.
---
Email sw@seanw.org with a short description of your project and how you think I can help. I can get back to you within one working day to arrange a call to discuss a quote. I work to fixed price quotes when projects are self-contained.
Are you a business looking for web or print design services? I'm a multidisciplinary graphic designer with an eco-friendly focus, specialising in lightweight websites designs and low-ink usage print design. My design process takes into account the sustainability of the final design project from conception to end of life.
--
Services
· Web design: responsive mobile/desktop designs that are lightweight and fast - I can arrange web development also
· Branding: logo design, branded social media banners, posters, booklets
· Print design: posters, booklets & business cards
· Custom illustrations: digital artwork, print illustrations
To get started on your design project journey get in touch with me today via https://angeliqueboudeau.org
--
Portfolio: https://angeliqueboudeau.org/#portfolio
Instagram: https://www.instagram.com/angeliqueboudeauorg/
Contact: hi@angeliqueboudeau.org
Well-rounded Scala data engineer with deep knowledge of the internals of distributed datastores.
Core Skills:
● Cassandra (Data Modeling, Troubleshooting Performance And Operational Issues)
● Druid (Stream Ingestion, Cluster Ops, Data Modeling, Scaling Complex Queries)
● Stream Processing At Scale: Kafka, Flink, Spark Streaming
● Programming Languages: Scala (highly proficient, 8 years exp.), Python (proficient)
Other Skills: Zookeeper, BigQuery, Redshift, Kinesis, Airflow, DBT, Snowflake, FiveTran.
Educational Background: Computer Science.
Solid experience working remotely.
More details: https://is.gd/dserbanresume202112
E-mail address in the profile.
Remote: Yes, please
Willing to relocate: nope
Technologies: Go, Python, JavaScript, PostgreSQL
Resume/CV: notes.eatonphil.com, github.com/eatonphil (I can give you a real one in email)
Email: phil@multiprocess.io
Past ten years I've been a dev or manager often at startups. Most recently a manager at Oracle. I mostly do web development (frontend, backend) professionally but I also enjoy writing compilers, parsers, interpreters, databases.
I help companies manage and extract value from their geospatial data.
A typical project for me might involve
• Frontend development (webmaps, interactive visualization)
• Backend development (static websites, APIs)
• Satellite imagery (land-use classification, object identification)
• Routing (supply chain optimization, logistics, retail planning)
• Dataset building (DEM coregistration, web scraping)
• Data engineering (setting up a geospatial datastore, ML pipelines)
I run https://gpxz.io (SaaS) and https://opentopodata.org (Open Source). Feel free to reach out if you think I could help with something, or just to chat about your project.
LinkedIn: https://www.linkedin.com/in/ajnisbet/
Website: https://ajnisbet.com
Email: andrew@ajnisbet.com
And I can help you do the same.
Here's what my clients have to say:
“Before we started No Nerds' process, I wasn’t sure it would be worth it. Having gone through it, I can’t imagine it going any other way." - Sachin Gulaya (CEO, Alpine Vapors)
“James and his team stepped in at a critical moment in Wellness 4 Humanity's trajectory and delivered exactly what we needed to hit our deadlines." - Lian Pham (Founder, Wellness 4 Humanity)
“After three years of other agencies promising a lot but delivering little, getting to test a prototype after just a few weeks was very cool. From the first time we sat down, I really felt James got what I was trying to do.” - Andy Lin (Founder, Self Portrait Project)
Schedule a 15-minute chat with me here: https://calendly.com/nonerds/explore
Non-technical founders can download my 55-page guide to building Million Dollar MVPs at https://nonerds.com
Email: james@nonerds.com
LinkedIn: https://www.linkedin.com/in/sanedigital/
Keywords: app development design mvp web mobile ios android react native product cto startup
ML Ops (MLOps for the keyword searchers)
I specialize in streamlining machine learning workflows and procedures. Want to iterate faster on your ML development? Replace your manual process with an automated workflow? I can help you out. I'll review your process, make suggestions appropriate to your situation, and implement them to your satisfaction.
I've worked with companies large (helped develop and maintain the ML platform at Airbnb, serving hundreds of models) and small (small startup iterating on a single model with no automation yet).
I've worked with a range of technologies (go, python, C++, java, javascript) and can adapt to whatever you use.
Email is in my profile.
Hi I’m Artur, from Labcodes. We’re a software boutique based in Brazil. We’re results-driven and internationally recognized for our 7+ years of partnership with US companies.
We’re experts in Python/Django, Javascript/React, and UI/UX design. Our team is comfortable working together and has a strong engineering culture, which is hard and expensive to build on an internal team.
I know that engaging with an external company, even more if we reach you out on a cold approach, is risky, so I’ll leave some links with social proof of our knowledge and experience here.
Talks we gave in major Python/Django conferences https://lab.codes/talks
Client reviews https://lab.codes/clutch-reviews
React open-source libs we maintain https://github.com/labcodes/react-redux-api-tools https://github.com/labcodes/rel-events
Design portfolio https://lab.codes/design-portifolio
email me if you’re interested in doing business or get to know more about us: artur@labcodes.com.br
I do electronics, end to end (design from idea, part selection, layout, prototyping, testing, enclosure design). Lately I've been working mainly on adapting existing designs to the new reality of part shortages. If you have a device that you can't produce at the moment due to part shortages I might be able to help you redesign it for the current availability situation. Of course I'm also more than happy to help with new devices. Contact at kliment@0xfb.com or Kliment on liberachat.
Recent example of this kind of adaptation: https://www.kickstarter.com/projects/arthurwolf/smoothieboar...
I won't work on weapons, advertising, cryptocurrencies or automotive (for motivation on the latter, see my analysis on the reason for the component crisis here https://news.ycombinator.com/item?id=26931498 ). This is non-negotiable, don't bother asking for exceptions.
My Services:
1. Front End Development (HTML, CSS, JavaScript)
2. Complete Web Applications with React and Node.
3. Back End Development (REST API, SQL/NoSQL Database)
4. Responsive Websites and Landing Pages
Technologies I use:
Front End: HTML, CSS, JavaScript, jQuery, Bootstrap, MobX, React, React-Router, Reach-Router, Material-UI
Back End: Node, Express, PostgreSQL, MongoDB, Mongoose, Bcrypt, JsonWebToken
Tools: Babel, Parcel, Webpack, Version Control/Git, Postman, Chrome Devtools
APIs: Stripe, Plaid etc.
My Portfolio: https://amit-ghosh.com My GitHub: https://github.com/maverickamit
Please feel free to reach me at my email from portfolio for any inquiries.
Email: hello@baza7.ro
Website: https://www.baza7.ro
Skills: .NET, .Net Core, AI, AWS, AWS S3, AWS SES, Accelerated Mobile Pages, Adobe Creative Cloud, Algorithmic Trading, Arduino, Argo Workflows, Automated testing, Autosar, Azure, Bash, Blazor, Blockchain, C, C#, C++, CI/CD, CSS, Chatbots, Clean Architecture, Cloud, Code First Database Design, Copywriting, Cross-platform mobile development, Desktop Application, Docker, Elasticsearch, Embedded C, Embedded Systems, Entity Framework, Express, FFMPEG, Facebook Ads, Full stack web, GCP, Gatsby, Git, Grafana, Graphic Processing, Growth Hacking, Gulp, HTML, HTML/CSS, Image Processing, ImageMagick, Integration testing, JBoss EAP, JPA, JSON, JUnit, JWT, Jenkins, Kafka, Kibana, Lead generation, Linux, Liquibase, Machine Learning, Management, Maps, Mentor, Microservices, MongoDB, Multithreading, MySQL, NLP, Next.js, Node.JS, Objective-C, OpenGL, PHP, PWA, PostgreSql, Product Management, Prometheus, Protobuf, REST, RabbitMQ, React, React Native, Redshift, Redux, SQL, SQL Server, Scss, Social Media, SonarQube, Spring, Spring Boot, Startups, Swift, Symfony, TDD, Team Management, Tomcat, Topshelf, UI, UI/UX, UX, Unit Testing, Video Processing, Vue, Web backend, Web frontend, Webpack, Wordpress, Xamarin, android, angular, animations, backend, dart, django, flutter, frontend, home pages, iOS, java, javascript, kotlin, kubernetes, landing pages, marketing, mobile development, no-sql, nuxt, python, rest api, tailwind
Email: me@bolocan.eu
LinkedIn: https://www.linkedin.com/in/petre-cosmin-vlad-bolocan/
Skills: C#, .NET Framework, .NET Core, .NET 5 rest API, Angular 2+, TypeScript, Angular.js, Javascript, MongoDB, Angular Material, PrimeNG
I grew up with the internet, uploaded my first websites to geocities, was tech-admin of a lot of bulletin boards and have been doing professional code since 2003. After trying to build my first start-up in 2006 I realised that they just won’t come only because I built it. Therefore, I have a bachelor economical psychology, which helps me immensely with team leadership but also allows me to view the product from multiple perspectives.
Since then I have been freelancing with the exceptions of 6 years where I have been exclusively working with one of germanies biggest conference companies to establish their internal and external tech products as well as their IT department. This was the beginning of leading and hiring diverse international teams for me, therefore kanban, scrum and design thinking are not foreign to me. Some I have even taught to clients, when I wear my consultant hat.
That hat also enables me to train others in what I have learned, makes me easygoing as a person and also not afraid of talking to other departments or clients. Overall I have 7 years of hands on (mid level) CTO experience but never really stoped coding since I was 11. I currently specialise in Golang, Kubernetes and how to best make them work together. I write minimal containers with distroless, build clusters from scratch, know my GitOps (also how to set them up) and currently like to play with the kubernetes api directly through the official go-client or the operator sdk among much more. I believe the kubernetes API is the actual key to multitenant deployments as well as more refined scaling techniques.
I started working when Servers where still mostly dedicated, have lived the revolution of virtual servers, made a short stop at serverless tech and am now invested in the kubernetes ecosystem and its containers. My preferred cloud is AWS, but I have worked on others and also like to tame bare-metal and everything in-between. I love solving difficult issues and do most of my work in development containers.
All this makes me perfect if you are looking for someone with seniority, that is flexible, plays well with others but also likes to get his hands dirty.
Technologies:
Dear Johannes, you should know that you're great at marketing, too! One of the best headlines I've seen in a while :)
It might be helpful to mention where you are usually located, so people that want to hire you have a sense of the timezone you work in.
sorry for only now seeing this and thank you for the compliment =)
as for the location, I am currently located in Berlin, Germany or in the CET timezone, which means that for instance San Francisco is regularly in my timeline from 07 to 10 am. https://24timezones.com/difference/san_francisco/berlin
For the eastcost its even better as 8 am to 1 pm for them =) https://24timezones.com/difference/new_york/berlin
In General though, this has not created issues for me yet. I would even propose that it is an advantage, because I get stuff done before you get up, which, in most cases ;), means that I can make your morning better by reporting in.
Full-stack app developer with experience in data-rich apps.
Keywords: React, TypeScript, Flask, Python, PHP, Symfony, WebGL, D3, WebRTC, AWS, Docker, Git
Contacts:
matjaz@matjazdrolc.eu
https://github.com/drola/
https://www.linkedin.com/in/matja%C5%BE-drolc-aa63213a/
https://drola.si/
Past projects include:
- managing full software lifecycle, including planning, coding and deployment on cloud (AWS) or on-premises (Docker, VMs, bare metal)
- video: transcoding and delivery of a video archive to web browsers and live streaming with HLS and WebRTC.
- interactive 3D visualization of technical measurements with contextual information (tech stack: WebGL, Three.js, RxJS)
- 2D charts with various twists, including data transfers and rendering with varying levels of detail
- UIs with synchronized maps, video, and charts
- performance optimization by profiling and, if required, rewriting specific parts in C++
- complex Excel reports optimized for printing (language: C#)
Mechatronics engineering student looking for freelance projects involving PCB design and manufacture; also experienced with 3D printing and mechanical design - have a prototype or idea laying around but no time or clue how to turn it into a working board? Get in touch with me at danikinader@gmail.com
Location: The Netherlands/Spain
Remote: Yes, remote only
Willing to relocate: No
Technologies: 15+ years server administrator experience in Linux and Windows Server environments with a multitude of different technologies and applications.
6+ years software development experience in Objective-C, Java, Laravel PHP, Python, C, NodeJS, Swift, Shell scripting, Javascript.
I have built and run a webhosting and a VPN service. My experience helps me to connect the dots quickly and implement new technologies fast.
Résumé/CV: https://joosthoogendoorn.com
Email: Please see my website for contact information
Tribe.ai is a community of top tier AI/ML folks who come together to work on interesting projects (mostly for growth startups but also a few public companies). Beyond that we really try to get together as a community and support one another with events, lunch and learn sessions, and a few people have gotten together to work on startup ideas.
If you're interested, please apply to join (only takes ~5 mins) https://www.tribe.ai/join