Strangely enough, there's even some likelihood that killing off the passenger pigeon actually promoted Borrelia burgdorferi. The passenger pigeon's main food source was tree mast. Large flocks of pigeons would descend and clear the forest floor of food. After it went extinct, the population of small animals which also eat tree mast exploded, and these are reservoir species for Borrelia.
If you're regularly syncing from an older version to a new version, you can likely optimize further using gzip with "--rsyncable" option. It will reduce the compression by ~1% but make it so differences from one version to the next are localized instead of cascading through the full length of the compression output.
Another alternative is to skip compression of the dump output, let rsync calculate the differences from an previous uncompressed dump to the current dump, then have rsync compress the change sets it sends over the network. (rsync -z)
Transportant helps K12 school systems keep students safe by making their school buses smarter. This also reduces fossil fuel use and helps the environment.
There are 560k school buses in active use in North America. It's a larger industry than all other public transportation combined. Bus driver staff turnover approaches 160% annually. Technology helps new and substitute drivers learn routes and students and make sure students get off at the right stops.
Transportant builds modern hardware and software. Features include bus wifi for students, touch screen for drivers, a mobile app for parents, custom live streaming cameras, remote "speak into the bus" ability for administrators, ridership management, safety sensors, and improved routing.
Founded by veterans of the software security and mobile industry, Transportant is a small but senior team of Linux hackers, security engineers, database and systems builders, UX and industrial design. Our customers are school systems across the USA and Canada who are overjoyed with modern UX for transportation. We are seeking multiple backend software developers to join our team.
The backend tech stack is Linux, PostgreSQL, Go, and Python. Much functionality is implemented directly in the database. Frontend is supported through REST and GraphQL APIs. Other examples of technology we love: Wireguard, Single board computers, Linux, Ansible, Prometheus, Typescript, Javascript, React, and Open Street Maps. Not so much: XML, Java, ASN.1, Dual EC DRBG, Printers.
If working on any of the above sounds fun to you please email build@transportant.com to get started. Intro letter only is sufficient.
Transportant | Electrical Engineer | USA | Full-Time/Flexible | Kansas City but REMOTE | $120k-$180k
Transportant provides hardware and software to make k12 student transportation transparent, safe, and efficient for students, parents, bus drivers, teachers and administrators. This includes providing high speed on bus wifi for students, bus status notifications to parents and students via mobile apps, cameras with live streaming audio and video, turn-by-turn directions for substitute drivers, ridership tracking and management, and added safety sensors.
Started by 20 year veterans of the software security, supply chain, and mobile industries, Transportant is a small but senior technical team. Our customers are school systems across USA and Canada and are overjoyed with modern UX for transportation.
We're hoping to meet an electrical engineer to review and help iterate our hardware. This role could be full time or contract.
Responsibilities:
- Assisting in physical product life cycle of our hardware (currently designing v4 hardware):
- Testing & Manufacturing (working with partners to improve manufacturability, inspecting and critiquing test runs)
- Troubleshooting (identifying problems, down to the component level)
- Monitor, evaluate, and improve production & vehicle installation processes
Requirements:
- Have been involved with product development cycles of semi complex electronics with deployment at scale
- Proficient use of common electronics tools and diagnostic instrumentation
- Clear written documentation skills
- Non-required bonus: skill with embedded development
Application process is fast and simple: initial video conf with founders -> small work sample test or discussion of related previous projects -> offer/decline. No whiteboard tests! Please send an email to build@transportant.com to start the conversation.
Transportant | Multiple: Hardware & Backend Software | USA | Full-Time or Freelance | Remote | $120-$150k | https://transportant.com/
Transportant delivers modern hardware and software to help school districts, bus drivers, students, parents, and teachers optimize the school transportation experience. This includes providing high speed on bus wifi for students, bus status notifications to parents and students via mobile apps, cameras with live streaming audio and video, ridership tracking and management, and added safety sensors.
Founded by 20 year veterans of the software security and mobile industries, Transportant is a small but senior technical team. Our customers are school systems who are overjoyed with modern UX for transportation.
Hoping to meet a:
- Backend systems programmer comfortable with hardware and Linux sysadmin in an IoT context
- EE w/ automotive background to review and help iterate hardware
Hardware includes Raspberry Pi, custom accessory boards, cellular, IP cameras, cases, wiring, mounts, etc. Backend software stack is Linux, PostgreSQL, Go, and Python. Other tech we love: Wireguard, Ansible, Prometheus, Typescript, Javascript, React, and Open Street Maps. Not so much: XML, Java, ASN.1, Dual EC DRBG, Printers.
To start a conversation please just send a brief cover letter to build@transportant.com. No whiteboard coding required :-)
psql also allows you to set local variables and interpolate them into SQL. Values can be assigned from query results or with shell style back ticks! Powerful and frightening!
From the manual:
=> SELECT 'hello' AS var1, 10 AS var2
-> \gset
=> \echo :var1 :var2
hello 10
testdb=> \set content `cat my_file.txt`
testdb=> INSERT INTO my_table VALUES (:'content');
Is there a reason you don't wish to batch inserts into transaction(s)? Otherwise, you're asking the database to commit (fsync to disk) between each insert statement.
Other ideas:
- Have multiple processes inserting in parallel (this interacts with the commit_delay and commit_siblings settings in postgresql.conf)
- Use unlogged tables (but table is truncated on db startup)
- Put fsync=off and synchronous_commit=off in postgresql.conf (but db may be corrupted in a crash)
- switching to BRIN indexes might be an option, but depends on data
I do batch the inserts into a large transaction, and usually optimize for the transaction to commit in approximately ~10s. Not sure if it is optimal, but I like to monitor it like that.
BRIN indexes actually work for some of the data types I'm working with! Thank you for pointing those out!
Ah that's awesome! I'd love to more know! How are you using B2 in general, and does this make it easier for you? If you want to leave a note here, or you can send it to: b2feedback@backblaze.com!
Transportant | Marketing Director | USA | Full-Time | Kansas City but REMOTE | $60-$120k
Started in 2017, Transportant is a disruptive technology company building modern hardware and software to help school districts, bus drivers, students, parents, and teachers optimize the school transportation. This includes providing high speed on bus wifi for students, bus status mobile apps, cameras with live streaming audio and video, ridership tracking and management, turn by turn directions, and safety sensors. During COVID19 our tech has helped transportation departments pivot to their new mission of delivering free & reduced rate meals during school shutdowns, and providing outdoor Internet connectivity spots for underprivileged students.
The founders are 20+ year veterans of mobile and software security industries. Our customers are school systems across the USA and Canada, with the Superintendent or Director of Transportation as the champion/purchaser. We're seeking the first full time marketing role. This would involve working with founders and with support from our engineering team. Activities start with marketing basics and expand to experiments to find effective, measurable, and scalable traction channels.
Application process is fast and simple: email cover letter -> initial video conf with founders -> work sample test -> offer/decline. build@transportant.com
