The Assistant
kagi.com
The Assistant
Search within yourself: eliminate any manipulative strategy that tempts you. This is what Authentic Sales is all about.
George Kao • Authentic Selling
What Is Ethical Marketing?
youtu.beFirst, if and when you need to merge two databases that now have the same Primary Key ID values for the same table, your screwed. You have to come up with a scheme to change the ID’s, maybe adding 10,000 to each ID, what if you have more than 10,000 rows? The you also have to update all children records, maybe not that easy if you have constraints ... See more
Tom Jay • Stop using Integer ID’s in your Database
Django Index Concurrently | Django Migrations | Shaping Database Schemas
youtube.comOptimizing Further
Creating so many indices and aggregating so many tables is sub-optimal. To optimize this, we employ materialized views, which create a separate disk-based entity and hence support indexing. The only downside is that we have to keep it updated.
CREATE MATERIALIZED VIEW search_view AS
ᅠᅠSELECT c.name FROM company c UNION
ᅠᅠSELECT c.na... See more
Creating so many indices and aggregating so many tables is sub-optimal. To optimize this, we employ materialized views, which create a separate disk-based entity and hence support indexing. The only downside is that we have to keep it updated.
CREATE MATERIALIZED VIEW search_view AS
ᅠᅠSELECT c.name FROM company c UNION
ᅠᅠSELECT c.na... See more
How Levels.fyi Built Scalable Search with PostgreSQL
Phase #2—Set up the pre-frame bridge: Based on the type of traffic you’re sending, what type of pre-frame bridge do you need to create? Phase #3—Qualify subscribers: Who of all your visitors are willing to give you their email address in exchange for your free offer? Phase #4—Qualify buyers: Who of all your subscribers are willing to give you their
... See more